Audience

IT professionals including database administrators, application developers, independent software vendors, system integrators, Internet consultants who want to plan, deploy, configure, and administer SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To explain how to create queries to retrieve data from multiple tables and to return summary data

Learning Objectives

Explain the different join types. Determine the best method of querying data from multiple tables. Explain how to use subqueries. Create queries to retrieve data from multiple tables. Explain how to summarize data. Create queries that return summary data.

Topics Covered

Table joins - Combining data from multiple tables - Join types - Hands-on: Joining tables Subqueries - Nested subqueries - Correlated subqueries - Modifying data - Hands-on: Creating subqueries Summarizing data - Aggregate functions - The GROUP BY clause - COMPUTE and COMPUTE BY clauses - Hands-on: Querying data

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.