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.