Wiley
Wiley.com
Print this page Share
Textbook

70-432: Microsoft SQL Server 2008 Implementation and Maintenance

Microsoft Official Academic Course
February 2011, ©2011
70-432: Microsoft SQL Server 2008 Implementation and Maintenance (EHEP001958) cover image

  • Overview
 
This book is for students preparing to become certified for the 70-432 Microsoft SQL Server 2008 Database Administration exam.  The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 70-432 certification exam.  This text covers installing and configuring Microsoft SQL Server and managing and maintaining databases and multidimensional databases, user accounts, database availability, recovery, and reporting. This text guides students through the design and implementation of security or server automation as well as monitoring and troubleshooting SQL Server activity.  The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students. 


MOAC  gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas:  Instructor readiness, student software, student assessment, instruction resources, and learning validation.   With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy. 
Custom Select
Create a customized edition with Wiley Custom Select
Table of Contents
1 Introduction.

2 Installing Microsoft SQL Server.

3 Navigating SQL Server.

4 Data Types.

5 Databases.

6 Tables.

7 Views.

8 Constraints.

9 Stored Procedures.

10 Functions.

11 Service Broker.

12 Data Integrity.

13 Permissions.

14 Logins, Roles, and Credentials.

15 Additional Security Tools.

16 Backing Up and Restoring Databases.

17 Endpoints.

18 Linking Servers.

19 Triggers.

20 Replication.

21 Performing Indexing and Full-Text Searching.

22 Transactions and Locks.

23 Moving Data.

24 Handling Specialty Data.

25 High-Availability Methods.

26 Maintaining and Automating SQL Server.

27 Monitoring and Optimizing SQL Server.

28 SQL Server Management Tools.

29 Troubleshooting Techniques.

Appendix A.

Appendix B.

Appendix C.

Glossary.

Index.

Available Versions

Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance
by Microsoft Official Academic Course
ISBN 978-0-470-18367-0
February 2011, ©2011
Paperback, 552 pages
US $140.95 Add to Cart
Request an Evaluation Copy
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance with MOAC Labs Online Set
by Microsoft Official Academic Course
ISBN 978-1-118-15592-9
February 2012
Paperback
US $196.95 Add to Cart
Request an Evaluation Copy
70-432 MOAC Labs Online OA Reg Code with Wiley eText Digital Set
by Microsoft Official Academic Course
ISBN 978-1-118-75748-2
April 2013
Digital Content (Online or Downloadable)
US $124.50 Add to Cart
Request an Evaluation Copy
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual and MOAC Labs Online Set
by Microsoft Official Academic Course
ISBN 978-1-118-13455-9
September 2011
Paperback
US $213.95 Add to Cart
Request an Evaluation Copy
70-432 MOAC Labs Online Reg Code
by Microsoft Official Academic Course
ISBN 978EOARC00161
December 2012
Digital Content (Online or Downloadable)
US $78.95 Add to Cart
Request an Evaluation Copy
Exam 70-432: MOAC Labs Online
by Microsoft Official Academic Course
ISBN 978-1-118-12996-8
November 2011
Paperback
US $79.95 Add to Cart
Request an Evaluation Copy
E-book
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance
by Microsoft Official Academic Course
ISBN 978-1-118-10239-8
April 2011, ©2011
Wiley E-Text, 552 pages
US $69.50 Purchase This E-book and Learn More
E-book
Exam 70-432 Microsoft SQL Server 2008 Implementation and Maintenance Lab Manual, Lab Manual
by Microsoft Official Academic Course
ISBN 978-1-118-10237-4
May 2011, ©2011
Wiley E-Text, 504 pages
US $29.50 Purchase This E-book and Learn More