Exam 70-432
Microsoft SQL Server 2008 Implementation and Maintenance

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.

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.

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.