This focused hands-on course is for developers who already know the MySQL basics and want to further expand their knowledge. Learners will build real skills with advanced queries, stored procedures, CTEs, functions, and more. The course effectively prepares for the official MySQL Developer certification.
MySQL for Developers
Become a MySQL expert for real-world development
Over five focused days, this immersive course gives you the skills to use MySQL’s advanced developer features with confidence. You’ll work with subqueries, window functions, stored routines, custom functions, NoSQL integrations and more, so you can write smarter SQL and design efficient, effective solutions.
Learning objectives
- Use advanced SQL expressions and logic
- Build and call stored routines
- Create triggers and custom functions
- Work with Common Table Expressions (CTEs)
- Use window functions for analytics
- Import/export data from CLI and SQL
- Handle exceptions and debug queries
- Optimise queries for performance
What you’ll learn
This expert-led course takes you beyond the fundamentals to explore MySQL’s most powerful developer features. You’ll build solutions that combine advanced SQL, structured logic, automation, and performance tuning. By the end of the course, you’ll be able to design and implement efficient and scalable SQL solutions that meet complex, real-world requirements.
Client/server and tooling
Explore how MySQL operates behind the scenes, starting with client/server architecture, server modes, and configuration file management. You’ll learn how login precedence works, how to connect securely, and how to maximise productivity using the MySQL Client interactively and through command-line scripts. Gain practical experience with MySQL Utilities for exporting, importing, and managing output formats such as HTML and XML, and learn tips for integrating client tools into your workflow for faster and more efficient database management.
Advanced SQL and expressions
Strengthen your ability to write sophisticated SQL by combining numeric, string, and temporal functions with conditional and flow control logic. You’ll work with comparison operators, nested queries, set operations, and MySQL-specific expressions to produce precise, reliable outputs. This includes handling NULLs, applying collation rules for sorting, and using advanced ordering techniques. The skills you gain here will help you produce queries that are both powerful and easy to maintain in complex systems.
Subqueries and CTEs
Learn how to work with the full range of subquery types, from correlated subqueries that adapt to each row in a parent query, to multi-column and scalar forms for flexible data retrieval. You’ll also use derived tables for temporary results and explore the WITH clause to create Common Table Expressions (CTEs), including recursive CTEs for hierarchical or iterative data problems. These techniques help simplify query structures, improve clarity, and make complex logic more reusable.
Stored routines and functions
Develop reusable, modular database code by creating stored procedures and functions. You’ll learn how to declare variables, manage constants, and use programme logic such as loops, CASE statements, and conditional branching. You’ll also cover differences between procedures and functions, handling parameters securely, and managing execution rights. This approach supports better code organisation, reduces repetition, and helps you maintain consistent business rules across applications.
What’s included
- 5 days of hands-on training with experts
- Real-world code labs and examples
- Course handbook and cheat sheets
- Certificate of attendance
- Support for MySQL 8.0 features
- Coverage of 1Z0-909 exam topics
Key facts
Ideal for
Developers and technical professionals with MySQL and SQL experience who want to build advanced database applications and write better, more powerful queries.
Prerequisites
You should be comfortable with basic SQL and have some hands-on experience using MySQL. If you’ve taken our Introduction to MySQL course, you’ll have appropriate knowledge for this course.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
This engaging course is designed for developers who want to expand their MySQL skills for stronger career development, covering advanced SQL queries, stored routines, triggers, data optimisation, and integration with modern tools and technologies.
Who should take the MySQL for Developers course?
This course is ideal for developers who already understand basic SQL commands and want to expand their skills in writing advanced queries, building stored routines, and optimising database performance. It’s perfect for those looking to apply these skills in real-world development projects.
What topics are covered in the training?
The course covers client/server concepts, advanced SQL expressions, subqueries, Common Table Expressions (CTEs), stored routines, triggers, window functions, data import/export, MySQL and NoSQL integration, performance optimisation, and more.
Is this course suitable for MySQL beginners?
Not quite. You should already be comfortable with basic SQL commands like SELECT, INSERT, UPDATE, and DELETE. If you’re new to MySQL, our Introduction to MySQL course is the recommended starting point before joining this one.
Will I learn how to optimise MySQL queries?
Yes. The course dedicates time to performance tuning, including how to use indexes effectively, analyse queries with EXPLAIN, normalise data, and choose the right storage engine for your workload.
What our customers say
‘I really enjoyed this course, it was clear the instructor had in-depth knowledge about the subject and was keen on answering questions / explaining problems thoroughly. I also appreciated learning about the principles, best practice standards, and the reasoning behind these.’
Michaela, Data Scientist – Government
‘This is now my second course with John at StayAhead and once again the delivery was simply excellent. Best fun I've had at work for a while now and would very highly recommend the course to anyone who's taking on more PL/SQL work in their job. Hoping to come back for more in the future!’
Ashley, AppOps Engineer (Jr DBA) - Government
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our training
5,000+ businesses
A trusted partner to thousands of organisations worldwide
96% customer satisfaction
Our passionate team goes above and beyond to support customer needs