Implementing and Maintaining MS SQL Server 2005 - MCTS Exam 70-431 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

A three day intensive course equipping participants with a detailed working knowledge of Microsoft SQL Server 2005. This course prepares candidates to pass the MCTS 70-431 exam.

Topics covered include

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 optimisation
Monitoring and optimisation
Database optimisation
Database tune-ups
Query optimisation 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