SQL Tutorial

SQL Tutorial

SQL stands for Server Query Language. SQL is widely used for querying database. Database is a big topic; we are not going to cover everything in this tutorial. Here you will learn basics commands for manipulating databases.

What is database ?
Database is a place where we store data. Each and every computer and server application needs a database to store their data. Data are stored in the form of Tables. Database contains huge number of tables, and under each table there will be tons of records. By combining power of scripting language and database, we can build powerful applications.

Database Tables:

All data in the database are stored in the form of Tables. Each database has one or more tables and under each tables there will be huge number of records. Each table is identified by unique name. Here is the example table.

Table Name – “StudentsDB”.

ID Name Age Grade
1 John 18 A
2 Paul 19 A
3 Jesse 18 C
4 Jenny 18 B

Above table have 4 rows and 4 columns.

For this tutorial you need a database program installed in your computer. There are lots of database programs, like MS Access, Oracle, MySQL, SQL Server, DB2. For this tutorial I am going to use MySQL. Here is the detailed tutorial for installing and configuring MySQL. If you have any other database program installed in your Computer, then no problem, you can practice with that.