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 (DataManipulationLanguage) 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
T-SQL Dialects Overview
What is Transact-SQL
T-SQL and portability with other dialects (what to avoid)
Handling Date