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 in FROM, WHERE, SELECT, and HAVING clauses
- Correlation and performance implications
- Utilizing CASE, IF, and COALESCE functions
- Implementation of variables
- Data casting and conversion
- Handling NULL values and NULL-safe operators
- Applying regular expressions with the REGEXP operator
- MySQL-specific GROUP BY functions (e.g., GROUP_CONCAT)
- GROUP BY WITH ROLLUP
- EXISTS, ALL, and ANY operators
- Multitable OUTER JOINs
- Refactoring subqueries into joins
DML (Data Modification Language)
- Multi-row insertions
- INSERT via SELECT
- Incorporating subqueries within DML statements
- Employing variables in DML queries
- Table and row locking techniques
- Updating data across multiple tables
- The IGNORE clause
- The REPLACE clause
- Distinguishing between DELETE and TRUNCATE
DDL (Data Definition Language)
- Creating tables using SELECT
- Working with temporary tables
Stored Procedures
- Concise introduction to MySQL stored procedures
Requirements
Proficiency in SQL is required.
7 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 1300 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
