PowerBI Data Analyst - Create visualizations and dashboards from scratch
AI Adoption - Drive Business Value and Organizational Impact
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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