SQL in SQL Server Training Course

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