SQL Tutorial

[edit] Basics

1. Introduction

Syntax, history

2. DDL

Table, View, Index, Constraints, ...

3. DML

Insert, update, delete, select

4. Queries

SELECT FROM WHERE, conditions, aggregation ...

5. DCL

User, Role, Group, Grant, Revoke

6. Data types

Numeric, strings, date, ...

7. Index

BTree, Hash, bitmap ... and their principles

8. Database design

Constraints, References,

9. Procedure Language

PLSQL/TSQL, functions

10. Database Management System(DBMS)

MySQL, PostgreSQL, MS SQL, DB2, Oracle ...