This recording covers how to understand the difference between INNER JOIN, LEFT JOIN, and UNION, and know how and when to use them. Additionally, you will learn when, where and how to use a subquery and how to reduce query time/calculation resource by query optimization in Structured Query Language (SQL).