Microsoft Certified Database Administrator (MCDBA) (460 hours)

Course Overview/Description

The Microsoft Certified Database Administrator (MCDBA) 2003 on Microsoft SQL 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server™ databases. 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. The MCDBA 2003 on SQL 2000 Certification is appropriate for database administrators, database analysts or database developers. 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

Upon successful completion of this course, the student should:

• Demonstrate professional conduct and interpersonal communication skills.
• Install, upgrade, configure, and administer computer networking systems hardware and software.
• Demonstrate an understanding of problem-solving methods essential to troubleshooting a network infrastructure.
• Demonstrate knowledge of the key services used in a typical network environment.
• Demonstrate the basic skills in PC troubleshooting by using software diagnostic tools, test cards, and test equipment.
• Network PCs in both local and remote areas and optimize for performance.
• Demonstrate a functional understanding of operating systems principles and applications.
• 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.
• 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 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.
• Be prepared to take Microsoft exams 70-290 - Maintaining a Microsoft Windows Server 2003 Environment, 70-291 - Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-293 - Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-228 - System Administration for Microsoft SQL Server 2000, and 70-229 - Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Course Outline

• Managing and Maintaining a Microsoft Windows Server 2003 Environment
  1. Introduction to Administering Accounts and Resources
  2. Managing User and Computer Accounts
  3. Managing Groups
  4. Managing Access to Resources
  5. Implementing Printing
  6. Managing Printing
  7. Managing Access to Objects in Organizational Units
  8. Implementing Group Policy
  9. Managing the User Environment by Using Group Policy
  10. Implementing Administrative Templates and Audit Policy
  11. Preparing to Administer a Server
  12. Preparing to Monitor Server Performance
  13. Monitoring Server Performance
  14. Maintaining Device Drivers
  15. Managing Disks
  16. Managing Data Storage
  17. Managing Disaster Recovery
  18. Maintaining Software by Using Software Update Services
  
  
• Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts
  1. Reviewing the Suite of TCP/IP Protocols
  2. Assigning IP Addresses in a Multiple Subnet Network
  3. Configuring a Client IP Address
  4. Configuring a Client for Name Resolution
  5. Isolating Common Connectivity Issues
  
  
• Implementing, Managing and Maintaining a Microsoft Window Server 2003 Network Infrastructure: Network Services
  1. Configuring Routing by Using Routing and Remote Access
  2. Allocating IP Addressing by Using Dynamic Host Configuration Protocol (DHCP)
  3. Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
  4. Resolving Names
  5. Resolving Host Names by Using Domain Name System (DNS)
  6. Managing and Monitoring Domain Name System (DNS)
  7. Resolving NetBIOS Names by Using Windows Internet Name Service (WINS)
  8. Securing Network Traffic by Using IPSec and Certificates
  9. Configuring Network Access
  10. Managing and Monitoring Network Access
  
  
• Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
  1. Introducing Windows Server 2003 Network Infrastructure Planning, Tools, and Documentation
  2. Planning and Optimizing a TCP/IP Physical and Logical Network
  3. Planning and Troubleshooting Routing and Switching
  4. Planning, Optimizing, and Troubleshooting DHCP
  5. Planning a DNS Strategy
  6. Optimizing and Troubleshooting DNS
  7. Planning and Optimizing WINS
  8. Planning and Troubleshooting IPSec
  9. Planning Network Access
  10. Troubleshooting Network Access
  11. Planning a Windows Server 2003 Network Infrastructure
  12. Administering a Microsoft SQL Server 2000 Database
  13. Describe SQL Server Architecture
  14. Plan for an SQL Server Installation
  15. Manage Files and Databases, Including Determining Resource Requirements
  16. Login Security Methods, Configure Login Security
  17. Administrative Tasks
  18. Database Backups
  19. Restore Databases
  20. Monitor and Optimize SQL Server Performance
  21. Transfer and Migrate Data into Databases
  22. Maintain High Availability of SQL Server
  23. Replicate data from One SQL Server to Another
  
  
• Programming a Microsoft SQL Server 2000 Database
  1. Elements of SQL Server 2000
  2. SQL Server Enterprise Application Architecture
  3. Conceptual Basis of Programming in Transact-SQL
  4. Create and Manage Databases
  5. Data Integrity
  6. Use of Indexes
  7. Create Indexes and Data Views
  8. User-Defined Functions
  9. Design, Create, and Use Stored Procedures
  10. Create and Implement Triggers
  11. Program Across Multiple Servers
  12. Optimize Query Performance
  13. Analyze Queries
  14. Manage Transactions and Locks

Prerequisites/Audience

An MCDBA candidate should have six to 12 months of experience working with a desktop operating system, a network operating system, and an existing network infrastructure and should have at least one year of experience working with SQL Server.

PC Requirements/Materials Included

This course is currently not compatible with Windows Vista Operating System.

It is Highly Recommended that students have a high speed internet connection (DSL or Cable) -Programs are only compatible with Microsoft Operating System and Internet Explorer.

Following is the list of software that must be downloaded:

