Home > Technical General > SQL for the Windows Environment Online Class > SQL for the Windows Environment: Joins Online Class

SQL for the Windows Environment: Joins Online Class

SQL for the Windows Environment Online Class
Order Information
Item # sqlwin
Price$85.00
Series Price$64.99 - You Save 24%
Qty



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



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


Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Total Time: 3.0 hour(s)

Subscription Time (total time to complete): 12 Months

You May Also Like

SQL for the Windows Environment: Joins Online Class