The Magic of SQL

Inner joins - SQL in 60 seconds

Outer joins - SQL in 60 seconds #shorts

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

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

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

Query Tuning 101 What to Look for in Autotrace Output

Solve It with SQL: Removing Points from a Linked List

What Are Not Null Constraints? A Video Quiz

Query Tuning 101 Why Use Autotrace

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

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

Query Tuning 101: Access vs. Filter Predicates In Execution Plans

ORDER BY & NULL

How to create primary keys

Case insensitive search in Oracle

Recover dropped tables with FLASHBACK TABLE

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

Why Has an Index Broken My Query?

The Magic of SQL: Column Update Mystery

Query Tuning 101: How to Compare Execution Plans

A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1

The Magic of SQL: The Cups and Balls Trick

Null: Databases for Developers #10

Columns and Data Types: Databases for Developers #2

Stop missing partition errors on insert

Insert and Commit: Databases for Developers #7

Update and Transactions: Databases for Developers #8

Learn 130 SQL Statements in 20 Minutes

Analytic Functions: Databases for Developers #13