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.71 (1425 reviews)
Udemy
platform
English
language
Data & Analytics
category
Maven Analytics
instructor
SQL for Data Analysis: Advanced SQL Querying Techniques
9 998
students
8.5 hours
content
Jan 2025
last update
$89.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

Course Gallery

SQL for Data Analysis: Advanced SQL Querying Techniques – Screenshot 1
Screenshot 1 – SQL for Data Analysis: Advanced SQL Querying Techniques
SQL for Data Analysis: Advanced SQL Querying Techniques – Screenshot 2
Screenshot 2 – SQL for Data Analysis: Advanced SQL Querying Techniques
SQL for Data Analysis: Advanced SQL Querying Techniques – Screenshot 3
Screenshot 3 – SQL for Data Analysis: Advanced SQL Querying Techniques
SQL for Data Analysis: Advanced SQL Querying Techniques – Screenshot 4
Screenshot 4 – SQL for Data Analysis: Advanced SQL Querying Techniques

Loading charts...

6299761
udemy ID
21/11/2024
course created date
25/11/2024
course indexed date
Bot
course submited by