Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

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 year?s experience administering SQL Server; at least one year?s 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

Course Aim

This learning path describes in detail the new features, tools, and best practices for designing and implementing databases using Microsoft SQL Server 2000.

Learning Objectives

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

Topics Covered

Implementing SQL Server 2000 views Introducing SQL Server 2000 views Creating and managing SQL Server 2000 views Creating and altering a SQL Server 2000 view Modifying data using SQL Server 2000 views SQL Server 2000 stored procedures and triggers The fundamentals of SQL Server 2000 stored procedures Creating a SQL Server 2000 stored procedure SQL Server 2000 parameterized stored procedures Introducing and defining SQL Server 2000 triggers Handling errors in SQL Server 2000 stored procedures Implementing SQL Server 2000 user-defined functions The basics of SQL Server 2000 user-defined functions Defining a SQL Server 2000 user-defined function Creating a SQL Server 2000 user-defined function

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.