SQL Language

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Language Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language)

SELECT clause

Column aliases

Table aliases

Date types and Date functions

Group function

Table joins

JOIN clause

UNION operator

Nested queries

Correlated subqueries

DML (Data Modification Language)

Inserting rows (INSERT)

Inserting rows using subquery

Updating rows (UPDATE)

Deleting rows (DELETE)

DDL (Data Definition Language)

Creating, altering and dropping objects (CREATE, ALTER, DROP)

Creating tables using subquery (CREATE TABLE .... AS SELECT...)

CONSTRAINTS

NULL i NOT NULL

CONSTRAINT clause

ENUM type

SET type

PRIMARY KEY

UNIQUE

FOREIGN KEY

DEFAULT clause

Transactions

COMMIT

ROLLBACK

SAVEPOINT

Implicit and explicit rollbacks and commits

SQL Dialects

MySQL

Microsoft Access and SQL Server

Oracle and PostgreSQL