CE Course Schedule
Course Listings as of November 21, 2009 at 8:30pm
Microsoft SQL Server Certifications
** May Qualify for Financial Aid – Contact 512.223.7872 **
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. Students must be enrolled at least 10 workdays prior to class start to be assured book availability at start of class.
ITMT 1071 Implementing a Microsoft SQL Server 2005 Database
(40.0 hours/$749.00/$75.00 Lab)
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.
x 97514 Sep 12 - Oct 10 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITMT 1072 Maintaining a Microsoft SQL Server 2005 Database
(40.0 hours/$749.00/$75.00 Lab)
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.
x 97515 Oct 17 - Nov 14 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITMT 1073 Designing a Microsoft SQL Server 2005 Infrastructure
(16.0 hours/$294.00/$30.00 Lab)
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: ITMT 1071 Implementing a Microsoft SQL Server 2005 Database & ITMT 1072 Maintaining a Microsoft SQL Server 2005 Database, or equivalent.
x 97517 Dec 5 - Dec 12 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITMT 2071 Implement Analysis Services for Business Intelligence Solutions
(24.0 hours/$449.00/$45.00 Lab)
This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. MOC 2791.
Prerequisites: Experience using a Microsoft Windows Operating System and Microsoft SQL Server 2005.
x 98514 Sep 3 - Sep 18 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITMT 2072 Implement Integration Services for Business Intelligence Series
(24.0 hours/$449.00/$45.00 Lab)
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. MOC 2792. Prerequisites: ITMT 2071 Implement & Maintain Analysis Services for Microsoft SQL Server 2005 Business Intelligence Solutions.
x 98515 Sep 24 - Oct 9 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITMT 2073 Implement Reporting Services for Business Intelligence Solutions
(24.0 hours/$449.00/$45.00 Lab)
This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. MOC 2793.
Prerequisites: ITMT 2072 Implement & Maintain Integration Services for Microsoft SQL Server 2005 Business Intelligence Solutions, or equivalent.
x 98516 Oct 15 - Oct 30 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITMT 2074 Design Business Intelligence Solutions
(16.0 hours/$294.00/$30.00 Lab)
The purpose of course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The course focuses on foundational standards and practices for the enterprise and a project-specific lifecycle for capturing requirements and deriving a solution architecture. MOC 2794.
Prerequisites: ITNX 9024 Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence, or equivalent.
x 98517 Nov 5 - Nov 13 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITMT 2075 Design Business ETL Solutions
(16.0 hours/$294.00/$30.00 Lab)
The purpose of this course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution. MOC 2795.
Prerequisites: ITMT 2074 Design Business Intelligence Solutions for Microsoft SQL Server 2005.
x 98518 Nov 19 - Dec 4 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITMT 2076 Design Analysis Solutions
(24.0 hours/$449.00/$45.00 Lab)
The purpose of this course is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production. Students will also be taught to develop custom functionality and optimize a multidimensional solution. MOC 2796.
Prerequisites: ITMT 2075 Design Business ETL Solutions for Microsoft SQL Server 2005.
x 98519 Dec 10 - Jan 8 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITNX 9020 MCTS/MCITP: SQL Server 2005 Series
(160.0 hours/$2599.00/$300.00 Lab)
The series provides knowledge and skills for professionals who implement and administer Microsoft SQL Server 2005 databases.
Prerequisites: Experience using a Microsoft Windows operating System and an understanding of basic relational database concepts.
x 97512 Sep 12 - Feb 27 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITNX 9021 MCTS: SQL Server 2005 Series
(80.0 hours/$1345.00/$150.00 Lab)
The series provides knowledge and skills for professionals who implement and administer Microsoft SQL Server 2005 databases.
Prerequisites: Experience using a Microsoft Windows operating System. An understanding of basic relational database concepts.
x 97513 Sep 12 - Nov 14 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITNX 9022 MCITP: SQL Server 2005 Database Administrator Series
(80.0 hours/$1345.00/$150.00 Lab)
The series provides knowledge and skills for professionals who implement and administer Microsoft SQL Server T 2005 databases.
Prerequisites: ITNX 9021 Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) or equivalent.
x 97516 Dec 5 - Feb 13 8:00am - 5:00p S HBC 206.0 OH Dominguez, Jose L
ITNX 9023 SQL Server 2005 Business Intelligence Series
(144.0 hours/$2310.00/$270.00 Lab)
The Series provides knowledge and skills for professionals who implement and design Microsoft SQL ServerT 2005 Business Intelligence solutions. Prerequisites: Experience using a Microsoft Windows Operating System and Microsoft SQL Server 2005.
x 98510 Sep 3 - Jan 22 6:00pm -10:00p ThF 209.0 OH Clubb, Kyle
ITNX 9024 MCTS: SQL Server 2005 Business Intelligence Series
(72.0 hours/$1195.00/$135.00 Lab)
The Series provides knowledge and skills for professionals who implement and maintain Microsoft SQL Server 2005 Business Intelligence Solutions.
Prerequisites: Experience using a Microsoft Windows Operating System and Microsoft SQL Server 2005.
x 98511 Sep 3 - Oct 30 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
ITNX 9025 MCITP: SQL Server 2005 Business Intelligence Series
(72.0 hours/$1195.00/$135.00 Lab)
The Series provides knowledge and skills for professionals who design Microsoft SQL Server 2005 Business Intelligence Solutions.
Prerequisites: ITNX 9024 Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence
x 98512 Nov 5 - Jan 22 6:00pm -10:00p ThF HBC 209.0 OH Clubb, Kyle
Last Updated: November 21, 2009 at 8:30pm
Return to Course Index
Prices and Fees listed above are subject to change without notice, please
check with Continuing Education for latest pricing information.
NOTE: The first column indicates the current status of
the course. If the section is open, then the number indicates the
remaining
SEATS AVAILABLE. A small "c" in the
first column indicates a
CLOSED section which is currently
filled and a small "x" indicates a
CANCELLED
class which is no longer offered.
