SQL for Data Analysis - with SQL Server

Name: SQL for Data Analysis - with SQL Server
Rating: 4.6 (3559 reviews)

The most direct path to mastering the SQL skills you'll actually use on the job

Created byTravis Cuzick

Last updated 6/2026

English

What you'll learn

Use SQL to apply complex criteria and transformations to database data
Master SQL functions for sophisticated data manipulation
Leverage an understanding of relational database design to link together data stored across multiple tables
Use aggregate queries to produce summarized views and analysis
Be comfortable putting SQL and SQL Server on your resume
Gain experience with the kind of SQL coding problems you are likely to encounter in an interview
Prompt engineering strategies for generating high-quality SQL code with AI tools

Course content

7 sections • 83 lectures • 7h 20m total length

Introduction3:13
IMPORTANT: PLEASE READ0:28
A Note to Windows 11 Users...4:30
Installing SQL Server 2019 Express7:17
Installing SQL Server Management Studio5:16
Downloading the AdventureWorks Sample Database7:30
Download and restore the Adventure Works 2019 sample database in SQL Server Express, creating a realistic data environment for practicing data analysis with SQL Server Management Studio.
Database-ics10:01
Explore the basics of databases, the difference between a database server and databases, and how SQL Server Management Studio helps navigate tables and schemas in Adventure Works.
Saving and Opening Files3:35
Learn to save and reopen your SQL queries in SQL Server Management Studio by using Save As, selecting the SQL file extension, and opening saved files, with Ctrl+S for quick saves.
Introduction to SQL7:03
Introduction to SQL - Exercises0:17
Aliasing Columns8:23
Aliasing Columns - Exercises0:22
Selecting Custom Values6:04
Selecting Custom Values - Exercises0:17
Exporting Data From SSMS3:11
Export data from SQL Server Management Studio to Excel or text files for business users. Copy with headers to Excel or save results as csv or tab-delimited text.
SQL Tips and Tricks7:55
learn handy sql tips for testing and prototyping, such as using select star to view all columns, limiting columns for production, and running multiple queries in sql server management studio.
SQL Tips and Tricks - Exercises0:16

Applying Criteria With WHERE7:32
Applying Criteria With WHERE - Exercises0:24
Inequalities and NULLs5:55
Inequalities and NULLs - Exercises0:25
Multiple Criteria With AND, OR, and IN7:04
Learn to filter data using multiple criteria with and, or, and in SQL Server. Build concise queries using where clauses to combine conditions and efficiently handle large data sets.
Multiple Criteria With AND, OR, and IN - Exercises0:18
Combining AND and OR7:18
Combining AND and OR - Exercises0:38
Selecting Numerical Values By Range8:58
Explore range-based where clauses to filter numerical values using greater than, less than, and between, including inclusive endpoints; apply to sales quota and total due examples, including open-ended ranges.
Selecting Numerical Values By Range - Exercises0:28
Matching Text Patterns With Wildcards12:13
Learn to query text with patterns using wildcards in SQL Server, including the percent sign and bracket ranges, to flexibly match names and other fields with like and not like.
Matching Text Patterns With Wildcards - Exercises0:29
Sorting Data With ORDER BY9:29
Sort query results with the order by clause to bring the largest totals to the top in descending order. Reference columns by alias or position and sort by multiple columns.
Sorting Data With ORDER BY - Exercises0:26
Selecting Unique Values With SELECT DISTINCT6:48
Selecting Unique Values With SELECT DISTINCT - Exercises0:16

Creating Basic Derived Columns14:02
Creating Basic Derived Columns - Exercises0:51
Introducing SQL Functions With Text Functions12:42
Introducing SQL Functions With Text Functions - Exercises0:31
The CONCAT_WS Function8:12
Learn how to safely concatenate first, middle, and last names using the concat with separator function in SQL Server, which gracefully handles null values and scales to many fields.
The CONCAT_WS Function - Exercises1:00
SSMS Tips and Tricks4:36
Advanced Text Manipulation With Nested Functions12:39
Advanced Text Manipulation With Nested Functions - Exercises0:47
Dates and Datetimes in SQL13:38
Dates and Datetimes in SQL - Exercises0:23
Date Math in SQL10:45
Date Math in SQL - Exercises0:33
Data Types and CASTing11:35
Data Types and CASTing - Exercises0:33
The FORMAT Function13:29
Learn to format data in SQL Server with the format function to render numbers as percentages, currency, and dates, using format codes and culture arguments; note it returns a string.
The FORMAT Function - Exercises0:46
Handling NULL Values With ISNULL5:17
Use the isnull function to replace nulls with friendly fallbacks, such as 'no title' or zero in sales quotas, and prepare for advanced output with the case statement.
Handling NULL Values With ISNULL - Exercises0:16
The Mighty CASE Statement16:48
The Mighty CASE Statement - Exercises0:47

