Database by Doug

@UC5A2u2e4Ci8okRLf37TklMw - 8.5K subscribers

Basic, intermediate, and advanced Structured Query Language (SQL) demonstrations using Microsoft's SQL Server. SQL from the very beginning, plus best practices for coding and performance. Demos for beginners, programmers, and "accidental" database administrators.

Home Videos Live Playlists

SQL to find NULL in any column

SQL to find NULL in any column Database by Doug

2.5K views - 1 year ago

Run a SQL Server on your Macbook M1 2024

Run a SQL Server on your Macbook M1 2024 Database by Doug

947 views - 1 year ago

Approach to Complex SQL Queries

Approach to Complex SQL Queries Database by Doug

156.9K views - 5 years ago

Running SQL Server in a Docker Container

Running SQL Server in a Docker Container Database by Doug

2.9K views - 5 years ago

Azure Data Studio Introduction

Azure Data Studio Introduction Database by Doug

37K views - 5 years ago

Using the SwitchOffset function for Time Zones

Using the SwitchOffset function for Time Zones Database by Doug

2.6K views - 7 years ago

Model Building: The Big Picture

Model Building: The Big Picture Database by Doug

398 views - 7 years ago

IN versus EXISTS - are they the same?

IN versus EXISTS - are they the same? Database by Doug

7.3K views - 7 years ago

Understanding Relational Division in SQL

Understanding Relational Division in SQL Database by Doug

14.1K views - 7 years ago

Finding UnMatched Records in SQL

Finding UnMatched Records in SQL Database by Doug

35.4K views - 7 years ago

Time Zones and the DATETIMEOFFSET data type in SQL

Time Zones and the DATETIMEOFFSET data type in SQL Database by Doug

11.8K views - 7 years ago

ANY and ALL in SQL Server

ANY and ALL in SQL Server Database by Doug

7.9K views - 7 years ago

Using the CAST function in SQL

Using the CAST function in SQL Database by Doug

2.8K views - 7 years ago

Using DISTINCT in SQL

Using DISTINCT in SQL Database by Doug

42.2K views - 7 years ago

Foreign Keys in Relational Databases

Foreign Keys in Relational Databases Database by Doug

3.1K views - 7 years ago

Primary Keys in Relational Databases

Primary Keys in Relational Databases Database by Doug

2.3K views - 7 years ago

String Expressions in SQL

String Expressions in SQL Database by Doug

1.7K views - 7 years ago

Numeric Expressions in SQL

Numeric Expressions in SQL Database by Doug

1.5K views - 7 years ago

The SQL FROM Clause

The SQL FROM Clause Database by Doug

2.5K views - 7 years ago

Structuring Data

Structuring Data Database by Doug

1.3K views - 7 years ago

Tables and their parts

Tables and their parts Database by Doug

1.3K views - 7 years ago

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

SQL Ranking Functions: Part 2 Rank, Row_Number, and Dense_Rank Database by Doug

8.9K views - 8 years ago

SQL Ranking Functions: Part 1 The Over Clause

SQL Ranking Functions: Part 1 The Over Clause Database by Doug

34.6K views - 8 years ago

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

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

21.6K views - 8 years ago

Can I use NULL with the IN operator in SQL?

Can I use NULL with the IN operator in SQL? Database by Doug

885 views - 9 years ago

Clustered Indexes and DB Caching

Clustered Indexes and DB Caching Database by Doug

3.1K views - 9 years ago

SQL Server Caching

SQL Server Caching Database by Doug

10.7K views - 9 years ago

Simple Indexing Intro

Simple Indexing Intro Database by Doug

626 views - 9 years ago

The bit data type in SQL Server

The bit data type in SQL Server Database by Doug

14.8K views - 9 years ago

Simple Recursion in SQL

Simple Recursion in SQL Database by Doug

97.2K views - 9 years ago

SQL Server Diagramming Intro

SQL Server Diagramming Intro Database by Doug

3.1K views - 9 years ago

SQL Server Management Studio Intro

SQL Server Management Studio Intro Database by Doug

640.9K views - 9 years ago

Dates and Times in SQL

Dates and Times in SQL Database by Doug

7.4K views - 9 years ago

LIKE, advanced Database by Doug

2.4K views - 9 years ago

The LIKE operator in SQL

The LIKE operator in SQL Database by Doug

11K views - 9 years ago

The DELETE statement in SQL

The DELETE statement in SQL Database by Doug

1.1K views - 9 years ago

The UPDATE statement in SQL

The UPDATE statement in SQL Database by Doug

1.4K views - 9 years ago

The SQL INSERT statement

The SQL INSERT statement Database by Doug

1.6K views - 9 years ago

The HAVING clause in SQL

The HAVING clause in SQL Database by Doug

1.6K views - 10 years ago

Simple Scalar Subquery

Simple Scalar Subquery Database by Doug

7.4K views - 10 years ago

Introduction to Outer Joins

Introduction to Outer Joins Database by Doug

1.6K views - 10 years ago

Group By Part 3: uniquess and multi-column grouping

Group By Part 3: uniquess and multi-column grouping Database by Doug

3.2K views - 10 years ago

Group By Part 2: Null Handling and Count

Group By Part 2: Null Handling and Count Database by Doug

3.5K views - 10 years ago

Group By Part1: Introduction

Group By Part1: Introduction Database by Doug

2.5K views - 10 years ago

Using the IN Operator in SQL

Using the IN Operator in SQL Database by Doug

13.1K views - 10 years ago

The SQL EXISTS clause

The SQL EXISTS clause Database by Doug

68K views - 10 years ago

Tabs and SQL Database by Doug

3.3K views - 10 years ago

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

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

21K views - 10 years ago

Whats slow on my database server?

Whats slow on my database server? Database by Doug

18.2K views - 10 years ago

Introduction to JOINs

Introduction to JOINs Database by Doug

3.1K views - 10 years ago

The SQL ORDER BY clause

The SQL ORDER BY clause Database by Doug

3.3K views - 10 years ago

Simple SQL WHERE clause

Simple SQL WHERE clause Database by Doug

4.8K views - 10 years ago

NoTableSELECT Database by Doug

7.5K views - 10 years ago