Exam 70-431, SQL Server 2005 Implementation and Maintenance. The Microsoft Official Academic Course (MOAC) courses mapping to the Microsoft Certified Technology Specialist (MCTS) 70-431 certification exam. 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. Request your sample materials today.
Lesson 1Lesson 2: Installing Microsoft SQL Server 2005.Lesson 3: Navigating SQL Server 2005.Lesson 4: Datatypes.Lesson 5: Databases.Lesson 6: Tables.Lesson 7: Performing Indexing and Full-Text Searching.Lesson 8: Views.Lesson 9: Constraints.Lesson 10: Stored Procedures.Lesson 11: Triggers.Lesson 12: Functions.Lesson 13: Transactions and Locks.Lesson 14: Moving Data.Lesson 15: XML Data.Lesson 16: Permissions.Lesson 17: Backing Up and Restoring.Lesson 18: Maintaining and Automating SQL Server.Lesson 19: Monitoring and Optimizing SQL Server.Lesson 20: High-Availability Methods.Lesson 21: Service Broker.Lesson 22: Endpoints.Lesson 23: Replication.