70-432: Microsoft SQL Server 2008 Implementation and Maintenance Lab Manual Set / Edition 1

Paperback (Print)
Buy Used
Buy Used from BN.com
(Save 37%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $2.17
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Paperback)
  • All (15) from $2.17   
  • New (5) from $24.97   
  • Used (10) from $2.17   

More About This Textbook


This book is for students preparing to become certified for the 70-444 and 70-432 Microsoft SQL Server 2005/2008 Database Administration exam.  The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 70-444 and 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. 

Read More Show Less

Product Details

  • ISBN-13: 9780470183687
  • Publisher: Wiley
  • Publication date: 2/15/2011
  • Edition description: Lab Manual
  • Edition number: 1
  • Pages: 504
  • Product dimensions: 8.50 (w) x 10.80 (h) x 1.20 (d)

Table of Contents

Textbook Exercises.

Lesson 2 Textbook Exercises.

Lesson 3 Textbook Exercises.

Lesson 4 Textbook Exercises.

Lesson 5 Textbook Exercises.

Lesson 6 Textbook Exercises.

Lesson 7 Textbook Exercises.

Lesson 8 Textbook Exercises.

Lesson 9 Textbook Exercises.

Lesson 10 Textbook Exercises.

Lesson 11 Textbook Exercises.

Lesson 13 Textbook Exercises.

Lesson 14 Textbook Exercises.

Lesson 15 Textbook Exercises.

Lesson 16 Textbook Exercises.

Lesson 18 Textbook Exercises.

Lesson 19 Textbook Exercises.

Lesson 20 Textbook Exercises.

Lesson 21 Textbook Exercises.

Lesson 22 Textbook Exercises.

Lesson 23 Textbook Exercises.

Lesson 24 Textbook Exercises.

Lesson 25 Textbook Exercises.

Lesson 26 Textbook Exercises.

Lesson 27 Textbook Exercises.

Lesson 28 Textbook Exercises.

Lesson 29 Textbook Exercises.

Hands-On Exercises.

Lab 1: Introducing the Course.

Lab 2: Installing SQL Server 2008.

Lab 3: Navigating SQL Server.

Lab 4: Working with Data Types.

Lab 5: Working with Databases.

Lab 6: Working with Tables.

Lab 7: Working with Views.

Lab 8: Working with Constraints.

Lab 9: Working with Stored Procedures.

Lab 10: Working with Functions.

Lab 11: Working with Service Broker.

Lab 13: Setting Permissions.

Lab 14: Setting Logins and Roles.

Lab 15: Setting Encrypted Connections.

Lab 16: Backing Up and Restoring Data.

Lab 17: Working with Endpoints.

Lab 19: Working with Triggers.

Lab 20: Working with Replication.

Lab 21: Working with Indexes.

Lab 22: Working with Transactions and Locks.

Lab 23: Moving Data.

Lab 24: Working with XML Data.

Lab 25: Working with High-Availability Methods.

Lab 26: Automating Maintenance.

Lab 27: Monitoring and Optimizing.

Lab 28: SQL Server Management Tools.

Lab 29: Troubleshooting.

Appendix A.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)