Audience

IT professionals including database administrators, application developers, independent software vendors, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot 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 enable the student to identify and use stored procedures and triggers

Learning Objectives

Describe the use of triggers and stored procedures in implementing business rules. Choose between stored procedures and triggers. Compile a stored procedure. Define a trigger. Explain the use of cursors.

Topics Covered

Stored procedures - Introducing stored procedures - Creating stored procedures - Executing and modifying - Hands-on: Creating a stored procedure Advanced stored procedures - Input and output parameters - Hands-on: Using parameters - Extended stored procedures - Recompilation and error handling - Hands-on: Error handling Triggers - Overview of triggers - Creating and modifying triggers - How triggers work - Hands-on: Creating and enabling a trigger Cursors - Database cursors - Creating cursors - Hands-on: Using cursors

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