Microsoft SQL from A to Z

The Complete Guide to SQL Querying

Created byBrewster Knowlton

Last updated 1/2025

English

German [Auto],English [Auto],

What you'll learn

Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Learn about database design and normalization
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause
Use built-in SQL Server functions
Understand SQL Server Data Types and Type Casting
Work with Table Expressions: Derived Tables and CTEs
Use CASE Statements
Use Subqueries

Course content

12 sections • 81 lectures • 5h 42m total length

START HERE: Introduction Lecture6:49
ALSO START HERE: T-SQL Training Guide0:02
Because you purchased this course, you are provided full access to our "Complete T-SQL Querying Guide". Download it here from this lecture.
Installing SQL Server Written Instructions0:03
How to Install Microsoft SQL Server Express11:26
How to Attach the AdventureWorks Sample Database4:45
Attach the AdventureWorks 2012 database to a SQL Server instance via SQL Server Management Studio, including copying the data file and removing the log file for practice.
Introduction to T-SQL and Database Concepts4:13
Explore how to use Microsoft SQL Server Management Studio to connect to an instance, navigate databases and schemas, and understand tables as data structures, laying groundwork for SQL queries.
Literal SELECT Statements - Part 16:38
Literal SELECT Statements - Part 23:38
Literal SELECT Statement Practice Problems0:03
Basic SELECT Statements - Part 18:42
Basic SELECT Statements - Part 28:10
Expand basic select concepts by using select star to view all columns and top to limit rows, and apply column aliases with spaces using brackets or quotes for readable results.
Basic SELECT Statements - Part 36:29
Basic SELECT Statement Practice Problems0:02

Using the WHERE Clause - Part 15:33
Learn to filter rows with the where clause in SQL. Apply operators such as greater than, less than, equal to, and not equal to on list price.
Using the WHERE Clause - Part 25:10
Using the WHERE Clause - Part 35:34
Using the WHERE Clause - Part 48:16
Using the WHERE Clause - Part 58:03
Using the WHERE Clause - Part 68:29
Using the WHERE Clause - Part 77:26
WHERE Clause Practice Problems0:02

Using the INNER JOIN - Part 18:15
Using the INNER JOIN - Part 28:05
INNER JOIN Practice Problems0:02
Using the LEFT OUTER JOIN - Part 17:52
Master left and right outer joins in SQL, which depend on the order of the tables, returning all records and showing nulls for non-matches, as demonstrated with product and subcategory.
Using the LEFT OUTER JOIN - Part 210:25
Using the LEFT OUTER JOIN - Part 33:33
LEFT/RIGHT OUTER JOIN Practice Problems0:02

Using SQL Server Functions - Part 13:16
Using SQL Server Functions - Part 21:23
Using SQL Server Functions - Part 34:12
Using SQL Server Functions - Part 42:32
Using SQL Server Functions - Part 51:51
Using SQL Server Functions - Part 61:24
Using SQL Server Functions - Part 71:22
Using SQL Server Functions - Part 82:46
Nesting Functions - Part 12:47
Nesting Functions - Part 25:07
SQL String and Nesting Function Practice Problems0:03
Using Date Functions - Part 11:56
Using Date Functions - Part 23:42
Using Date Functions - Part 33:59
Date Function Practice Problems0:02
NULL Handling Functions - Part 12:53
NULL Handling Functions - Part 23:16
Explore the null if function, which returns null when bill to address ID equals ship to address ID, and see how coalesce and case statements handle null values.
NULL Handling Function Practice Problems0:02

Using Derived Tables - Part 13:49
Using Derived Tables - Part 24:11
Using Derived Tables - Part 33:28
Using Derived Tables - Part 44:38
Using Derived Tables - Part 58:50
Derived Table Practice Problems0:02
Working with CTEs - Part 14:23
Working with CTEs - Part 21:59
Learn how to replicate a derived table using a cte by defining hr_emp as a subquery and selecting rows where hired year >= 2004.
Working with CTEs - Part 38:00
Demonstrate how to use common table expressions to simplify year over year sales comparisons by computing current and prior year sales, avoiding repeated derived tables and complex self-joins.
Working with CTEs - Part 44:09
Common Table Expression (CTE) Practice Problems0:02

Requirements

I assume that you have NO SQL or database background before taking this course.
You need to have a Windows computer or the ability to run a Windows Operating System on your computer.

Description

This course is an extension of our previous course, "Microsoft SQL for Beginners". This course, "Microsoft SQL from A to Z" contains all the course material and content from the previous course plus the additional MANY new lectures on more intermediate and advanced-level SQL querying topics. Students who sign up for this course will also have access to our 150+ page "Complete T-SQL Querying Guide" as an added bonus to assist you in the learning process.

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

Who this course is for:

Anyone who works with data, tables, or databases!
Someone who wants to learn the foundational skill of big data and data analytics.
Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
Someone who wants to learn skills that give them the potential to earn near SIX figures!

Microsoft SQL from A to Z

What you'll learn

Explore related topics

Course content

Introduction to SELECT Statements13 lectures • 1hr 1min

Filtering Data with the WHERE Clause8 lectures • 49min

Sorting Data with the ORDER BY Clause3 lectures • 14min

Querying Multiple Tables with Joins7 lectures • 38min

Aggregate Functions3 lectures • 12min

Grouping Data with the GROUP BY Clause3 lectures • 15min

Filtering Groups with the HAVING Clause3 lectures • 14min

Using SQL Server Functions18 lectures • 43min

SQL Server Data Types and Type Casting2 lectures • 6min

Working with Table Expressions11 lectures • 44min

Requirements

Description

Who this course is for: