Module 6 – Using JOINS in Queries

Welcome to module 6, JOINS.

In this module, you'll learn how to apply a series of operators to establish table relations.

We'll explore all the types of joins available in T-SQL, including inner joins, outer joins (left, right, and full outer, cross joins, and self-joins. Through comprehensive tutorials and hands-on exercises, you'll master the art of combining data from multiple tables to extract valuable insights.

Whether you are new to TSQL or looking to strengthen - your technical skills, this module will enhance the knowledge you need to write efficient and powerful T-SQL queries.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.