This book is for students preparing to become certified for the 70-443 and 70-450 Microsoft SQL Server 2005/2008 Database Design and Optimization, Database Administration exam. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional (MCITP) 70-443 and 70-450 certification exam. This text covers installing and configuring the Microsoft SQL Server, managing and maintaining databases or multidimensional databases, user accounts, database availability, recovery, and reporting. This book also guides you through designing and implementation of security and server automation. 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.