Database by Doug

Introduction to JOINs

Can I use NULL with the IN operator in SQL?

Using the CAST function in SQL

Azure Data Studio Introduction

The SQL ORDER BY clause

The UPDATE statement in SQL

The SQL FROM Clause

SQL Server Management Studio Intro

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

Using the IN Operator in SQL

SQL Ranking Functions: Part 1 The Over Clause

Running SQL Server in a Docker Container

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

Using DISTINCT in SQL

Group By Part 2: Null Handling and Count

The SQL EXISTS clause

Simple Indexing Intro

Time Zones and the DATETIMEOFFSET data type in SQL

Tables and their parts

SQL Server Caching

Model Building: The Big Picture

The HAVING clause in SQL

Using the SwitchOffset function for Time Zones

Structuring Data

Finding UnMatched Records in SQL

Foreign Keys in Relational Databases

IN versus EXISTS - are they the same?

Numeric Expressions in SQL

Run a SQL Server on your Macbook M1 2024

ANY and ALL in SQL Server

Approach to Complex SQL Queries

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

SQL Server Diagramming Intro

Primary Keys in Relational Databases

Simple Scalar Subquery

SQL to find NULL in any column

Dates and Times in SQL

String Expressions in SQL

Clustered Indexes and DB Caching

The DELETE statement in SQL

Simple SQL WHERE clause

Simple Recursion in SQL

Tabs and SQL

Introduction to JOINs

Group By Part 3: uniquess and multi-column grouping

Understanding Relational Division in SQL

The LIKE operator in SQL

The bit data type in SQL Server