Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
The Fastest Way to Become a Backend Developer Online
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn essential intermediate MySQL concepts through a comprehensive tutorial series covering joins, unions, string functions, case statements, subqueries, and window functions. Master different types of joins to combine data from multiple tables, understand how to use unions to merge result sets, and explore powerful string manipulation functions for data cleaning and formatting. Develop skills in writing conditional logic with case statements, create complex nested queries using subqueries, and harness the power of window functions for advanced data analysis and ranking operations. Each topic builds upon fundamental MySQL knowledge to help you write more sophisticated and efficient database queries for real-world data scenarios.
Syllabus
Joins in MySQL | Intermediate MySQL
Unions in MySQL | Intermediate MySQL
String Functions in MySQL | Intermediate MySQL Series
Case Statements in MySQL | Intermediate MySQL
Subqueries in MySQL | Intermediate MySQL
Window Functions in MySQL | Intermediate MySQL
Taught by
Alex the Analyst