Implementing and Maintaining SQL Server 2005

Course Description

This five-day instructor-led course provides students with product knowledge and skills needed to implement and manage a Microsoft SQL Server 2005 database. It is a focused, accelerated course aimed at participants with experience and skills in SQL 2000 or other database packages.
5 days
Contact us for pricing
Contact us for dates
Contact us for dates


Before attending this course, students must have:

- Basic knowledge of the Microsoft Windows operating system and its core functionality.

- Working knowledge of Transact-SQL.

- Working knowledge of relational databases.

- Some experience with database design.

SQL Server 2005 installation

SQL Server features
SQL Server installation
Alternative installations

SQL Server management tools

SQL Server 2005 services
Management tools
SQL Server settings
Database Mail

Database management

SQL Server data storage
Database management
Capacity planning and management

Data design

The data design process
Table and data design
Data normalization
Data types

Tables, constraints, and indexes

Tables and constraints

Data retrieval

Transact-SQL functions
Data organization
Multiple table queries
Data modification
Query Designer

Programmable objects

Programming fundamentals
User views
Stored procedures
User-defined functions

Data management

Multiple language support
Full-text search
Error handling
Transactions and locking

XML support

XML fundamentals
The XML data type
XML methods and indexes
XML and relational data integration

Data transfers

Bulk transfers
SQL Server 2005 Integration Services
XML import and export

SQL Server security

Server securables
Database and schema securables
SQL auditing
CLR security

Management and maintenance

SQL Server Agent
Distributed queries

SQL Server optimization

Monitoring and optimization
Database optimization
Database tune-ups
Query optimization concepts

Reliability and availability

Database backup
Database restore
Log shipping
Database snapshots
Mirrored databases


Service Broker
HTTP endpoints

Troubleshooting and repair

Blocks and deadlocks
SQL Server errors

Command reference

SQL Server command reference

MCTS 70-431 exam objectives map

Comprehensive exam objectives

SQL ServerSQL Server 2005