MP9003: Network and Database (General) - Joins > SQL for the Windows Environment

This course shows you how to access data stored in multiple relational tables by using joins in your queries. 

Topics:
Understanding joins
Creating a join
Joining multiple tables
Using table aliases
Self joins
Natural joins
Outer joins
Using joins with aggregate functions

Objectives:
Query multiple tables using a join
Use table aliases in your queries
Perform inner, outer, self, and natural joins
Use aggregate functions with joins

Duration:
3 Hours