SQL Tutorial >> SQL Introduction.

SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, update, delete) and database creation.

Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use SQL as standard database language. Now a word of warning here, although all those RDBMS use SQL, they use different SQL dialects. For example MS SQL Server specific version of the SQL is called T-SQL, Oracle version of SQL is called PL/SQL, MS Access version of SQL is called JET SQL, etc.

Our SQL tutorial will teach you how to use commonly used SQL commands and you will be able to apply most of the knowledge gathered from this SQL tutorial to any of the databases above.

This SQL tutorial site lists commonly-used SQL statements, and it covers the following sections:

         1- SQL Data Manipulation Language (DML)
         2- SQL Data Definition Language (DDL)

In Structured Query Language we use syntax for executing queries. And the SQL language also covers a syntax to Select, Update, Insert, and Delete records in a database and these points of interacting with database is called DML.
In Select section we will learn how to extract data from the database.
In Update we will learn how to update data stored in database.
in Insert section we will see how can we insert our own records in database.
And in Delete section we will learn how to remove an existing record from database.

DDL covers how to Create Delete and Alter a Table or an Index.  In this section we will also cover the RDBMS, (Relational Database Management System). It means the relations of the database tables and indexes and impose constraints between database tables.
For each command, the SQL syntax we will first be presented and explained, followed by an example. At the end of this tutorial, you should have a good general understanding of the SQL syntax, and be able to write SQL queries using the correct syntax. Our experience is that understanding the basics of SQL is much easier than mastering all the particulars of this database language, and We are sure that you will reach the same conclusion as well.  SQL is quite easy to learn and you will really enjoy during learning with GGL.