SQL for Data Analysis: Advanced SQL Querying Techniques

Learn advanced data analysis with SQL, and master topics like subqueries, CTEs, window functions, and more

Created by: Maven Analytics • 1,500,000 Learners
Empowering everyday people with life-changing data skills

Created by: Alice Zhao
Data Science Instructor at Maven Analytics

What Will I Learn?

• Conduct multi-table analysis using JOINs and learn variations like self joins, cross joins, and more
• Learn to work with nested queries by writing subqueries and common table expressions (CTEs), and understand the best use cases for each
• Use window functions to perform calculations across a set of rows and learn various function options and applications
• Discover the many SQL functions that can be applied to fields of numeric, datetime, string, and NULL data types
• Apply advanced querying techniques to common data analysis scenarios, including pivoting data, rolling calculations, and more

Requirements

• Any SQL Editor (we'll walk you through the install process specifically for MySQL Workbench)
• If you are new to SQL, we strongly recommend taking Maven Analytics' Beginner MySQL Business Intelligence course first

Target audience

• 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 SQL for advanced data analysis