| |
|
| |
SQL Server 2000 Programming Business Logic Training Class |
|
| |
|
|
| |
|
|
| |
SQL Server 2000 Programming Business Logic Training Seminar
To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
Introducing SQL Server 2000 views
- describe what views are and how they are used.
Creating and managing SQL Server 2000 views
- create and manage a view.
Creating and altering a SQL Server 2000 view
- create, alter, and drop a view.
Modifying data using SQL Server 2000 views
- modify data using a view.
The fundamentals of SQL Server 2000 stored procedures
- use stored procedures.
Creating a SQL Server 2000 stored procedure
- create and alter a stored procedure.
SQL Server 2000 parameterized stored procedures
- implement parameterized stored procedures.
Introducing and defining SQL Server 2000 triggers
- use triggers.
Handling errors in SQL Server 2000 stored procedures
- handle error messages that may occur when using stored procedures and triggers.
The basics of SQL Server 2000 user-defined functions
- provide an overview of user-defined functions.
Defining a user-defined function in SQL Server 2000
- define a user-defined function using Query Analyzer.
Creating a SQL Server 2000 user-defined function
- create, alter, and drop a user-defined function using Query Analyzer.
|
|
|
|
| |
|
|
| |
Audience |
|
| |
Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
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
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|