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)
- Understanding correlation within FROM, WHERE, SELECT, and HAVING clauses
- The impact of correlation on performance
- Utilizing CASE, IF, and COALESCE functions
- Effective use of variables
- Explicit casting and data conversion techniques
- Managing NULL values and employing NULL-safe operators
- Applying regular expressions using the REGEXP operator
- MySQL-specific grouping functions such as GROUP_CONCAT
- Implementing GROUP BY WITH ROLLUP
- Working with EXISTS, ALL, and ANY operators
- Executing multitable OUTER JOINs
- Converting subqueries into join operations
DML (Data Modification Language)
- Performing multi-row inserts
- Inserting data via SELECT statements
- Incorporating subqueries within DML statements
- Leveraging variables in DML queries
- Managing table and row locking mechanisms
- Updating data across multiple tables simultaneously
- Utilizing the IGNORE clause
- Utilizing the REPLACE clause
- Comparing DELETE and TRUNCATE operations
DDL (Data Definition Language)
- Creating tables from SELECT results
- Implementing temporary tables
Stored Procedures
- Overview of MySQL stored procedures
Requirements
A solid understanding of SQL is required.
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.
