Author Archive
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
Advanced Database Systems by Jun Yang
Course Notes
Nov 05, 2013
Jun Yang is an Associate Professor of Computer Science at Duke University. His primary research interest lies in the area of database and data-intensive computing. He received my M.S., Ph.D. from Stanford University and B.A. from University of California, Berkeley. This course “Advanced Database Systems” covers advanced database management system design principles
...Read More
Databases course by Timothy Griffin
Course Notes
Nov 05, 2013
Dr Timothy Griffin had earned his BS in Mathematics from the University of Wisconsin, Madison. PhD in Computer Science from Cornell University. Previous experience includes teaching at UNICAMP in Brazil and more than a dozen years at Bell Laboratories and AT&T Research. Joined the Computer Lab on January 1, 2005. Dr Griffin
...Read More
Advanced Databases by Imed Bouchrika
Course Notes
Nov 02, 2013
The Advanced Databases course is being taught by Imed Bouchrika at the University of Souk-Ahras. Imed Bouchrika received his Bsc and PhD degrees in Electronics and Computer Science from the University of Southampton in United Kingdom in 2004 and 2008 respectively. His research areas are image processing, biometrics and automated visual surveillance.
...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