Certificate Authentication

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