West Los Angeles College

MCSE Detailed Course Descriptions

Installing, Configuring, and Administering Microsoft SQL

Course Number: CS988

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft Structured Query Language (SQL) Server. This course is also extremely appropriate for web site developers and database support personnel. This course is one of the required elective courses for the WLAC Microsoft Certified Systems Engineer (MCSE) training program.

After course completion, students will be able to:

• Install and configure SQL Server 2005.
• Manage database files.
• Manage security.
• Perform administrative tasks.
• Back up databases.
• Restore databases.
• Monitor SQL Server.
• Troubleshoot SQL Server.
• Transfer data.
• Maintain high availability.
• Create databases and database files.
• Create data types and tables.
• Use XML-related features.
• Plan, create, and optimize indexes.
• Implement data integrity by using constraints, triggers, and XML schemas.
• Implement views.
• Implement stored procedures and functions.
• Implement managed code in the database.
• Use Service Broker to build a messaging-based solution.

Microsoft Certified Professional Exams

This course helps you prepare for the following Certified Professional exams:
Exam 70-431: Implementing and Maintaining Microsoft SQL Server 2005

Home | Table of Contents | WLAC Primary Web Site