CART
Other versions by this Author
More New and Used
from Private Sellers
Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, Exam 70-444 Lab Manual
by Microsoft Official Academic CourseISBN13:
9780470183687
ISBN10:
0470183683
Format:
Paperback
Pub. Date:
2/15/2011
Publisher(s):
John Wiley & Sons
List Price: $39.80
Rent Textbook
(Recommended)Term
Due
Price
Semester
Jun 3
$23.88
Quarter
May 13
$21.89
Short Term
Apr 13
$19.90
$23.88
Buy New Textbook
Usually Ships in 3-5 Business Days
$38.81
eTextbook
360 day subscription
$22.20
Used Textbook
We're Sorry
Sold Out
Starting at $34.85
Questions About This Book?
Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the edition with a publication date of 2/15/2011.
What is included with this book?
- The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
- The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.
Summary
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.
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.
