Course Outline
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 (Data Manipulation Language) 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
SQL Dialects Overview
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Basic computer skills.
Testimonials (5)
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The instructor explains everything in a way that is very easy to understand. He's super good at teaching.
Elaiza Marie Parumog - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
Mr. Bless has a very friendly and pleasant personality and always knows how to motivate participants with his experience and enthusiasm, encouraging them even during tricky exercises! He consistently ensured that all participants understood the content and addressed any questions. Good exercises help to quickly apply the theoretical part in practice. Overall, the organization and tailoring of the training to the participants' requirements by Nobleprog were very professional. Thank you very much!
Timo Koch - Swiss International Air Lines Ltd.
Course - SQL Advanced level for Analysts
Machine Translated
The course built lesson to lesson, and the pacing was a big deal for me.
