Exam 70–432 Microsoft SQL Server 2008 Implementation and Maintenance Lab Manual

The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student--technical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.

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.