Posts in: Oracle SQL Bootcamp

INNER and OUTER Joins

Learn the differences between INNER JOIN and various types of OUTER JOINs (LEFT, RIGHT, FULL).

Explore self joins to relate rows in the same table, and cross joins to create Cartesian products.

Learn the syntax and best practices for writing join conditions to avoid incorrect results.

Understand what subqueries are and how they allow embedding queries inside other queries to provide powerful, modular logic.

Learn how scalar and row subqueries can return single values or entire rows to be used within SQL queries.