Joins

·       Introduction to SQL Joins

·       Inner Join

·       Syntax of Inner Join

·       Using WHERE vs JOIN clause

·       Outer Join Overview

·       Left Outer Join

·       Right Outer Join

·       Full Outer Join

·       Self Join

·       Cross Join

·       Cartesian Product

·       Natural Join

·       Using Aliases with Joins

·       Join Multiple Tables

·       Join with Subqueries

·       Join and Aggregate Functions

·       Join and GROUP BY

·       Join and HAVING Clause

·       Join and ORDER BY

·       Join and DISTINCT Keyword

·       Joining Views

·       Joining Tables with NULL Values

·       Performance Considerations in Joins

·       Using ANSI Join Syntax

·       Using Oracle Proprietary Join Syntax

·       Outer Join with Conditions

·       Combining Multiple Joins

·       Join with UNION and UNION ALL

·       Using Joins in PL/SQL

·       Best Practices for Joins