Chapter 1
Roadmap
- Inner Join: Learn how to use the INNER JOIN keyword to combine rows from two or more tables based on a matching condition.
- Outer Join: Learn how to use the OUTER JOIN keyword to return all rows from one table and matching rows from another table.
- Left Join: Learn how to use the LEFT JOIN keyword to return all rows from the left table and matching rows from the right table.
- Right Join: Learn how to use the RIGHT JOIN keyword to return all rows from the right table and matching rows from the left table.
- Cross Join: Learn how to use the CROSS JOIN keyword to return the Cartesian product of two tables.
- Self Join: Learn how to use a self join to join a table to itself.
- Natural Join: Learn how to use the NATURAL JOIN keyword to join two tables based on columns with the same name.
- Join Conditions: Learn how to use join conditions such as equals (=), less than (<), greater than (>), and not equal to (!=) to specify how two tables should be joined.
- Joining Multiple Tables: Learn how to join more than two tables together in a single SQL statement.
- Joins with Aggregate Functions: Learn how to use joins with aggregate functions such as SUM, COUNT, and AVG.
Connect with me on LinkedIn: Himanshu Ramchandani