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
- Utilizing CASE, IF, and COALESCE functions
- Implementing variables
- Casting and data conversion techniques
- Handling NULL values and NULL-safe operators
- Applying regular expressions via the REGEXP operator
- MySQL-specific GROUP BY functions (e.g., GROUP_CONCAT)
- GROUP BY WITH ROLLUP functionality
- Using EXISTS, ALL, and ANY operators
- Multi-table OUTER JOINs
- Converting subqueries into JOINs
DML (Data Modification Language)
- Inserting multiple rows
- INSERT operations via SELECT
- Incorporating subqueries within DML statements
- Utilizing variables in DML queries
- Table and row locking mechanisms
- Updating data across multiple tables
- Employing the IGNORE clause
- Employing the REPLACE clause
- Differences between DELETE and TRUNCATE
DDL (Data Definition Language)
- Creating tables using SELECT statements
- Working with temporary tables
Stored Procedures
- Brief overview of MySQL stored procedures
Requirements
Proficient understanding 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.
