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)
- Correlations within FROM, WHERE, SELECT, and HAVING clauses
- Correlation and performance optimization
- Employing CASE, IF, and COALESCE functions
- Working with variables
- Type casting and conversion
- Handling NULL values and NULL-safe operators
- Applying regular expressions via the REGEXP operator
- MySQL-specific grouping functions (e.g., GROUP_CONCAT)
- GROUP BY WITH ROLLUP
- Utilizing EXISTS, ALL, and ANY
- Multi-table OUTER JOINs
- Converting subqueries into JOINs
DML (Data Modification Language)
- Inserting multiple rows
- INSERT via SELECT
- Incorporating subqueries into DML statements
- Using variables within DML queries
- Locking tables and rows
- Updating data across multiple tables
- The IGNORE clause
- The REPLACE clause
- Differences between DELETE and TRUNCATE
DDL (Data Definition Language)
- Creating tables using SELECT
- Temporary tables
Stored Procedures
- Brief introduction to MySQL stored procedures
Requirements
A strong foundation 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.
