MCTS 70-431 Implementing and Maintaining SQL Server 2005 Study Guide

1-4239-1723-5 © 2007 Publish date: May 30, 2006 892 pages

Buy Now: $59.99 .................

 

Get ready for success with the MCTS 70-431 study guide. This excellent self-directed course will prepare you for the Microsoft 70-431 exam, MCTS: Microsoft SQL Server 2005 - Implementation and Maintenance).

This MCTS 70-431 courseware is appropriate for anyone who is pursuing careers as a Database Administrator, Database Developer, or Business Intelligence Developer or for anyone who needs a technical understanding of SQL Server 2005's features and implementation.

Sixteen expertly written units along with a case study, interactive exercises, and review sections prepare you for passing your exams. This is one of our huge selection of computer training books that is designed with your ultimate success as its goal. You'll learn everything you need to learn as you follow the exam's objectives unit by unit.

The MCTS 70-431 courseware covers everything you'll encounter during the exam including SQL server 2005 installation, management tools, data design, tables, constraints, and indexes, data retrieval, objects, data management, XML support, data transfers, SQL security, management and maintenance, optimization, reliability, applications, troubleshooting, and repair.

This effective courseware is the perfect training tool to supplement your studies. In fact, it is so comprehensive in its coverage of the exam objectives that you can use it as a standalone exam preparation tool. You'll be equipped with the knowledge and know-how you need to implement and maintain SQL Server 2005.

Course Contents

Unit 1 introduces SQL Server 2005 installation

• Features of SQL Server
• Installing SQL Server
• Alternative installations

Unit 2 covers SQL Server management tools

• SQL Server 2005 services
• Management tools
• SQL Server settings
• Database Mail

Unit 3 discusses database management

• Data storage
• Managing databases
• Planning and managing capacity

Unit 4 covers data design

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

Unit 5 discusses tables, constraints, and indexes

• Objects
• Tables
• Constraints
• Indexes

Unit 6 covers data retrieval

• Queries
• Transact-SQL functions
• Data organization
• Multiple table queries
• Modifying data
• The Query Designer

Unit 7 discusses programmable objects

• Fundamentals of programming
• User views
• Stored procedures
• User-defined functions

Unit 8 covers data management

• Multiple language support
• Full text searches
• Partitions
• Error handling
• Transactions and locking
• Triggers

Unit 9 discusses XML support

• Fundamentals of XML
• XML data types
• XML methods and indexes
• XML and relational data integration

Unit 10 covers data transfers

• Bulk transfers
• SQL Server 2005 Integration Services
• XML import and export

Unit 11 goes over SQL Server security

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

Unit 12 covers management and maintenance

• The SQL Server Agent
• Distributed queries
• Replication

Unit 13 goes over SQL Server optimization

• Monitor and optimize
• Database optimization
• Database tune-ups
• Query optimization

Unit 14 covers reliability and availability

• Backing up databases
• Restoring databases
• Log shipping
• Database snapshots
• Mirrored databases

Unit 15 talks about applications

• Service Broker
• HTTP endpoints

Unit 16 covers troubleshooting and repairing

• Blocks and deadlocks
• SQL Server errors
• Recovery

Appendix A contains a case study on Outlander Spices
Appendix B contains the SQL Server command reference
Appendix C contains the MCTS 70-431 exam objectives map