SQL in SQL Server

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

• Inserting rows (INSERT)
• Inserting rows using subquery
• Updating rows (UPDATE)
• Deleting rows (DELETE)

• Creating, altering and dropping objects (CREATE, ALTER, DROP)
• Creating tables using subquery (CREATE TABLE .... AS SELECT...)

• NULL i NOT NULL
• CONSTRAINT clause
• ENUM type
• SET type
• PRIMARY KEY
• UNIQUE
• FOREIGN KEY
• DEFAULT clause

• COMMIT
• ROLLBACK
• SAVEPOINT
• Implicit and explicit rollbacks and commits

• What is Transact-SQL
• T-SQL and portability with other dialects (what to avoid)
• Handling Date