The Magic of SQL

Tables: Databases for Developers #1

Tables are the foundation of your database. There are several types of table available in Oracle Database. In this episode, Chris gives an...

Why Has an Index Broken My Query?

Sometimes Oracle can give unexpected exceptions. This often happens when working with dates stored as strings. In this video, Chris investigates...

Query Tuning 101: Comparing Execution Plans

When you're tuning SQL query there's two important questions to keep in mind: * Have my changes made any difference? * If they have, is...

Solve It with SQL: Removing Points from a Linked List

In this guest video, Natalka shows how you can use SQL to traverse a linked list of co-ordinates. She then demonstrates how to remove points that...

The Magic of SQL: The 4 Jacks

In this video Chris performs an updated version of the classic four burglars card trick using real cards and in SQL at the same time! In this...

The Magic of SQL: Column Update Mystery

You use the update statement in SQL to modify existing values in a row. Normally you have to assign values to each column explicitly. In this...

The Magic of SQL: Column Update Mystery

You use the update statement in SQL to modify existing values in a row. Normally you have to assign values to each column explicitly. In this...

The Magic of SQL: The Magical Changing Row

To change the value of a database column normally you need to execute an update statement. In this video Chris uses SQL magic to modify the value...

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

In this episode we take a behind the curtain look at the Magical Changing Row Trick, investigating temporal validity in more detail and explaining...

The Vanishing One Second Waits

In this video Chris uses performance black magic to make a query that should take three seconds execute instantly. Watch the video to find out how...

The Magic of SQL: Time Travel

Ever wish you could travel back in time to undo a mistake? With Oracle you can! With flashback technology you can view and recover data as it...

The Magic of SQL: The Cups and Balls Trick

In this video Chris Saxon performs a SQL take on the classic "cups and balls" magic trick. Watch as he inserts rows into one table which then...