June 2006
Beginner
456 pages
10h 3m
English
Now that you’ve learned the basics of the T-SQL language, you’re ready to move on to more advanced techniques. To really take advantage of what T-SQL has to offer, you must know how to return recordsets that contain data based on multiple tables. In this hour you’ll learn:
• What Join Types Are Available and How to Use Them
• How to Output Data Based on Multiple Tables
• How to Group Your Query Output
• About the Aggregate Functions Available to You
• What the Having Clause Is and When to Use It
• How to Union Data from Multiple Tables
• How to Build Subqueries
The examples that follow are based on a database called Northwind which is included on the sample code CD. Instructions ...
Read now
Unlock full access