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
- The relationship between correlation and performance
- Application of CASE, IF, and COALESCE functions
- Effective use of variables
- Data casting and conversion
- Handling NULL values and utilizing NULL-safe operators
- Implementing regular expressions via the REGEXP operator
- MySQL-specific grouping functions (e.g., GROUP_CONCAT)
- Utilizing GROUP BY WITH ROLLUP
- Employing EXISTS, ALL, and ANY conditions
- Managing multitable OUTER JOINs
- Refactoring subqueries into joins
DML (Data Modification Language)
- Performing multi-row inserts
- Inserting data via SELECT statements
- Incorporating subqueries into DML operations
- Using variables within DML queries
- Implementing table and row locking mechanisms
- Updating data across multiple tables
- Utilizing the IGNORE clause
- Utilizing the REPLACE clause
- Differences between DELETE and TRUNCATE
DDL (Data Definition Language)
- Creating tables based on SELECT results
- Working with temporary tables
Stored Procedures
- A brief introduction to 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.
