SQL Fundamentals

DBMS (Relational DataBase System) Relational Operators as Declarative Syntax Sublanguages DQL, DML, DDL, DCL DQL (Data Query ) 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 ) Overview
• Inserting rows (INSERT)
• Inserting rows using subquery
• Updating rows (UPDATE)
• Deleting rows (DELETE)
• DDL (Data Definition ) 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
• Dialects Overview
• Microsoft Access and Server
• and PostgreSQL