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
DQL (Data Query Language)
- Correlation in FROM, WHERE, SELECT, and HAVING clauses
- Correlation and performance implications
- Using CASE, IF, and COALESCE functions
- Working with variables
- Casting and converting data types
- Handling NULL values and using NULL-safe operators
- Applying regular expressions with the REGEXP operator
- Useful MySQL-specific GROUP BY functions (such as GROUP_CONCAT)
- GROUP BY with ROLLUP
- EXISTS, ALL, and ANY operators
- Multi-table OUTER JOINs
- Converting subqueries into joins
DML (Data Modification Language)
- Inserting multiple rows at once
- INSERT ... SELECT statements
- Using subqueries within DML statements
- Working with variables in DML queries
- Locking tables and rows
- Updating data across multiple tables
- The IGNORE clause
- The REPLACE clause
- Understanding DELETE versus TRUNCATE
DDL (Data Definition Language)
- Creating tables using SELECT
- Temporary tables
Stored Procedures
- A brief introduction to MySQL stored procedures
Requirements
Strong knowledge of SQL.
7 Hours
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
