SQL For Data Analysis: Advanced SQL Querying Techniques

SQL For Data Analysis: Advanced SQL Querying Techniques
Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

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

What you’ll learn
Learn to work with nested queries by writing subqueries and common table expressions (CTEs), and understand the best use cases for each
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