Working with Subqueries Using Microsoft SQL Server 2008 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Sep 01, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

In this 2 hour course students are introduced to subqueries. Using common table expressions in queries to generate hierarchical result sets is also explored.

Topics covered in the courses within the course Include:
How to write basic sub queries.
How to write correlated sub queries.
Compare subqueries with joins and temporary tables.
Describe common table expressions
This course also helps prepare you for exam: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

This course has the same content as the previous version in an updated viewer with a new look and feel.

Objective: 

Write basic sub queries.
Write correlated sub queries.
Compare sub queries with joins and temporary tables.
Use common table expressions in queries..

Prerequisites: 

None

For more information on Working with Subqueries Using Microsoft SQL Server 2008 (E-Learning) please feel free to contact us online or call us at 416-513-1535.