Microsoft Certified Database Administrator
Course Descriptions

MCDBA on Microsoft SQL Server 2000 Certification Requirements


CIS 251: Introduction to SQL
This course introduces students to ANSI SQL which is the basis for most other Structured Query Languages. Students will learn to query and update data, create table and views, use indexes, secure data, develop stored procedures and triggers learn object relational concepts and develop applications with embedded SQL and ODBC.

CIS 252: Querying Microsoft SQL Server with Transact-SQl (Exam 70-229)
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL..
MOC* Book Fee:  $50.00


CIS 253: Programming a SQL Server Database (Exam 70-229)
This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000.
MOC* Book Fee:  $125.00

CNG 227:  Administering a Microsoft SQL Server Database (Exam 70-228)
This course is designed to teach students to install, configure, and support Microsoft SQL Server and databases, including managing storage; setting up user accounts; assigning permissions; securing SQL Server; backing up and restoring databases; performing other administrative tasks; transferring data in and out of SQL Server databases; diagnosing system problems, and ensuring high-availability.
MOC* Book Fee:  $125.00

CNG 212:  Managing a MS Windows Server Environment (Exam 70-290)
Provides students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server environment
MOC* Book Fee:  $200.00

CNG 213:  Managing a MS Windows Server Environment (Exam 70-291)
Provides students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server environment.
MOC* Book Fee:  $125.00

CSC 252: MS Visual Basic .NET Application Development (Exam 70-306)
This course is intended to provide Visual Basic programmers with the skills required to create Windows Forms applications by using the .NET Framework. The course will cover the major topics for Windows client application programming on the .NET Framework. These topics include: Windows Forms, GDI+, simple data access, interoperating with unmanaged code, threading and asynchronous programming issues, simple remoting, Web access, XML Web services consumption, debugging, security, and deployment issues for desktop applications.
MOC* Book Fee:  $75.00

CSC 262: MS C# .NET Application Development (Exam 70-316)
This course provides C# programmers with the skills required to create Windows Forms applications by using the .NET Framework. The course will cover the major topics for Windows client application programming on the .NET Framework. These topics include: Windows Forms, GDI+, simple data access, interoperating with unmanaged code, threading and asynchronous programming issues, simple remoting, Web access, Web Services consumption, debugging, security, and deployment issues for desktop applications.

CSC 263: MS ASP .NET XML Web Services (Exam 70-305)
This course provides students with the knowledge and skills that are required to develop XML Web services-based solutions to solve common problems in the distributed application domain. The course focuses on using Microsoft Visual Studio .NET, Microsoft ASP.NET, and Universal Description, Discovery, and Integration (UDDI) to enable students to build, deploy, locate, and consume Extensible Markup Language (XML) Web services.
MOC* Book Fee:  $125.00

CSC 264: Building COM + Applications using Microsoft .NET Enterprise Servers (Exam 70-310 or 70-320)
This course provides students with the knowledge and skills to effectively build scalable, distributed applications that use Microsoft® .NET Enterprise Services and the Microsoft .NET Framework.
MOC* Book Fee:  $125.00

*Microsoft Official Curriculum (MOC) is used to teach the Microsoft IT Courses. 
The first day of class, students will pay for and receive their books.