Database by Doug

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?

Can I use NULL with the IN operator in SQL?

Clustered Indexes and DB Caching

SQL Server Caching

Simple Indexing Intro

The bit data type in SQL Server

Simple Recursion in SQL

SQL Server Diagramming Intro

SQL Server Management Studio Intro

Dates and Times in SQL

LIKE, advanced

The LIKE operator in SQL

The DELETE statement in SQL

The UPDATE statement in SQL

The SQL INSERT statement

The HAVING clause in SQL

Simple Scalar Subquery

Introduction to Outer Joins

Group By Part 3: uniquess and multi-column grouping

Group By Part 2: Null Handling and Count

Group By Part1: Introduction

Using the IN Operator in SQL

The SQL EXISTS clause

Tabs and SQL

Big Data: How to make your results grid bigger in SQL Mgmt Studio

Whats slow on my database server?

Introduction to JOINs