The Magic of SQL

Inner joins - SQL in 60 seconds

Outer joins - SQL in 60 seconds

Outer join filtering - SQL in 60 seconds

Partitioned outer join - SQL in 60 seconds

Cross joins - SQL in 60 seconds

ON vs USING for joins - SQL in 60 seconds

CROSS and OUTER APPLY joins - SQL in 60 seconds

IN & EXISTS Semijoins - SQL in 60 seconds

Inner joins vs IN/EXISTS - SQL in 60 seconds #shorts

NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds

Window functions PARTITION BY - SQL in 60 seconds #shorts

Window functions ORDER BY - SQL in 60 seconds

The Dark Side of Query Optimization

Update and Transactions: Databases for Developers #8

A Story of Index Only Scans: Finding all the Red Sweets Part 3

Why Isnt My Query Using an Index? Databases for Developers: Performance #5

Count Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6

SQL Subqueries: Databases for Developers #11

Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4

Query Tuning 101 How to Run Autotrace in SQL Developer

How to count, sum, and average rows in SQL: Databases for Developers #6

How to write SQL queries: Databases for Developers #4

How do SQL queries return correct results? Databases for Developers #18

Delete and Truncate: Databases for Developers #9

How to Find Slow SQL: Databases for Developers: Performance #9

Union, Minus & Intersect: Databases for Developers #15

What types of database table are there? Databases for Developers #1

How to Read an Execution Plan: Databases for Developers: Performance #1

How to sort rows with SQL: Databases for Developers #12

Hierarchical SQL Queries: Databases for Developers #16

How to pivot rows to columns (and back) in SQL: Databases for Developers #14

How to insert or update rows in one statement: Databases for Developers #17

How do nested loop, hash, and merge joins work? Databases for Developers Performance #7

Why Has an Index Broken My Query?

Query Tuning 101 What to Look for in Autotrace Output

Null: Databases for Developers #10

What to Look for in Execution Plans: Databases for Developers: Performance #3

Insert and Commit: Databases for Developers #7

How to Make Inserts, Updates, and Deletes Faster: Databases for Developers: Performance #8

Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad

What Are Not Null Constraints? A Video Quiz

Learn 130 SQL Statements in 20 Minutes