SQL for Data Analysis: Advanced SQL Querying Techniques

This is a hands-on, project-based course designed to help you move beyond the "Big 6" clauses into advanced querying techniques.

We’ll start by reviewing the basics and conducting multi-table analyses, including basic joins, self-joins, cross-joins, and unions.

Next, we’ll cover different ways of working with nested queries by writing subqueries and common table expressions, or CTEs. We’ll walk through examples of subqueries within the various clauses, rewrite subqueries as CTEs, introduce recursive CTEs, and compare these techniques to other options like temporary tables and views.

From there, we’ll break down each component of a window function and review common window functions like ROW_NUMBER, RANK, FIRST_VALUE, LEAD, and LAG. We’ll also cover general functions for working with different data types in SQL, including numeric, datetime, string, and NULL functions.

Last but not least, we’ll take the concepts we’ve learned and use them across a series of common data analysis applications. We’ll deal with duplicate values, apply special value filters, perform rolling calculations, and more.

To wrap up the course, you’ll work on a project as a Data Analyst Intern for Major League Baseball, and use advanced SQL querying techniques to track how player stats like salary, height, and weight have changed over time and across different teams.

COURSE OUTLINE:

• SQL Basics Review

  • Review the big 6 clauses of a SQL query along with other commonly used keywords like LIMIT, DISTINCT, and more

  
  

• Multi-Table Analysis

  • Review JOIN basics (INNER, LEFT, RIGHT, OUTER) and introduce variations like self joins, CROSS JOINs, and more

  
  

• Subqueries & CTEs

  • Learn how to write subqueries and Common Table Expressions and understand the best situations for using certain techniques

    
    

• Window Functions

  • Introduce window functions to perform calculations across a set of rows and discuss various function options and applications

  
  

• Functions by Data Type

  • Discover the many SQL functions that can be applied to fields of numeric, datetime, string, and NULL data types

  
  

• Data Analysis Applications

  • Apply advanced querying techniques to common data analysis scenarios, including pivoting data, rolling calculations, and more

  
  

• Final Project

  • Leverage everything you've learned to track how Major League Baseball (MLB) player statistics have changed over time and across different teams in the league

__________

Ready to dive in? Join today and get immediate, LIFETIME access to the following:

• 8 hours of high-quality video

• 21 homework assignments

• 6 quizzes

• 4-part final project

• Advanced SQL Querying ebook (150+ pages)

• Downloadable project files & solutions

• Expert support and Q&A forum

• 30-day Udemy satisfaction guarantee

If you’re an analyst, data scientist, or BI professional looking to master advanced querying with SQL, this is the course for you.

Happy learning!

-Alice Zhao (Author, SQL Pocket Guide and Data Science Instructor, Maven Analytics)

__________

Looking for our full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau and Machine Learning courses!

See why our courses are among the TOP-RATED on Udemy:

"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.

"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.

"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.