Structuring Data

SQL to find NULL in any column

Run a SQL Server on your Macbook M1 2024

Approach to Complex SQL Queries

Running SQL Server in a Docker Container

Azure Data Studio Introduction

Using the SwitchOffset function for Time Zones

Model Building: The Big Picture

IN versus EXISTS - are they the same?

Understanding Relational Division in SQL

Finding UnMatched Records in SQL

Time Zones and the DATETIMEOFFSET data type in SQL

ANY and ALL in SQL Server

Using the CAST function in SQL

Using DISTINCT in SQL

Foreign Keys in Relational Databases

Primary Keys in Relational Databases

String Expressions in SQL

Numeric Expressions in SQL

The SQL FROM Clause

Structuring Data

Tables and their parts

SQL Ranking Functions: Part 2 Rank, Row_Number, and Dense_Rank

SQL Ranking Functions: Part 1 The Over Clause

Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER?