MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide

Erscheinungsjahr 2006
ISBN: 978-0-470-02565-9
Verlag: Sybex

Buch, Englisch, 634 Seiten, Format (B × H): 188 mm x 233 mm, Gewicht: 1015 g

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

Autoren/Hrsg.

Jorden, Joseph L.

Weyn, Dandy

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL
• Mathematik | Informatik EDV | Informatik EDV & Informatik Allgemein EDV: Zertifizierung
• Mathematik | Informatik EDV | Informatik Technische Informatik Systemverwaltung & Management

Inhaltsverzeichnis

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.

Über Autor(innen)

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.