DescriptionThis book is for students preparing to become certified for the 70-432 Microsoft SQL Server 2008 Database Administration exam. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 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.
2 Installing Microsoft SQL Server.
3 Navigating SQL Server.
4 Data Types.
9 Stored Procedures.
11 Service Broker.
12 Data Integrity.
14 Logins, Roles, and Credentials.
15 Additional Security Tools.
16 Backing Up and Restoring Databases.
18 Linking Servers.
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.