SQL Server 2005 Training for Database Administrators

SQL Server 2005 Training for Database Administrators Training Package Includes

• 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
• Printable courseware
• Step-by-step hands-on-labs
• Comprehensive, understandable, and reusable as reference material
• Focused on practical solutions to real-world development problems

Course Introduction

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.

This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
 

Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+) Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.

List of Course Features

SQL Server 2005 Training for Database Administrators Course Contents
 

Module 1 - What's New in SQL Server 2005 for Administrators

SQL Server 2005 Overview
Database Engine Enhancements
Analysis Services Enhancements
Reporting Services Enhancements
Replication Enhancements
Demo - Reporting Services
SQL Server Integration Services
Notification Services
Service Broker
Native HTTP Support
SQL CLR Support
Demo - Creating an HTTP Endpoint
Demo - Common Language Runtime
Lab - Creating An HTTP Endpoint
Module 1 Wrap-up

Module 2 - Installing SQL Server 2005

Editions of SQL Server 2005
Hardware Requirements
Software Requirements
Coexistence with SQL Server 2000
System Consistency Checker
Installing SQL Server 2005
Demo - Installing a 2nd Instance of SQL
Adding or Removing Components
Uninstalling SQL Server 2005
Module 2 Wrap-up

Module 3 - New SQL Server 2005 Admin Tools

SQL Server Management Studio
Demo - Management Studio
SQL Configuration Manager
Demo - Configuration Manager
Surface Area Configuration
Bus Intelligence Development Studio
Demo - Development Environment
The sqlcmd Utility
Demo - Sequel Command
SQL Management Objects
Lab - Creating a Solution
Module 3 Wrap-up

Module 4 - New SQL Server Monitoring Features

SQL Profiler Enhancements
DDL Trigger Overview
Creating DDL Triggers
Using DDL Trigger EventData
Demo - Creating a DDL Trigger
Managing DDL Triggers
Event Notifications
Demo - Creating an Event Notification
Management Views
Two Types of Management Views
Demo - Querying System Metadata
Lab - Querying Metadata
Module 4 Wrap-up

Module 5 - Tuning SQL Server 2005 Databases

New Index Features
Managing Indexes
XML Indexes
Managing Index Fragmentation
Database Engine Tuning Advisor
Using Database Engine Tuning Advisor
Demo - Database Engine Tuning Advisor
Lab - Tuning a Database
Module 5 Wrap-up

Module 6 - Security in SQL Server 2005

SQL 2005 Security Enhancements
SQL 2005 Security Architecture
ANSI Schemas in SQL Server 2005
Demo - Schemas
Managing SQL Server 2005 Logins
Demo - Logins
Managing SQL Server Users and Roles
Managing SQL Server 2005 Permissions
Demo - User ID's in Databases
Managing Execution Context
Demo - Permissions
Demo - Execution Context
Lab - Managing Security
Module 6 Wrap-up

Module 7 - New SQL Server 2005 Disaster Recovery & Availability Features

Disaster Recovery Enhancements
Database Snapshots
Database Snapshots and Recovery
Changes to BACKUP
SQL 2005 Restore Enhancements
Online Restores
Demo - Backup
Recovering the Master Database
SQL 2005 High Availability Options
SQL Server 2005 Database Mirroring
Mirror Server Prerequisites
Partnerships and Witnesses
Lab - Creating a Database Snapshot
Module 7 Wrap-up

Module 8 - New SQL Server 2005 Replication Features

Replication Architectural Enhancements
Performance and Scalability
Replication Tool Enhancements
Heterogeneous Replication
Peer-to-Peer Replication
HTTP Replication
Demo - Creating a Publication
Lab - Creating a Publication
Module 8 Wrap-up
Course Closure