Getting Started: SQL Basics
  • Introduction
  • IMPORTANT: PLEASE READ
  • Installing SQL Server 2019 Express
  • Installing SQL Server Management Studio
  • Downloading the AdventureWorks Sample Database
  • Database-ics
  • Saving and Opening Files
  • Introduction to SQL
  • Introduction to SQL - Exercises
  • Aliasing Columns
  • Aliasing Columns - Exercises
  • Selecting Custom Values
  • Selecting Custom Values - Exercises
  • Exporting Data From SSMS
  • SQL Tips and Tricks
  • SQL Tips and Tricks - Exercises
Filtering and Sorting Your Data
  • Applying Criteria With WHERE
  • Applying Criteria With WHERE - Exercises
  • Inequalities and NULLs
  • Inequalities and NULLs - Exercises
  • Multiple Criteria With AND, OR, and IN
  • Multiple Criteria With AND, OR, and IN - Exercises
  • Combining AND and OR
  • Combining AND and OR - Exercises
  • Selecting Numerical Values By Range
  • Selecting Numerical Values By Range - Exercises
  • Matching Text Patterns With Wildcards
  • Matching Text Patterns With Wildcards - Exercises
  • Sorting Data With ORDER BY
  • Sorting Data With ORDER BY - Exercises
  • Selecting Unique Values With SELECT DISTINCT
  • Selecting Unique Values With SELECT DISTINCT - Exercises
Creating and Transforming Data With SQL Functions
  • Creating Basic Derived Columns
  • Creating Basic Derived Columns - Exercises
  • Introducing SQL Functions With Text Functions
  • Introducing SQL Functions With Text Functions - Exercises
  • The CONCAT_WS Function
  • The CONCAT_WS Function - Exercises
  • SSMS Tips and Tricks
  • Advanced Text Manipulation With Nested Functions
  • Advanced Text Manipulation With Nested Functions - Exercises
  • Dates and Datetimes in SQL
  • Dates and Datetimes in SQL - Exercises
  • Date Math in SQL
  • Date Math in SQL - Exercises
  • Data Types and CASTing
  • Data Types and CASTing - Exercises
  • The FORMAT Function
  • The FORMAT Function - Exercises
  • Handling NULL Values With ISNULL
  • Handling NULL Values With ISNULL - Exercises
  • The Mighty CASE Statement
  • The Mighty CASE Statement - Exercises
Putting It All Together - Combining Data From Different Tables
  • Stacking Table Rows With UNION
  • Stacking Table Rows With UNION - Exercises
  • Relationships and Normalization
  • JOINs
  • JOINs - Exercises
  • Going Deeper With JOINs
  • Going Deeper With JOINs - Exercises
  • OUTER JOINs
  • OUTER JOINs - Exercises
  • Going Deeper With OUTER JOINs
  • Going Deeper With OUTER JOINs - Exercises
  • Entity Relationship Diagrams
  • Formatting SQL Code
Coding Challenges and Outro
  • Coding Challenges
  • Outro
BONUS Section - Summarizing Your Data With Aggregate Queries
  • Aggregate Functions
  • Aggregate Functions - Exercises
  • Grouping Aggregate Calculations With GROUP BY
  • Grouping Aggregate Calculations With GROUP BY - Exercises
  • Filtering Aggregate Calculations With HAVING
  • Filtering Aggregate Calculations With HAVING - Exercises
  • The STRING_AGG Function
  • The STRING_AGG Function - Exercises