Published on HiTech Institute (http://www.htinstitute.com)

Home > Joining Data from Multiple Tables in Microsoft SQL Server 2008 (E-Learning)

Joining Data from Multiple Tables in Microsoft SQL Server 2008 (E-Learning)

Vendor: 
Microsoft [1]
Subject: 
Database [2]
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 will learn to write joins to query multiple tables, as well as limiting and combining result sets using the UNION, EXCEPT and INTERSECT clause.

Topics covered in the courses within the course Include:
How to query data from multiple tables.
Introduction to joins for typical reporting needs.
Describe how to combine and limit result sets.
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: 

Describe how to query data from multiple tables.
Use joins for typical reporting needs.
Describe how to combine and limit result sets..

Prerequisites: 

None

Business Analysis (BA)

Business Analysis (IIBA) Courses
About IIBA
CBAP Certification
CCBA Certification
Business Analysis Certification Benefits
Business Analysis Training at HiTech Institute

-->

Source URL: http://www.htinstitute.com/courses/joining-data-from-multiple-tables-in-microsoft-sql-server-2008-e-learning

Links:
[1] http://www.htinstitute.com/vendors/microsoft
[2] http://www.htinstitute.com/htnteam/database