MCDBA Outline

Microsoft Certified Database Administrator (MCDBA)

  • 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


      15. At the end of the course, the student should 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 FAQs:
      1. How long do I have to complete the course?
      Answer: The course is set to take 460 hours of the student's time to complete. We set the courses up to be completed within 6 months, but we understand if people have special needs, and we will give extensions for students who need extra time to complete a course.

      2. Who issues my certificate of completion?
      When you complete the course with a passing grade, the University of Alabama will issue your certificate.

      3. What are the PC requirements for taking the course?
      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
      Click the back button at the top of this window to register for the course!