Microsoft SQL Server 7.0: Stored Procedures and Triggers

Overview/Description
To enable the student to identify and use stored procedures and triggers

Target Audience
IT professionals including database administrators, application developers, independent software vendors, system integrators, and 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Stored Procedures and Triggers

  • To outline the use of stored procedures
  • To describe how to use stored procedures to perform advanced tasks
  • To describe how to use database triggers and to describe how they work
  • To describe when and how to use Transact-SQL cursors


    • Course Number: SQ7045E