The Microsoft MCTS is for IT professionals who want to demonstrate their expertise maintaining databases by using SQL Server 2005. The MCITP builds on an MCTS prerequisite and is designed for IT professionals who want to demonstrate their expertise in using SQL Server 2005 for Database Administration. Our program provides hands-on training using Microsoft Official Curriculum. At Austin Community College, you can take these classes individually, or sign up for the MCTS/MCITP Series. Prerequisite: Experience using Microsoft Windows operating System & understand basic relational database concepts.
Students must be enrolled at least 10 workdays prior to class start to be assured book availability at start of class.
Course Lisiting
ITNX 9020 MCTS/MCITP SQL Server 2005 Series (160 hrs) consists of the MCTS Series and the MCITP Series
ITNX 9021 MCTS: SQL Server 2005 Series (80 hrs) consists of the courses below.
ITMT 1071 Implementing a Microsoft
SQL Server 2005 Database (40 hrs)
This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database. MOC 2779.
Prerequisites: Experience using a Microsoft Windows operating System and an understanding of basic relational database concepts.
ITMT 1072 Maintaining a Microsoft
SQL Server 2005 Database (40 hrs)
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. MOC 2780.
Prerequisites: ITMT 1071 Implementing a Microsoft SQL Server 2005 Database.
ITNX 9022 MCITP: SQL Server 2005 Database Administrator (80 hrs) consists of the courses below.
ITMT 1073 Designing a Microsoft SQL Server 2005 Infrastructure (16 hrs)
This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design. MOC 2786.
Prerequisites: ITNX 9021 MCTS: SQL Server 2005, or equivalent.
ITMT 1074 Designing Security
for Microsoft SQL Server 2005 (16 hrs)
This course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats. MOC 2787.
Prerequisites: ITMT 1073 Designing a Microsoft SQL Server 2005 Infrastructure.
ITMT 1075 Designing High Availability
for Microsoft SQL Server 2005 (24 hrs)
This course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. Students will also learn how to document and test the high availability database solution. MOC 2788.
Prerequisites: ITMT 1074 Designing Security for a Microsoft SQL Server 2005.
ITMT 1076 Administering &
Automating Microsoft SQL Server 2005 Databases (8 hrs)
This course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information. MOC 2789.
Prerequisites: ITMT 1075 Designing High Availability Solutions for a Microsoft SQL Server 2005.
ITMT 1077 Troubleshooting
& Optimizing Microsoft SQL Server 2005 (16 hrs)
This course teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues. MOC 2790.
Prerequisites: ITMT 1076 Administering & Automating Microsoft SQL Server 2005 Databases.
Course Prerequisites
MCTS Prerequisites: Experience using a Microsoft Windows operating System. An understanding of basic relational database concepts.
MCITP Prerequisites: MCTS or equivalent knowledge.