Канал: The Magic of SQL

Unique constraint vs index #SQL #SQLtips

Unique constraint vs index #SQL #SQLtips

Create foreign keys #SQL #SQLtips

Create foreign keys #SQL #SQLtips

Estimate the size of an index before creating it

Estimate the size of an index before creating it

Defining mandatory database columns

Defining mandatory database columns

How to create check constraints

How to create check constraints

How to create primary keys

How to create primary keys

Free guess the SQL statement quizzes

Free guess the SQL statement quizzes

NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds #shorts

NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds #shorts

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

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

IN & EXISTS Semijoins - SQL in 60 seconds #shorts

IN & EXISTS Semijoins - SQL in 60 seconds #shorts

Window functions ORDER BY PRECEDING & FOLLOWING - SQL in 60 seconds #shorts

Window functions ORDER BY PRECEDING & FOLLOWING - SQL in 60 seconds #shorts

Window functions ORDER BY - SQL in 60 seconds #shorts

Window functions ORDER BY - SQL in 60 seconds #shorts

Window functions PARTITION BY - SQL in 60 seconds #shorts

Window functions PARTITION BY - SQL in 60 seconds #shorts

CROSS and OUTER APPLY joins - SQL in 60 seconds #shorts

CROSS and OUTER APPLY joins - SQL in 60 seconds #shorts

ON vs USING for joins - SQL in 60 seconds #shorts

ON vs USING for joins - SQL in 60 seconds #shorts

Cross joins - SQL in 60 seconds #shorts

Cross joins - SQL in 60 seconds #shorts

Partitioned outer join - SQL in 60 seconds #shorts

Partitioned outer join - SQL in 60 seconds #shorts

Outer join filtering - SQL in 60 seconds #shorts

Outer join filtering - SQL in 60 seconds #shorts

Outer joins - SQL in 60 seconds #shorts

Outer joins - SQL in 60 seconds #shorts

Inner joins - SQL in 60 seconds #shorts

Inner joins - SQL in 60 seconds #shorts

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

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

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

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

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

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

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

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

Why Isn't My Query Using an Index? Databases for Developers: Performance #5

Why Isn't My Query Using an Index? Databases for Developers: Performance #5

How to Create Database Indexes: Databases for Developers: Performance #4

How to Create Database Indexes: Databases for Developers: Performance #4

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

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

What are Optimizer Statistics? Databases for Developers: Performance #2

What are Optimizer Statistics? Databases for Developers: Performance #2

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

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

Learn 130 SQL Statements in 20 Minutes

Learn 130 SQL Statements in 20 Minutes

What Are Not Null Constraints? A Video Quiz

What Are Not Null Constraints? A Video Quiz

What Are Foriegn Keys? A Video Quiz

What Are Foriegn Keys? A Video Quiz

What are Primary Keys - A Video Quiz

What are Primary Keys - A Video Quiz

Columns and Data Types: Databases for Developers #2

Columns and Data Types: Databases for Developers #2

What is the Dual Table in Oracle Database? A Video Quiz

What is the Dual Table in Oracle Database? A Video Quiz

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

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

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

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

Hierarchical SQL Queries: Databases for Developers #16

Hierarchical SQL Queries: Databases for Developers #16

Union, Minus & Intersect: Databases for Developers #15

Union, Minus & Intersect: Databases for Developers #15

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

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

Analytic Functions: Databases for Developers #13

Analytic Functions: Databases for Developers #13

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

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

SQL Subqueries: Databases for Developers #11

SQL Subqueries: Databases for Developers #11

Null: Databases for Developers #10

Null: Databases for Developers #10

Delete and Truncate: Databases for Developers #9

Delete and Truncate: Databases for Developers #9

Update and Transactions: Databases for Developers #8

Update and Transactions: Databases for Developers #8

Insert and Commit: Databases for Developers #7

Insert and Commit: Databases for Developers #7

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

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

How inner, outer, and cross joins work: Databases for Developers #5

How inner, outer, and cross joins work: Databases for Developers #5

How to write SQL queries: Databases for Developers #4

How to write SQL queries: Databases for Developers #4

Data Modeling: Databases for Developers #3

Data Modeling: Databases for Developers #3

Schema Wars Episode 3: The SQL Redemption

Schema Wars Episode 3: The SQL Redemption

Schema Wars Episode 2: Master DBA Strikes Back

Schema Wars Episode 2: Master DBA Strikes Back

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

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

Schema Wars Episode 1: The Unstructured Menace

Schema Wars Episode 1: The Unstructured Menace

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

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

Why Has an Index Broken My Query?

Why Has an Index Broken My Query?

Solve It with SQL: Removing Points from a Linked List

Solve It with SQL: Removing Points from a Linked List

The Dark Side of Query Optimization

The Dark Side of Query Optimization

How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5

How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5

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

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

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

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

How Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2

How Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2

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

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

What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0

What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0

The Magic of SQL: The 4 Jacks

The Magic of SQL: The 4 Jacks

The Magic of SQL: Cups and Balls Behind the Curtain

The Magic of SQL: Cups and Balls Behind the Curtain

The Magic of SQL: The Cups and Balls Trick

The Magic of SQL: The Cups and Balls Trick

The Magic of SQL: Time Travel

The Magic of SQL: Time Travel

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

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

The Vanishing One Second Waits

The Vanishing One Second Waits

Query Tuning 101: How to Compare Execution Plans

Query Tuning 101: How to Compare Execution Plans

The Magic of SQL: Magical Changing Row - Behind the Curtain

The Magic of SQL: Magical Changing Row - Behind the Curtain

The Magic of SQL: The Magical Changing Row

The Magic of SQL: The Magical Changing Row

Query Tuning 101 What to Look for in Autotrace Output

Query Tuning 101 What to Look for in Autotrace Output

Query Tuning 101 Why Use Autotrace

Query Tuning 101 Why Use Autotrace

Query Tuning 101 How to Run Autotrace in SQL Developer

Query Tuning 101 How to Run Autotrace in SQL Developer

The Magic of SQL: Column Update Mystery

The Magic of SQL: Column Update Mystery