  
                     
|
| |
 |
PROGRAMMING DATABASES WITH MICROSOFT SQL SERVER 2000 - LEVEL 2
| Course Description |
|
This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
|
Introduction to Microsoft SQL Server 2000 - Level 1.
|
• Using the Query Analyzer
Query Analyzer Features
The File Menu Items
The Edit Menu
Query Menu Items
Tools Menu Items
Window Menu Items
Help Menu Items
• Programming with Transact-SQL
Overview of Transact-SQL
Using Built-In Functions
Control of Flow
Error Handling
• Transaction Processing
Transactions
Working with Locks
Monitoring Processes and Locks
Transaction Isolation
Blocking and Deadlocks
• Creating Views
What is a View?
Creating Views
Updating Views
• Backups and Maintenance
Creating a Backup Strategy
Implementing Backups
Restoring from a Backup
The Database Maintenance Plan Wizard
• Stored Procedures and Triggers
Building Stored Procedures
Building Triggers
Using INSTEAD OF Triggers
|
• User-Defined Functions
User-Defined Functions in SQL Server 2000
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Functions, Views, and Stored Procedures
• Advanced Queries and Linked Servers
Dynamic SQL
Transact-SQL Cursors
Handling Large Data Sets
Distributed Queries
• Security
Security Overview
Authentication
Understanding Roles
Assigning Permissions
Application Roles
• Monitoring, Tuning and Configuration
Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Working with Indexes
Indexed Views
Using the Index Tuning Wizard
Data Caching
The System Monitor
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
