In the video I'll describe explain plans also called execution plans and how you can use them to optimize your queries. These are present in most popular DBMS like Oracle PostgreSQL, mySQL, MS SQL and DB2.
Oracle explain plan documentation https://docs.oracle.com/cd/B19306_01/...
SQL script to create HR schema https://github.com/TomekQ13/sqlcours...
Indexes video • Stepbystep guide to database indexe...
Join algorithms video • Database Join Algorithms Explained St...