SQL for Data Analysis: Advanced SQL Querying Techniques

Course Name : SQL for Data Analysis: Advanced SQL Querying Techniques
Students : 258
Duration : 8.5 hours
Avg Rating : 4.1
Original Price : $119.99
Discount Price : $14
Instructor / Provider : Maven Analytics, Udemy
Course Type : Self Paced Online Course. Lifetime Access
Coupon : Click on ENROLL NOW to apply discount code

What You’ll Learn

• Master multi-table analysis using JOINs, including advanced variations like self-joins and cross-joins.
• Work with nested queries, writing subqueries and Common Table Expressions (CTEs), while understanding when and how to use each technique.
• Utilize window functions to perform calculations across sets of rows, with hands-on practice in different function options and applications.
• Explore a wide range of SQL functions applicable to numeric, datetime, string, and NULL data types.
• Apply advanced querying techniques to solve real-world data analysis challenges, such as pivoting data, rolling calculations, and more.

Course Outline

SQL Basics Review

• Revisit the six core SQL clauses and other essential keywords like LIMIT, DISTINCT, and more.

Multi-Table Analysis

• Strengthen your understanding of JOIN basics (INNER, LEFT, RIGHT, OUTER) and dive into advanced JOIN variations, including self-joins and cross-joins.

Subqueries & Common Table Expressions (CTEs)

• Learn how to write efficient subqueries and CTEs, and explore their unique use cases in complex SQL scenarios.

Window Functions

• Gain a deep understanding of window functions to calculate aggregates, rankings, and other metrics across partitions of rows.

SQL Functions by Data Type

• Explore SQL functions tailored for different data types, such as numeric, datetime, string manipulation, and handling NULL values.

Data Analysis Applications

• Apply advanced SQL techniques to tackle common data analysis tasks, including data pivoting, rolling calculations, and custom aggregations.

Final Project

• Put your skills to the test by analyzing how Major League Baseball (MLB) player statistics have evolved over time and across different teams.

FAQs on Udemy Coupon