SQL (Structured Query Language) is a computer language aimed to store, manipulate, and retrieve data stored in relational databases. The first incarnation of SQL appeared in 1974, when a group in IBM developed the first prototype of a relational database. The first commercial relational database was released by Relational Software (later becoming Oracle).
Standards for SQL exist. However, the SQL that can be used on each one of the major RDBMS today is in different flavors. This is due to two reasons: 1) the SQL standard is fairly complex, and it is not practical to implement the entire standard, and 2) each database vendor needs a way to differentiate its product from others. In this tutorial, such differences are noted where appropriate.
This SQL programming help site lists commonly-used SQL statements, and is divided into the following sections:
Standards for SQL exist. However, the SQL that can be used on each one of the major RDBMS today is in different flavors. This is due to two reasons: 1) the SQL standard is fairly complex, and it is not practical to implement the entire standard, and 2) each database vendor needs a way to differentiate its product from others. In this tutorial, such differences are noted where appropriate.
This SQL programming help site lists commonly-used SQL statements, and is divided into the following sections:
- SQL Commands: Basic SQL statements for storing, retrieving, and manipulating data in a relational database.
- Table Manipulation: How SQL statements are used to manage tables inside the database.
- Advanced SQL: Advanced SQL commands.
- SQL Syntax: A single page that lists the syntax for all the SQL commands in this tutorial.
