|
This course shows you how to access data stored in multiple relational tables by using joins in your queries.
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
Topics:
- Understanding joins
- Creating a join
- Joining multiple tables
- Using table aliases
- Self joins
- Natural joins
- Outer joins
- Using joins with aggregate functions
|