Stacking Table Rows With UNION13:47
Explore stacking rows with union to combine orders from customer and vendor tables into a single dataset, and contrast with joining columns from different tables for integrated analysis.
Stacking Table Rows With UNION - Exercises0:34
Relationships and Normalization10:15
JOINs6:38
Discover how to join related tables in SQL Server by aliasing tables and using on to link business entity ids between sales and person tables.
JOINs - Exercises0:18
Going Deeper With JOINs10:39
Going Deeper With JOINs - Exercises0:52
OUTER JOINs6:58
OUTER JOINs - Exercises0:34
Going Deeper With OUTER JOINs8:43
Going Deeper With OUTER JOINs - Exercises0:52
Entity Relationship Diagrams6:13
Formatting SQL Code7:19

Aggregate Functions9:58
Aggregate Functions - Exercises0:17
Grouping Aggregate Calculations With GROUP BY9:37
Group by produces one row per unique value combination, enabling aggregate calculations like count and sum on fields such as job title and gender.
Grouping Aggregate Calculations With GROUP BY - Exercises0:33
Filtering Aggregate Calculations With HAVING9:45
Filtering Aggregate Calculations With HAVING - Exercises0:39
The STRING_AGG Function9:27
The STRING_AGG Function - Exercises0:58

Prompting 1019:16
Master precise prompt design to guide ai tools like ChatGPT and Claude in sql. Craft clear prompts that specify data, column names, constraints, and output structure for accurate results.
Few-Shot Prompting9:38
Apply few-shot prompting to teach with example input-output pairs and create a reusable task template. See how unpivoting in SQL Server transforms wide amount columns into rows for analysis.
Don't Be Shy with AI4:54
Structuring Prompts with XML13:49
Don't Overdo It4:14
Balance concise prompts with room for AI insight, starting with broad questions to analyze monthly sales data in sql server without overfitting your requests.
Role Reversal Prompting8:22

Requirements

Access to a Windows 10 or Windows 11 operating system (SQL Server only runs on Windows)

Description

If you spend a lot of time extracting, transforming, or analyzing data from databases, - or you're aiming for one of the many highly paid career paths that rely heavily on this skill - then this course is for you.

Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst, but also provides a strong foundation for even more exotic roles like that of a Data Scientist. Experienced Data Scientists will tell you that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well.

In this course, I have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming. Instead, I carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional.

This enabled me to condense a complete course on SQL into just 36 instructional videos, averaging less than 10 minutes in length. So if you can commit to a video a day, in just over one month you’ll have added an extremely valuable and lucrative skill to your arsenal (and just as importantly, your resume!).

And to make sure all that knowledge sticks, I’ve included exercises...LOTS of exercises. Unlike most courses, which only feature sporadic opportunities to practice what you’ve learned, this course has practice problems after almost every video - so you can reinforce concepts right away.

Take it from someone who has built their career almost entirely on self-taught technical skills: it’s worth the effort. Several recent surveys have shown that SQL is actually the MOST in-demand tech skill sought after by recruiters!

In short, learning SQL can change your life, if you put in the work Let me be your guide to this next step in your career - I think you’ll find the journey a lot less daunting, and maybe even a little more fun, than you would have ever expected.

Who this course is for:

Aspiring Data Analysts or Business Intelligence Analysts looking to break into these fields by learning SQL
Data Scientists trying to improve their data cleaning and transformation skills by learning SQL
Non-technical business professionals such as business analysts and project managers trying to gain a better understanding of the technical domains they interact with

SQL for Data Analysis - with SQL Server

What you'll learn

Explore related topics

Course content

Getting Started: SQL Basics17 lectures • 1hr 16min

Filtering and Sorting Your Data16 lectures • 1hr 9min

Creating and Transforming Data With SQL Functions21 lectures • 2hr 10min

Putting It All Together - Combining Data From Different Tables13 lectures • 1hr 14min

Coding Challenges and Outro2 lectures • 1min

Summarizing Your Data With Aggregate Queries8 lectures • 41min

Writing SQL with AI: Effective Prompting Strategies6 lectures • 50min

Requirements

Description

Who this course is for: