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 AND COST

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.

Suggested Retail Price: $2,895

(Additional participants may be available at an additional cost)

Request more information online or call 866-IVY-4ACT.

Download Product PDF

Computers/IT Products

3D Studio Max
ASP.NET
AutoCAD 3D Drawing
AutoCAD Prof. I
AutoCAD Prof. II
Autodesk Arch.
Autodesk Civil
Autodesk Inventor Adv.
Autodesk Inventor Essen.
Autodesk Land
Autodesk Revit
Autodesk Vault
A+ Cert Prep plus PC
Adobe InDesign CS2
Adobe Photoshop
CIW Foundations
CISCO Prof.
CISCO Assoc.
CompTIA A+
CompTIA Network
CompTIA Security
CompTIA Server
Computer Readiness
CTP
Dreamweaver
Email
Forensic Computer
Help Desk Specialist
IC3
Internet Explorer
Linux
Mail Merge
Microsoft Database Admin
Microsoft Systems Admin
Microsoft Systems Admin+
Microsoft Systems Eng.
Microsoft Project
Microsoft Publisher
Multimedia Design
Microsoft Windows XP
Peachtree
PC Troubleshooting
PC Boot Camp
Typing
Video Game Design
QuickBooks PRO
Solidworks
Templates and Forms
Web Design with Dreamweaver
Webmaster
Windows 2000 Pro
Windows XP Pro