MySQL Advanced Querying

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst, data scientist and BI professional should seek to master.

In this course, we’ll move beyond the basic "Big 6" clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY) and cover advanced querying techniques like JOIN types, subqueries, CTEs and window functions.

From there, we’ll introduce advanced functions used for manipulating various data types, including numeric, datetime, string and NULL functions.

Finally, we'll practice solving real-world business problems and common data analytics use cases by applying advanced querying techniques like pivoting with CASE statements, calculating running totals with window functions, and more.

If you're looking for a hands-on, practical guide to advanced querying with MySQL, this is the course for you.

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Analysts or BI professionals looking to analyze data stored in relational database systems
• SQL users who want to develop advanced querying skills
• Anyone looking for a hands-on, practical, and highly engaging way to master MySQL for advanced data analysis

WHAT ARE THE COURSE REQUIREMENTS?

• MySQL Workbench and Community Server (we’ll walk you through the install process)
• If you are new to MySQL, we strongly recommend taking the basic MySQL Data Analysis course first