sitemap
Computer Training
Home
Consulting
Login
Event
Computer Courses Certified Courses Take a test Our Approach Jobs Contact Us
Solutions Seminars Partners About Us Testimonials Downloads
Computer Certified Courses
  Start Here  
   
Microsoft Certified Courses  
 

Microsoft Certified Database Administrator

The Microsoft Certified Database Administrator (MCDBA) is the premier credential to demonstrate that you have the skills necessary to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server databases. MCDBA, on Microsoft SQL Server 2000, candidates need to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of SQL Server databases. The Windows 2000 exams and the Windows XP/Windows Server System exams for the MCDBA on Microsoft SQL Server 2000 certification are expected to remain available concurrently.

Course Objectives

Course Benefits

 

Upon successful completion of the course, students will be able to:

  • Describe SQL Server architecture.

  • Plan for a SQL Server installation, and then install an instance of SQL Server.

  • Manage files and databases, including determining resource requirements.

  • Group and summarize data by using Transact-SQL.

  • Describe how to create programming objects.

  • Query text fields with full-text search..

  • Perform and automate administrative tasks and create custom administrative tools.

  • Back up databases and implement a backup strategy.

  • Restore databases.

  • Monitor and optimize SQL Server performance.

  • Transfer and migrate data into databases.

  • Maintain the high availability of SQL Server.

  • Describe how to replicate data from one SQL Server to another

Microsoft Certified Database Administrators (MCDBA) on Microsoft SQL Server 2000 receive the following benefits:

  • Industry recognition Industry recognition of your knowledge and proficiency with Microsoft products and technologies.

  • 1 year subscription to Microsoft Developer Network (MSDN) library

  • This course is perfect for Database Analysts, Database Administrators and Database developers.
 

Prerequisites

  

Course Duration

 

Before attending this course, students must have:

  • Experience using the Microsoft Windows® 2000 operating system to:

  • Connect clients running Windows 2000 to networks and the Internet.

  • Configure the Windows 2000 environment.

  • Create and manage user accounts.

  • Manage access to resources by using groups.

  • Configure and manage disks and partitions, including disk striping and mirroring.

  • Manage data by using NTFS.

  • Implement Windows 2000 security.

  • Optimize performance in Windows 2000.

 

The MCDBA Certification requires students to successfully complete 3 Core exams and 1 elective exam. Each course will approximately take 40 hours to complete. The total duration to complete the certification will be 160 hours. Students can choose the bootcamp method to complete training in 1 week for each course or choose a more flexible schedule of 8 hours per week and complete the certification in approximately 6 months.


Back to Computer Certification page
 
 
Copyright © 2007 Site Designed By ABCO Technology. All Rights Reserved. Computer Training Courses