MS SQL Server 6.5: Advanced Retrieval Structures

Outline

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

Description

In this course, students will learn to implement a database design on Microsoft® SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with ‘MS SQL Server 6.5 DB Design I’, prepares students for the ‘Implementing a Database Design on Microsoft SQL Server 6.5 Certification Exam 70-027.

Audience

This course is designed for database implementors, database administrators, system engineers, developers using Transact-SQL code, Help Desk technicians and Microsoft® Certification Professional candidates.

Prerequisites

The student is expected to have a working knowledge of Relational database theory and database design, SQL Enterprise Manager or isql/w., ANSI-SQL statements, The Microsoft Windows® interface, Microsoft Windows NT® Server network operating system, Microsoft networking fundamentals. The student is expected to have successfully completed the 'MS SQL Server DB Design I Course'.

Objective

Create database objects, such as stored procedures, and triggers Write basic Transact- SQL® statements to summarize and manipulate data

Topics Include

Summarize and Modify Data

• Summarize Data
• Use Aggregate Functions
• Use GROUP BY and HAVING
• Use COMPUTE and COMPUTE BY
• Correlate Data Using Joins
• Implement Joins
• Implement an Inner Join
• Implement a Cross Join
• Implement an Outer Join
• Join With More Than Two Tables
• Use Self Joins
• Use Self Joins
• Use subqueries
• Manipulate Data
• Insert a Row
• Use the DEFAULT Clause
• Insert partial Data
• Use SELECT to Insert Rows
• Use Stored Procedures to Insert Rows
• Update Row Data
• Delete Rows
• Use System Tables
• Import and Export Data

Manage and Use Advanced Retrieval Structures

• Use Control-of-Flow Statements
• Declare and Use Variables
• Use the RETURN Statement
• Use the RAISERROR Statement
• Use the PRINT Statement
• Use the CASE Expression
• Use CASE-Related System Functions
• Use a BEGIN…END Block
• Use an IF…ELSE Block
• Use the WHILE Construct
• Use the EXECUTE Statement
• Implement Cursors
• Declare Cursors
• Use Cursors
• Use Stored Procedure
• Create Stored Procedures
• Use Parameters
• Execute a Stored Procedure
• Use EXECUTE with OUTPUT
• Use Remote Stored Procedures
• Recompile Stored Procedures
• Use System Stored Procedures
• Use Auto Execution Stored Procedures
• Create and Use Triggers
• Create a Trigger
• Use an INSERT Trigger
• Use a DELETE Trigger
• Use an UPDATE Trigger
• Use Nested and Non-nested Triggers
• Enforce Data Integrity
• Enforce Referential Integrity
• Enforce Business Rules

Manage Replication and Application Development

• Apply Replication
• Implement Distributed Data
• Choose a Replication Model
• Assign Server Roles
• Implement Replication
• Identify Client-side and Server-side APIs
• Apply ODBC
• Use DB-Library Functions
• Use SQL Workstation
• Integrate OLE with SQL Server
• Use OLE Automation
• Integrate OLE with SQL Server
• Implement SQL-DMO

Duration

5 hrs

Minimum Requirements

IBM 486 compatible PC, Minimum of 8MB RAM, 35 MB hard disk space, one 3.5 diskette drive, VGA Color Monitor with 256 colors, MS Windows 3.x/Windows 95 or Windows

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002