SQL Programming

RDBMS (Relational DataBase Management System)

Relational Operators

SQL as Declarative Language

SQL Syntax

SQL Sublanguages DQL, DML, DDL, DCL

DQL (Data Query Language) in Detail

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) Overview

Inserting rows (INSERT)

Inserting rows using subquery

Updating rows (UPDATE)

Deleting rows (DELETE)

DDL (Data Definition Language) Overview

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

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

CONSTRAINTS Overview

NULL i NOT NULL

CONSTRAINT clause

ENUM type

SET type

PRIMARY KEY

UNIQUE

FOREIGN KEY

DEFAULT clause

Transactions Overview

COMMIT

ROLLBACK

SAVEPOINT

Implicit and explicit rollbacks and commits

SQL Dialects Overview

MySQL

Microsoft Access and SQL Server

Oracle and PostgreSQL