SQL Tutorials

Databases are similar to storage containers in that they hold information in a logical and convenient format. Your job as a database guru is to create and manage databases.

The Inner Workings of a Database

A database can have one table or many tables. Imagine if you are looking at an excel sheet, there are columns and rows in every book. The same principle applies to a database table. Just like you can have many books in an excel sheet, you can have many tables in a database.

Here’s an example table with 3 columns and 1 row, the top row are the names of the column:

Posted January 26, 2008 Comments(1)

I hope to make learning SQL very simple and easy with these tutorials. I have written tutorials on other subjects, but never on SQL, I am however experienced with it. I have created numerous database driven websites and have managed large scale websites that use databases as a foundation, such as forums.

With these tutorials I am going to go step-by-step. I am going to show you what information the database holds, and when I
show a command I will show you what will be returned.

The tutorials here refer to MySQL database software, which can be obtained for different platforms at no cost from http://www.mysql.com.

One thing to keep in mind is that there is very little difference in syntax between using Oracle, Mysql, or MSsql. They all use sql as a basis, but run on different engines so to speak.

Posted January 25, 2008 Comments(0)