Databases Archive
Installing MySQL and phpMyAdmin on Windows using EasyPHP ( WAMP )
Databases
Nov 07, 2013
MySQL is an open-source database management system used mainly for relational databases. It is considered the second mostly used open-source DBMS following SQLLite. MySQL is being deployed for many high-profile and large scale website including Facebook, youtube, twitter and Flickr. phpMyAdmin is a nice web application that is mainly used for creating,
...Read More
Drawing ER Diagrams with Dia Tool using Chen Notation
Databases
Nov 06, 2013
Dia is a general purpose drawing software for Windows, Mac OS X and Linux. Dia supports more than 30 different diagram types like flowcharts, network diagrams, database models. More than a thousand readymade objects help to draw professional diagrams. Software developers and database specialists can use Dia as a CASE tool to
...Read More
Database Porgramming : Creating a simple phone book using Java & a database ( HSQLDB )
Databases, Java Programming, SQL
Apr 23, 2013
[info] You to have Java and Eclipse Configured and Installed. If not please install the JDK and download Eclipse[/info] In one of the last tutorial, we have created a simple phonebook system using a text file and Java Programming. For more details, click here. In this tutorial, we will be creating the
...Read More
Java & HSQLDB : Connecting to a DBMS (HSQLDB) from Java Program
Databases, Java Programming, SQL
Apr 17, 2013
[info]In case you don’t have the HSGLDB, You can download the DBMS : HSQLDB from here [/info] 1) Create a simple file and call it Simple.java. Here is a simple code written in Java to connect to a DBMS : import java.io.*; import java.sql.*; import java.util.*; public class Simple { public static
...Read More
Join : SELECT Tutorial using multiple database tables
The JOIN is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. Tables in a database are often related to each other with keys. [info] In case you are not familiar with SELECT, visit this tutorial : SQL
...Read More
SQL SELECT Tutorial : Searching & Querying the database
The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must
...Read More
SQL Tutorial : Creating a Table and Inserting data ( MySQL & HSQLDB )
In this tutorial, we will learn how to create a database table and insert data into it, The example we will consider is a simple phone book to store names, last names, ages, email and phone numbers for people. What is SQL? SQL stands for Structured Query Language SQL lets you
...Read More
SQL Hello World: A simple guide to database systems using HSQLDB
In this tutorial, we will learn how to create a simple database and play with its content. The example we will consider is a simple phone book to store names, last names and phone numbers for people. 1) We need to download the DBMS ( HSQLDB ): [a software that eases and
...Read More
- 1
- 2