SQL Server 2000 Programming Business Logic

This course is included in our On-demand training solution.

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?