SQL Server 2000 Programming Business Logic

Overview/Description
To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic

Target Audience
Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one years experience administering SQL Server; at least one years experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
165 Minutes

Objectives:

SQL Server 2000 Programming Business Logic

  • describe what views are and how they are used.
  • create and manage a view.
  • create, alter, and drop a view.
  • modify data using a view.
  • use stored procedures.
  • create and alter a stored procedure.
  • implement parameterized stored procedures.
  • use triggers.
  • handle error messages that may occur when using stored procedures and triggers.
  • provide an overview of user-defined functions.
  • define a user-defined function using Query Analyzer.
  • create, alter, and drop a user-defined function using Query Analyzer.


    • Course Number: 31913_eng