SQL For Data Analysis: Advanced SQL Querying Techniques

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

What you'll 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

Description
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 ReviewReview the big 6 clauses of a SQL query along with other commonly used keywords like LIMIT, DISTINCT, and moreMulti-Table AnalysisReview JOIN basics (INNER, LEFT, RIGHT, OUTER) and introduce variations like self joins, CROSS JOINs, and moreSubqueries & CTEsLearn how to write subqueries and Common Table Expressions and understand the best situations for using certain techniquesWindow FunctionsIntroduce window functions to perform calculations across a set of rows and discuss various function options and applicationsFunctions by Data TypeDiscover the many SQL functions that can be applied to fields of numeric, datetime, string, and NULL data typesData Analysis ApplicationsApply advanced querying techniques to common data analysis scenarios, including pivoting data, rolling calculations, and moreFinal ProjectLeverage 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 video21 homework assignments6 quizzes4-part final projectAdvanced SQL Querying ebook (150+ pages)Downloadable project files & solutionsExpert support and Q&A forum30-day Udemy satisfaction guaranteeIf 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.