SQL Tutorial

• 1 of 6
• next ›

This tutorial shows basic information about SQL. All examples you can try with DatAdmin on chinook database, which is by default part of DatAdmin installation.

SQL data manipulation language

SQL in standard language for working with databases. With SQL, you can extract data from database (SELECT), change data (UPDATE), remove data (DELETE), add new data (INSERT). These commands are called data manipulation language (DML). DML is very similar for all database engines, it is highly standardized. Majority of described features are part of SQL-92 standard.

SQL data definition language

Second part of SQL is data definition language (DDL). This language contains at least commands for creating tables (CREATE TABLE), changing definition of tables (ALTER TABLE) and deleting tables (DROP TABLE). Different database engines define lot of DDL commands - all database objects in database must be able to be managed with DDL. So DDL is very different across different database engines, also standardization is quite poor. This tutorial doesn't deal with DDL.

• 1 of 6
• next ›