Microsoft SQL Server 7.0: Implementing a Database - Part 3

Course Code NGE72477

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.

Audience

This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first two courses in this series.

Prerequisites

(Currently no course prerequisite information)

Objective

• Query multiple tables using TransactSQL statements.
• Retrieve and modify data using advanced query techniques.

Topics Include

Unit 1: Querying Multiple Tables

• Select the primary properties of a SELECT statement.
• Select the uses for a join.
• Perform the steps to combine tables.
• Perform the steps to combine table data.
• Select the statement that combines table data.
• Perform the steps to combine data from more than two tables.
• Select the statement that joins a table to itself.
• Identify the characteristics of the UNION operator.
• Perform the steps to create a single result set from multiple queries.
• Identify the characteristics of the SELECT INTO statement.
• Perform the steps to create a temporary table.

Unit 2: Advanced Query Techniques

• Select the guidelines for using subqueries.
• Perform the steps to return a single value of data.
• Perform the steps to return a list of values.
• Select the characteristics of a correlated subquery.
• Sequence the steps to process a correlated subquery.
• Sequence the steps to complete a correlated subquery.
• Sequence the steps in which the SQL Server processes EXISTS and NOT EXISTS subqueries.
• Perform the steps to add rows to a table.
• Perform the steps to delete rows from a table.
• Perform the steps to remove rows based on other tables.
• Perform the steps to update rows.
• Select the benefits of cursors.
• Select the methods for requesting a cursor.
• Select the uses of Transact-SQL cursors.
• Sequence the steps of the Transact-SQL cursor procedure.
• Match the types of cursors with their descriptions.
• Match the cursor characteristic with its description.
• Match the cursor syntax with its function.
• Identify the characteristics of a local cursor.
• Match the cursor system stored procedure with its description.
• Select the use of CURSOR_STATUS function.
• Select the most commonly used global variables.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media