Udemy – SQL for Data Analysis: Advanced SQL Querying Techniques
English | Tutorial | Size: 3.55 GB
Learn advanced data analysis with SQL, and master topics like subqueries, CTEs, window functions, and more
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.
RAPIDGATOR:
rapidgator.net/file/5319b3aa8685a2fbb66ab9c00a017e53/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part1.rar.html
rapidgator.net/file/10bd0ef0c0cbba6af86db7dcafcdb494/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part2.rar.html
rapidgator.net/file/fd88d4633d0e24de19b65c418bb57c87/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part3.rar.html
TURBOBIT:
trbt.cc/irn36pcro1rq/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part1.rar.html
trbt.cc/znpib6iztnri/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part2.rar.html
trbt.cc/gz1v5meb7pqp/Udemy_-_SQL_for_Data_Analysis_Advanced_SQL_Querying_Techniques.part3.rar.html