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
- Impact of correlation on performance
- Application of CASE, IF, and COALESCE functions
- Utilizing variables
- Cast and conversion techniques
- Managing NULL values and NULL-safe operators
- Implementing regular expressions with the REGEXP operator
- MySQL-specific grouping functions (such as GROUP_CONCAT)
- GROUP BY WITH ROLLUP
- Application of EXISTS, ALL, and ANY
- Performing multitable OUTER JOINs
- Converting subqueries into joins
DML (Data Modification Language)
- Executing multi-row inserts
- Inserting data via SELECT
- Incorporating subqueries within DML statements
- Using variables in DML queries
- Locking tables and rows
- Updating data across multiple tables
- Using the IGNORE clause
- Using the REPLACE clause
- Distinguishing between DELETE and TRUNCATE
DDL (Data Definition Language)
- Creating tables using SELECT
- Working with temporary tables
Stored Procedures
- 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.
