Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance

Front Cover
John Wiley & Sons, Feb 15, 2011 - Computers - 552 pages
0 Reviews
This book follows the newest iterations of the Microsoft Official Academic Course (MOAC) program for database administration courses using SQL Server 2005 and SQL Server 2008. It provides the information and resources needed to prepare students for the Microsoft Certified Information Technology Professional (MCITP) 70-444 exam for SQL Server 2005, and the 70-432 Microsoft Certified Technology Specialist (MCTS) exam for SQL Server 2008.   Hands On Exercises and Certification Ready features are integrated with the accompanying Lab Manual throughout the chapters that enable them to reinforce what they’ve learned by completing various exercises. Business cases are presented to provide a real world perspective on how the information is used in the field. The book also includes a CD that enables students with exam practice and instant feedback. By following the exercises in this book, students will learn how to install and configure SQL Server, manage databases, implement security, troubleshoot SQL activity, and more.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Brief Contents
1
Contents
2
Case Scenarios
11
Installing Microsoft SQL Server
12
Skill Summary
25
Navigating SQL Server
29
Introducing Books Online
31
Data Types
34
Endpoints
185
Skill Summary
190
Linking Servers
193
Skill Summary
198
Triggers
201
Replication
212
Performing Indexing and FullText Searching
241
Triggers 201 Lesson Skill Matrix 201 Key Terms 201 Using Triggers 202 Creating Indexes
251

Skill Summary
46
Databases
50
Skill Summary
60
Tables
64
Knowledge Assessment
70
Views
73
Knowledge Assessment
78
Constraints
83
Skill Summary
86
Stored Procedures
89
Functions
99
Skill Summary
109
Service Broker
112
Skill Summary
123
Data Integrity
128
Understanding SQL Servers Security
132
Permissions
136
Skill Summary
141
Logins Roles and Credentials
144
Skill Summary
152
Case Scenario
158
Additional Security Tools
159
Skill Summary
166
Backing Up and Restoring Databases
168
Restoring Databases
174
Knowledge Assessment
180
Transactions and Locks
259
Replication 212 Introducing Error Handling
270
Introducing Replication 213 Case Scenario
276
Moving Data
277
Performing Indexing
285
Handling Specialty Data
286
Handling Special Data
287
Skill Summary
305
Case Scenario
313
HighAvailability Methods
314
Understanding Clustering
327
Case Scenario
333
Maintaining and Automating SQL Server
334
Creating Alerts
344
Case Scenario
353
Monitoring and Optimizing SQL Server
354
Skill Summary
360
SQL Server Management Tools
363
Skill Summary
392
Troubleshooting Techniques
394
Using Nongraphical User Interfaces 404 Learning Powershell
404
Case Scenario
411
Appendix A
413
Appendix B
415
Glossary
499
Copyright

Common terms and phrases

Bibliographic information