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