MCTS : Microsoft SQL Server 2005 Implementation and Maintenance Study Guide
Exam 70-431
1st Edition
Published on 14. July 2006
Book
Paperback/Softback
634 pages
978-0-470-02565-9 (ISBN)
Description
With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005
Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam.
Get a great start in your certification process today with this comprehensive guide which includes:
* Hundreds of challenging practice questions plus two bonus exams
* Leading-edge exam preparation software, including a test engine
Authoritative coverage of all key exam objectives, including:
* Installing and Configuring SQL Server 2005
* Implementing High Availability and Disaster Recovery
* Supporting Data Consumers
* Maintaining Databases
* Monitoring and Troubleshooting SQL Server Performance
* Creating and Implementing Database Objects
Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam.
Get a great start in your certification process today with this comprehensive guide which includes:
* Hundreds of challenging practice questions plus two bonus exams
* Leading-edge exam preparation software, including a test engine
Authoritative coverage of all key exam objectives, including:
* Installing and Configuring SQL Server 2005
* Implementing High Availability and Disaster Recovery
* Supporting Data Consumers
* Maintaining Databases
* Monitoring and Troubleshooting SQL Server Performance
* Creating and Implementing Database Objects
More details
Edition
1., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Adult education
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.4 cm
Width: 19 cm
Thickness: 3.5 cm
Weight
1015 gr
ISBN-13
978-0-470-02565-9 (9780470025659)
Schweitzer Classification
Persons
Joseph L. Jorden, MCTS, MCSE, has been administering and developing databases for the last twelve years. Currently he is the Lead Developer for the Jelly Belly Candy Company.
Dandy Weyn, MCTS, MCSE, MCSA, MCDBA, MCDST, MCITP, is an independent SQL Server technologist based in Belgium, who delivers training and consultancy all over the world. He is a frequent speaker at Microsoft seminars and has more than ten years experience with relational databases in enterprise environments.
Dandy Weyn, MCTS, MCSE, MCSA, MCDBA, MCDST, MCITP, is an independent SQL Server technologist based in Belgium, who delivers training and consultancy all over the world. He is a frequent speaker at Microsoft seminars and has more than ten years experience with relational databases in enterprise environments.
Content
Introduction.
Assessment Test.
Chapter 1 Installing Microsoft SQL Server 2005.
Chapter 2 Creating and Configuring Databases.
Chapter 3 Working with Tables and Views.
Chapter 4 Performing Indexing and Full-Text Searching.
Chapter 5 Introducing More Database Objects.
Chapter 6 Implementing Security in SQL Server 2005.
Chapter 7 Working with Relational Data.
Chapter 8 Working with XML Data.
Chapter 9 Working with Service Broker and HTTP.
Chapter 10 Maintaining and Automating SQL Server.
Chapter 11 Performing Backups and Restores.
Chapter 12 Achieving High Availability through Replication.
Chapter 13 Introducing More High-Availability Methods.
Chapter 14 Monitoring and Optimizing SQL Server 2005.
Glossary.
Index.
Assessment Test.
Chapter 1 Installing Microsoft SQL Server 2005.
Chapter 2 Creating and Configuring Databases.
Chapter 3 Working with Tables and Views.
Chapter 4 Performing Indexing and Full-Text Searching.
Chapter 5 Introducing More Database Objects.
Chapter 6 Implementing Security in SQL Server 2005.
Chapter 7 Working with Relational Data.
Chapter 8 Working with XML Data.
Chapter 9 Working with Service Broker and HTTP.
Chapter 10 Maintaining and Automating SQL Server.
Chapter 11 Performing Backups and Restores.
Chapter 12 Achieving High Availability through Replication.
Chapter 13 Introducing More High-Availability Methods.
Chapter 14 Monitoring and Optimizing SQL Server 2005.
Glossary.
Index.