SQL for Data Analysis: Advanced SQL Querying Techniques

Learn advanced data analysis with SQL, and master topics like subqueries, CTEs, window functions, and more
4.69 (766 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
SQL for Data Analysis: Advanced SQL Querying Techniques
6,159
students
8.5 hours
content
Jan 2025
last update
$44.99
regular price

What you will 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

Screenshots

SQL for Data Analysis: Advanced SQL Querying Techniques - Screenshot_01SQL for Data Analysis: Advanced SQL Querying Techniques - Screenshot_02SQL for Data Analysis: Advanced SQL Querying Techniques - Screenshot_03SQL for Data Analysis: Advanced SQL Querying Techniques - Screenshot_04
6299761
udemy ID
11/21/2024
course created date
11/25/2024
course indexed date
Bot
course submited by