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

Prerequisites

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

Objects
Tables and constraints
Indexes

Data retrieval

Queries
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
Partitions
Error handling
Transactions and locking
Triggers

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

Principles
Server securables
Database and schema securables
SQL auditing
Encryption
CLR security

Management and maintenance

SQL Server Agent
Distributed queries
Replication

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

Applications

Service Broker
HTTP endpoints

Troubleshooting and repair

Blocks and deadlocks
SQL Server errors
Recovery

Command reference

SQL Server command reference

MCTS 70-431 exam objectives map

Comprehensive exam objectives

SQL ServerSQL Server 2005