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 techniques and performance optimization
- Utilising CASE, IF, and COALESCE functions
- Working with variables
- Data casting and conversion methods
- Handling NULL values and NULL-safe operators
- Implementing regular expressions via the REGEXP operator
- MySQL-specific grouping functions, such as GROUP_CONCAT
- GROUP BY WITH ROLLUP functionality
- Employing EXISTS, ALL, and ANY operators
- Performing multi-table OUTER JOINs
- Transforming subqueries into join operations
DML (Data Modification Language)
- Executing multi-row inserts
- Inserting data via SELECT statements
- Incorporating subqueries within DML statements
- Using variables in DML queries
- Managing table and row locks
- Updating records across multiple tables
- Applying the IGNORE clause
- Using the REPLACE clause
- Comparing DELETE and TRUNCATE operations
DDL (Data Definition Language)
- Creating tables based on SELECT results
- Working with temporary tables
Stored Procedures
- A concise introduction to MySQL stored procedures
Requirements
A strong grasp of SQL concepts 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.
