Introduction to Microsoft SQL Server 2000 Training (5 days)

Introduction to Microsoft SQL Server 2000 Training Overview

This SQL Server training course, which generally targets developers though can be customized for new programmers, teaches students how to effectively design and develop SQL Server databases and to program in Transact-SQL.

Introduction to Microsoft SQL Server 2000 Training Course Goals

• Learn to install Microsoft SQL Server
• Learn to create databases with Microsoft SQL Server
• Learn to use basic SQL to get data out of SQL Server databases
• Learn to use Transact-SQL to get data out of SQL Server databases
• Learn to handle transactions with Microsoft SQL Server
• Learn to create views, stored procedures and user-defined functions with Microsoft SQL Server
• Learn to back up and maintain SQL Server databases
• Learn to make Microsoft SQL Server databases secure
• Learn to Monitor, Tune, and Configure Microsoft SQL Server

Introduction to Microsoft SQL Server 2000 Training Course Prerequisites

Experience in the following areas would be beneficial.

• Programming Experience
• Basic understanding of relational databases

Introduction to Microsoft SQL Server 2000 Training Course Outline

1. Microsoft SQL Server Tour
   1. Microsoft SQL Server Editions
   2. Graphical Tools
   3. Exploring the Enterprise Manager
   4. Working with Microsoft SQL Server Books Online
2. Installing SQL Server
   1. Multiple Instances
   2. Installing an Instance of Microsoft SQL Server
   3. Configuring the Server
3. Designing and Creating a Database with Microsoft SQL Server
   1. Relational Database Design Principles
   2. Implementing the Design
4. Basic Querying in Microsoft SQL Server
   1. Introduction to the Query Analyzer
   2. Retrieving Data
   3. Joining Tables
5. Action Queries in Microsoft SQL Server
   1. Modifying Data
   2. Inserting Data
   3. Updating Data
   4. Deleting Data
6. Using the Microsoft SQL Server Query Analyzer
   1. Query Analyzer Features
   2. The File Menu Items
   3. The Edit Menu
   4. Query Menu Items
   5. Tools Menu Items
   6. Window Menu Items
   7. Help Menu Items
7. Programming With Transact-SQL
   1. Overview of Transact-SQL
   2. Using Built-In Functions
   3. Control of Flow
   4. Error Handling
8. Transaction Processing in Microsoft SQL Server
   1. Transactions
   2. Working with Locks
   3. Monitoring Processes and Locks
   4. Transaction Isolation
   5. Blocking and Deadlocks
9. Creating Views in Microsoft SQL Server
   1. What is a View?
   2. Creating Views
   3. Updating Views
10. Backups and Maintenance in Microsoft SQL Server
    1. Creating a Backup Strategy
    2. Implementing Backups
    3. Restoring from a Backup
    4. The Database Maintenance Plan Wizard
11. Stored Procedures and Triggers in Microsoft SQL Server
    1. Building Stored Procedures
    2. Building Triggers
    3. Using INSTEAD OF Triggers
12. User-Defined Functions in Microsoft SQL Server
    1. User-Defined Functions in SQL Server 2000
    2. Scalar Functions
    3. Inline Table-Valued Functions
    4. Multi-Statement Table-Valued Functions
    5. Functions, Views, and Stored Procedures
13. Advanced Queries and Linked Servers in Microsoft SQL Server
    1. Dynamic SQL
    2. Transact-SQL Cursors
    3. Handling Large Data Sets
    4. Distributed Queries
14. Security in Microsoft SQL Server
    1. Security Overview
    2. Authentication
    3. Understanding Roles
    4. Assigning Permissions
    5. Application Roles
15. Monitoring, Tuning, and Configuration of Microsoft SQL Server
    1. Evaluating Performance
    2. Monitoring with SQL Server Profiler
    3. Tuning Queries
    4. Working with Indexes
    5. Indexed Views
    6. Using the Index Tuning Wizard
    7. Data Caching
    8. The System Monitor

Introduction to Microsoft SQL Server 2000 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Introduction to Microsoft SQL Server 2000 Training Technical Requirements

1. Microsoft SQL Server 2000
2. Query Analyzer

Class Files for Introduction to Microsoft SQL Server 2000 Training

The class files for this course are included on a DVD that is shipped with the manual.