• Adobe Acrobat Reader version 5
• Excel Viewer
• Internet Explorer 6
• WindowsMedia Player 7.1 for WIN 98. WIN 2000 and WIN Me
• RealOne Player
• PowerPoint Viewer
• Word Viewer
• WinZip 8

Hardware requirements:
Minimum Monitor: 15" Super VGA Monitor (minimum) 17" is best

Minimum Processor: Pentium 300 or better

Network Adapter: 10 base T

Minimum RAM: At least 128MB

Minimum Hard Drive: At least 4 GB

Minimum CD Drive: CD-ROM drive (24x or greater)

Minimum Sound Card: 16 Bit

Minimum Video Adaptor: At least 8MB

Sound: Headsets (Microphone optional)

Minimum Screen Resolution: 800 x 600 true color (1024 x 768 is best)

Minimum Operating System: Windows 98 or Windows 2000 Professional

Internet Connection: Cable modem or ADSL


The materials included with this course are:
• Microsoft Official textbooks
• Access to an online IT Library

Instructor Bio

Terry Ladouceur is a veteran of the Online Instructional Team at Academy Online. He is highly qualified to support many of our online courses and included in his list of credentials are Microsoft MCT, MCSE, MCSD, MCDBA, Novell CNA and Comptia + certifications. Terry has a wealth of real life experience that he brings to his students including years supporting Linux products. He honed his programming skills with 15 years as Contract Database Administrator/Programmer for a number of Corporations such as the City of Toronto and University of Ottawa. He has also successfully run his own Website hosting business.

Frequently Asked Questions (FAQs)

1. How do I register?
Click on the register button at the top of the page and follow the directions. It is important that you type all your information in the boxes, then print it out to sign.  Payment and sending instructions are in the bottom right corner of the form.

2. How much do the courses cost?
The fee is in the pink box at the top of the page.

3. Can I register for courses if I live outside the United States?
Yes you can!

4. Do I ever have go to the school I register with?
All of our courses are delivered entirely online, so you never have to go to a class or travel to the school.

5. How long does it take to complete a course?
The original course length is about 1 year. If you need more time, you will receive a 6-month extension at no charge. If you require another extension beyond the free 6-month extension, we will give you a 12- month extension at a charge of $200.00 U.S. (licensing fee) to Gatlin. These extensions will be consecutive (one after the other), so if you step away from the course and come back wanting to resume you may do so after paying a licensing fee. This fee may change from one year to the next. Please do not request an extension until you have almost run out of time (determined by end date). This way you may step away from the course for awhile if needed, and upon returning you may catch up, use the free extension, or pay for an additional license in order to complete the course.

6. Do I have to buy additional materials?
All materials are included. The cost of materials will be covered by your tuition. GES will ship all materials via UPS ground service upon registration.

7. Can I get financial aid?
GES courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses.

• GES provides a loan opportunity for students. Simply go to www.collegeloanapplication.com to apply for an easier qualifying loan at a slightly higher rate. Click here for more information on this loan program.

8. What happens when I complete the course?
Upon successful completion of the course, you will be awarded a certificate of completion from the school you registered with. You must obtain a final passing grade of 70% or greater to be awarded a certificate.

9. Am I guaranteed a job?
GES courses will provide you with the skills you need to obtain an entry-level position in most cases. We do not provide direct job placement services, but our instructors will help you build your resume and are available to give advice on finding your first job. Instructors will also be available to use as a professional reference upon completion of the course. Potential students should always do research on the job market in their area before registering.

10. Who will be my instructor?
Each student is paired up with a facilitator for one-on-one interaction. The facilitator will be available (via email or phone) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

11. What do I have to have in order to take an online course, and what are the system requirements?
In order to take our online courses, you must have access to a computer and the Internet (a normal dial-up connection is fine). You can access the course contents from any web-enabled computer. There are no necessary plug-ins. You do not have to use the same computer to log-in to the course every time. We recommend that you have a word processing program (Microsoft Word is best) and the latest version of Internet Explorer.

12. Can this course be taken on a Mac?
No.

13. How can I get more information on the course?
All of the information we have is available online under our course catalog (www.gatlineducation.com). If you have questions that are not answered online, please feel free to email us at courseinfo@gatlineducation.com or call 817-870-2870. We will answer your questions promptly.

14. When can I start the course?
Our courses are all open enrollment. You can register and start the course as soon as you are ready.

15. Do the Microsoft and CompTIA programs get me prepared for actual certification?
The Gatlin online IT programs provide students the training for the exam. Once you complete your online certification coursework, it's time to take your certification exam. Microsoft, CompTIA, and LPI certification testing is administered by third-party vendors such as Prometric and Virtual University Enterprises (VUE), two leading providers of technology-based testing. Both offer a network of computer-based testing centers with thousands of locations worldwide. Exam costs range from $70 to $125. Once you have selected the exam you plan to take, you can register with Prometric or VUE online or via phone. For more information about Prometric, visit www.2test.com, and for more information about VUE, visit www.vue.com