SQL to find NULL in any column
Database by Doug
SQL to find NULL in any column
8:29
Run a SQL Server on your Macbook M1 2024
Database by Doug
Run a SQL Server on your Macbook M1 2024
9:12
Approach to Complex SQL Queries
Database by Doug
Approach to Complex SQL Queries
8:33
Running SQL Server in a Docker Container
Database by Doug
Running SQL Server in a Docker Container
5:37
Azure Data Studio Introduction
Database by Doug
Azure Data Studio Introduction
9:25
Using the SwitchOffset function for Time Zones
Database by Doug
Using the SwitchOffset function for Time Zones
9:31
Model Building: The Big Picture
Database by Doug
Model Building: The Big Picture
10:15
IN versus EXISTS - are they the same?
Database by Doug
IN versus EXISTS - are they the same?
8:25
Understanding Relational Division in SQL
Database by Doug
Understanding Relational Division in SQL
14:13
Finding UnMatched Records in SQL
Database by Doug
Finding UnMatched Records in SQL
5:21
Time Zones and the DATETIMEOFFSET data type in SQL
Database by Doug
Time Zones and the DATETIMEOFFSET data type in SQL
9:24
ANY and ALL in SQL Server
Database by Doug
ANY and ALL in SQL Server
9:41
Using the CAST function in SQL
Database by Doug
Using the CAST function in SQL
9:30
Using DISTINCT in SQL
Database by Doug
Using DISTINCT in SQL
8:53
Foreign Keys in Relational Databases
Database by Doug
Foreign Keys in Relational Databases
12:41
Primary Keys in Relational Databases
Database by Doug
Primary Keys in Relational Databases
16:15
String Expressions in SQL
Database by Doug
String Expressions in SQL
9:34
Numeric Expressions in SQL
Database by Doug
Numeric Expressions in SQL
11:15
The SQL FROM Clause
Database by Doug
The SQL FROM Clause
11:06
Structuring Data
Database by Doug
Structuring Data
12:15
Tables and their parts
Database by Doug
Tables and their parts
6:03
SQL Ranking Functions: Part 2 Rank, Row_Number, and Dense_Rank
Database by Doug
SQL Ranking Functions: Part 2 Rank, Row_Number, and Dense_Rank
8:07
SQL Ranking Functions: Part 1 The Over Clause
Database by Doug
SQL Ranking Functions: Part 1 The Over Clause
8:51
Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER?
Database by Doug
Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER?
1:47
Can I use NULL with the IN operator in SQL?
Database by Doug
Can I use NULL with the IN operator in SQL?
4:22
Clustered Indexes and DB Caching
Database by Doug
Clustered Indexes and DB Caching
9:23
SQL Server Caching
Database by Doug
SQL Server Caching
6:21
Simple Indexing Intro
Database by Doug
Simple Indexing Intro
13:24
The bit data type in SQL Server
Database by Doug
The bit data type in SQL Server
7:32
Simple Recursion in SQL
Database by Doug
Simple Recursion in SQL
15:15
SQL Server Diagramming Intro
Database by Doug
SQL Server Diagramming Intro
7:26
SQL Server Management Studio Intro
Database by Doug
SQL Server Management Studio Intro
7:46
Dates and Times in SQL
Database by Doug
Dates and Times in SQL
8:35
LIKE, advanced
Database by Doug
LIKE, advanced
11:00
The LIKE operator in SQL
Database by Doug
The LIKE operator in SQL
9:31
The DELETE statement in SQL
Database by Doug
The DELETE statement in SQL
9:32
The UPDATE statement in SQL
Database by Doug
The UPDATE statement in SQL
10:17
The SQL INSERT statement
Database by Doug
The SQL INSERT statement
11:58
The HAVING clause in SQL
Database by Doug
The HAVING clause in SQL
10:56
Simple Scalar Subquery
Database by Doug
Simple Scalar Subquery
6:50
Introduction to Outer Joins
Database by Doug
Introduction to Outer Joins
10:17
Group By Part 3: uniquess and multi-column grouping
Database by Doug
Group By Part 3: uniquess and multi-column grouping
8:55
Group By Part 2: Null Handling and Count
Database by Doug
Group By Part 2: Null Handling and Count
6:22
Group By Part1: Introduction
Database by Doug
Group By Part1: Introduction
9:57
Using the IN Operator in SQL
Database by Doug
Using the IN Operator in SQL
8:25
The SQL EXISTS clause
Database by Doug
The SQL EXISTS clause
8:52
Tabs and SQL
Database by Doug
Tabs and SQL
4:40
Big Data: How to make your results grid bigger in SQL Mgmt Studio
Database by Doug
Big Data: How to make your results grid bigger in SQL Mgmt Studio
2:02
Whats slow on my database server?
Database by Doug
Whats slow on my database server?
10:07
Introduction to JOINs
Database by Doug
Introduction to JOINs
11:45
The SQL ORDER BY clause
Database by Doug
The SQL ORDER BY clause
9:35
Simple SQL WHERE clause
Database by Doug
Simple SQL WHERE clause
10:44
NoTableSELECT
Database by Doug
NoTableSELECT
8:08