Channel Avatar

The Magic of SQL @UCWeOtlakw8g01MrR8U4yYtg@youtube.com

28K subscribers - no pronouns :c

Hi, I'm Chris Saxon, part of Gerald Venzl's Oracle Developer


11:16
How to Find Slow SQL: Databases for Developers: Performance #9
09:23
How to Make Inserts, Updates, and Deletes Faster: Databases for Developers: Performance #8
15:55
How do nested loop, hash, and merge joins work? Databases for Developers Performance #7
12:09
Count Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6
11:52
Why Isn't My Query Using an Index? Databases for Developers: Performance #5
12:47
How to Create Database Indexes: Databases for Developers: Performance #4
11:35
What to Look for in Execution Plans: Databases for Developers: Performance #3
11:19
What are Optimizer Statistics? Databases for Developers: Performance #2
09:34
How to Read an Execution Plan: Databases for Developers: Performance #1
20:14
Learn 130 SQL Statements in 20 Minutes
00:46
What Are Not Null Constraints? A Video Quiz
00:31
What Are Foriegn Keys? A Video Quiz
00:32
What are Primary Keys - A Video Quiz
04:19
Columns and Data Types: Databases for Developers #2
00:31
What is the Dual Table in Oracle Database? A Video Quiz
09:11
How do SQL queries return correct results? Databases for Developers #18
05:26
How to insert or update rows in one statement: Databases for Developers #17
09:38
Hierarchical SQL Queries: Databases for Developers #16
06:52
Union, Minus & Intersect: Databases for Developers #15
07:24
How to pivot rows to columns (and back) in SQL: Databases for Developers #14
05:42
Analytic Functions: Databases for Developers #13
08:14
How to sort rows with SQL: Databases for Developers #12
07:45
SQL Subqueries: Databases for Developers #11
07:42
Null: Databases for Developers #10
04:40
Delete and Truncate: Databases for Developers #9
07:11
Update and Transactions: Databases for Developers #8
04:51
Insert and Commit: Databases for Developers #7
05:34
How to count, sum, and average rows in SQL: Databases for Developers #6
05:09
How inner, outer, and cross joins work: Databases for Developers #5
05:02
How to write SQL queries: Databases for Developers #4
06:26
Data Modeling: Databases for Developers #3
12:10
Schema Wars Episode 3: The SQL Redemption
09:21
Schema Wars Episode 2: Master DBA Strikes Back
03:19
What types of database table are there? Databases for Developers #1
07:53
Schema Wars Episode 1: The Unstructured Menace
05:25
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
06:02
Why Has an Index Broken My Query?
12:43
Solve It with SQL: Removing Points from a Linked List
00:34
The Dark Side of Query Optimization
10:58
How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5
06:19
Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4
05:25
A Story of Index Only Scans: Finding all the Red Sweets Part 3
09:25
How Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2
08:43
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
04:00
What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0
09:38
The Magic of SQL: The 4 Jacks
08:20
The Magic of SQL: Cups and Balls Behind the Curtain
07:16
The Magic of SQL: The Cups and Balls Trick
07:55
The Magic of SQL: Time Travel
02:08
Query Tuning 101: Access vs. Filter Predicates In Execution Plans
08:55
The Vanishing One Second Waits
04:12
Query Tuning 101: How to Compare Execution Plans
10:24
The Magic of SQL: Magical Changing Row - Behind the Curtain
05:25
The Magic of SQL: The Magical Changing Row
02:58
Query Tuning 101 What to Look for in Autotrace Output
01:38
Query Tuning 101 Why Use Autotrace
02:21
Query Tuning 101 How to Run Autotrace in SQL Developer
07:20
The Magic of SQL: Column Update Mystery