ABCO Technology,computer training,computer courses,c++ trainig in los angeles,ccna certification course,ccna training in ca
ABCO Technology,computer training,computer courses,CIW certification course,CIW Training Course in los angeles
ABCO Technology,computer certification,computer training,computer courses,computer certification course,computer course
ABCO Technology,computer training,computer courses,computer training courses,computer training school,Excel Training Course los angeles
ABCO Technology,computer training,computer courses,IT Courses,IT training,IT training course
ABCO Technology,computer training,computer courses,java certification course,java certification course in los angeles,Java certification training
ABCO Technology,computer training,computer courses,java training course in los angeles,Java training in los angeles,Linux Certification course ABCO Technology,computer training,computer courses,MCSA Certification training los angeles,mcsa training course in los angeles,mcse training ABCO Technology,computer training,computer courses,Microsoft 2003 Certification Course,Microsoft 2003 Certification Course in los angeles,Microsoft 2003 Training Courses in ca ABCO Technology,computer training,computer courses,Microsoft 2003 Training Courses in los angeles,Microsoft certifiaction course,oracle certification course,Sun Java Certification Training Courses,Sun Java Certification Training Courses los angeles ABCO Technology,computer training,computer courses,consulting services los angeles,IT solution Company,los angeles consulting service ABCO Technology,computer training,computer courses,los angeles it solution Company,los angeles web development consulting services,on site training los angeles,web development consulting services
computer training,computer courses,c++ trainig in los angeles,ccna certification course,ccna training in ca
computer training,computer courses,CIW certification course,CIW Training Course in los angeles,ABCO Technology computer certification,computer training,computer courses,computer certification course,computer course,ABCO Technology computer training,computer courses,computer training courses,computer training school,Excel Training Course los angeles,ABCO Technology computer training,computer courses,IT Courses,IT training,IT training course,ABCO Technology> computer training,computer courses,java certification course,java certification course in los angeles,Java certification training,ABCO Technology computer training,computer courses,java training course in los angeles,Java training in los angeles,Linux Certification course,ABCO Technology
computer training,computer courses,MCSA Certification training los angeles,mcsa training course in los angeles,mcse training,ABCO Technology
  computer training,computer courses,Microsoft 2003 Certification Course,Microsoft 2003 Certification Course in los angeles,Microsoft 2003 Training Courses in ca,ABCO Technology  
computer training,computer courses,Microsoft 2003 Training Courses in los angeles,Microsoft certifiaction course,oracle certification course,Sun Java Certification Training Courses,Sun Java Certification Training Courses los angeles,ABCO Technology
   
ABCO Technology,computer training,computer courses,consulting services los angeles,IT solution Company,los angeles consulting service  
 

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