Introduction To Structured Query Language (SQL) – Part 1

Topics by page

• Topics and references

• Relational databases – overview

• SQL – overview

• DML: Data retrieval – SELECT statement (examples)

• DML: Data retrieval – SELECT statement (criteria)

• SQL for SELECT exercises with criteria

• DDL – CREATE TABLE statement (from existing table)

• DDL – CREATE TABLE statement (with column definitions)

• DDL – CREATE TABLE statement (syntax)

• DDL – CREATE INDEX statement

• DDL – ALTER TABLE statement

• DDL – DROP statement

• DML – INSERT statement

• DML – UPDATE statement

• DML – DELETE statement

Using the MS Access SQL window

All pages