Microsoft SQL Server 7.0: Implementing a Database- Part 3 CBT Training CD

Rating:
Summary: Microsoft SQL Server 7.0: Implementing a Database- Part 3 CB
Review: Course Overview
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.

Learn To

Query multiple tables using Transact-SQL statements.
Retrieve and modify data using advanced query techniques.

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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Japanese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Querying Multiple Tables 3 - 4 hours

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 3 - 4 hours

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.