MySQL Shorts is a playlist on the MySQL YouTube channel dedicated to short form tutorials that focus on a single feature or solution to a problem.
This video series covers a variety of different topics. For this post, we will sumamrize all the ‘Shorts’ that highlight various SQL commands.
Episode 6
Episode 6 shows how to create and drop schemas and tables in MySQL.
Episode 7
For Episode 7, we show how to ceate an index and demonstrate how it can improve query performance.
Episode 10
We demonstrate the differences between UNION, INTERSECT, and EXCEPT in MySQL for Episode 10.
Episode 24
We can create functional indexes that are the result of an expressoin in MySQL. Episode 24 walks you through the steps to accomplish this.
Episode 28
Episode 28 shows how to create common table expressions and discusses examples of when they might be needed.
Episode 29, 30, and 31
We go over Inner, Outer, and Cross joins in Episodes 29, 30, and 31 respectively.
Episode 32
In Episode 32, we talk about using the GROUP BY and HAVING clauses.
Episode 33
We cover the syntax for using table and column aliases in Episode 33.
Episode 38
We show examples of how to paginate data using LIMIT and OFFSET in Episode 38.