Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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.
14 Hours
Testimonials (5)
Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.
Kurt - Complete Coherence
Course - SQL For Data Science and Data Analysis
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The training materials.
Mona Dobre - DB Global Technology
Course - SQL Advanced level for Analysts
I liked that he was able to talk me through each of the exercises and explain the reasoning behind each component of the queries
Erik McConnon - Quality Resource Group
Course - SQL in One Day
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
