SQL Locking and Transactions
This video describes how SQL locking and transactions operate in concept, and in practice (the two are not the same).
SQL
Graphs and Hierarchies in Plain SQL
We have graphs for social networking and other complex structures, and some specialised tools to store and traverse them. But all our other data is in our SQL RDBMS with a convenient familiar API! And we all know that SQL databases are unsuitable for handling these types of structures! Or are they? Well, not quite. …
SQL Indexing in 9 Minutes and a Half
Proper indexing is one of the keys to relational database performance that use the SQL language. However, a disturbingly high number of people have it more or less wrong.
SQL Query Time Saver Tricks
This video shows you how to make writing complicated SQL queries easier with aliasing. This includes the best way to write multiple table queries.
Working with MySQL and SUM
In this screencast, you are going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also …
SQL Outer Joins (Using a Left,Right, and full Join)
In this video, you learn how to find matches and exceptions with outer joins.