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
- Correlation and performance optimization
- Utilizing CASE, IF, and COALESCE functions
- Implementing variables
- Data casting and conversion techniques
- Managing NULL values and employing NULL-safe operators
- Applying regular expressions via the REGEXP operator
- MySQL-specific aggregation functions (e.g., GROUP_CONCAT)
- GROUP BY with ROLLUP
- Using EXISTS, ALL, and ANY operators
- Performing multi-table OUTER JOINs
- Converting subqueries into JOIN operations
DML (Data Modification Language)
- Executing multi-row inserts
- Inserting data using SELECT statements
- Incorporating subqueries into DML commands
- Utilizing variables within DML queries
- Table and row locking mechanisms
- Updating data across multiple tables
- Employing the IGNORE clause
- Applying the REPLACE clause
- Differentiating between DELETE and TRUNCATE operations
DDL (Data Definition Language)
- Creating tables from SELECT results
- Working with temporary tables
Stored Procedures
- Overview of MySQL stored procedures
Requirements
Proficient 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.
