Ivy Tech Community College - Central Indiana, Corporate and Continuing Education, in partnership with Gatlin Education Services (GES), offers online open enrollment programs designed to provide the skills necessary to acquire professional level positions for many indemand occupations. The Microsoft Certified Database Administrator (MCDBA) certification is internationally recognized and is the designation awarded to professionals who design, implement, and administer Microsoft SQL Server databases.The MCDBA certification may lead to career opportunities as Database Administrators,Technical Support Specialists, Network Technicians, and Technical Consultants.

BENEFITS TO YOUR ORGANIZATION

• By earning the premier MCDBA 2003 on SQL 2000 credential, individuals are demonstrating that they have the skills necessary to lead organizations in the successful design, implementation, and administration of SQL Server databases

COURSE OBJECTIVES

• Install, upgrade, configure, and administer computer networking systems hardware and software
• Demonstrate an understanding of problem-solving methods essential to troubleshooting a network infrastructure
• Network PCs in both local and remote areas and optimize for performance
• Plan for a SQL Server installation, and then install an instance of SQL Server
• Manage files and databases, including determining resource requirements
• Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network
• Perform/automate administrative tasks and create custom administrative tools
• Back up databases and implement a backup strategy /Restore databases
• Monitor and optimize SQL Server performance / Maintain availability of SQL Server
• Describe how to replicate data from one SQL Server to another
• Be prepared to take Microsoft exams 70-210 - Installing, Configuring, and Administering Microsoft Windows 2000 Professional;

70-215 - Installing, Configuring, and Administering Microsoft Windows 2000 Server; 70-216 -Implementing and Administering a Microsoft Windows 2000 Network Infrastructure; 70-228 - System Administration for Microsoft SQL

TRAINING DESCRIPTION AND MATERIALS

This program will train and prepare students to sit for the official Microsoft MCDBA certification. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server. Programs are only compatible with Microsoft Operating System and Internet Explorer.

HOURS

Your Microsoft Certified Database Administrator training course includes 460 hours of on-line instruction. Pricing includes training administration, instruction, downloadable soft ware, Microsoft textbooks, access to an online IT library, and an activity evaluation at the conclusion of training.

Request more information online or call 888-999-3639.