Database by Doug
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.
SQL to find NULL in any column
Run a SQL Server on your Macbook M1 2024
Подход к сложным SQL-запросам
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