Microsoft Certified Database Administrator MCDBA & Microsoft Certified Technology Specialist MCTS SQL Server 2005

Two of the top Microsoft professional qualifications in database  programming

Course Contents:

Stage 1: Software Programming Fundamentals

Stage 2: Programming Best Practices

Stage 3: Software Development Principles

Stage 4: Systems and Database Design

Stage 5: Managing Information Systems

Stage 6: Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Stage 7: Exam 70-229: Designing and Implementing Databases with MS SQL Server 2000 Enterprise Edition

Stage 8: Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment

Stage 9: Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Stage 10: Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance

Course Code:

MCD-1

Course Duration:

12 months

Typical Study Hours:

220 - 240 hours

Course Fees:

See our Fee Guide

Study Prerequisite:

Computer programming certifications or relevant industry experience.

Additional Information for Stage 1:

• Software Programming Fundamentals:
  • Getting Started
  • Designing Programs

^top

Additional Information for Stage 2:

• Programming Best Practices:
  • Programming Techniques and Strategies
  • General Coding Best Practices
  • Object-oriented Coding Best Practices
  • Maintaining Quality Code

^top

Additional Information for Stage 3:

Software Development Principles:

• Developing a User-Centred Software Design Approach
  • Introducing User-Centered Design
  • Developing an Application Using User-Centered Design
  • The Iterative Process in User-Centered Design
  • Practical Examples of User-Centered Design

^top

Additional Information for Stage 4:

Systems and Database Design:

• Database Design
  • An Overview of Database Design
  • The Database Design Methodology
• Database Fundamentals
• An Introduction to Database Systems
• Relational Databases
• Database Data Management
• Systems Analysis Fundamentals
• Data Flow Diagrams
• Entity Relationship Diagrams
• Data Dictionaries
• Completing the Logical Model
• Relational Principles
• Database Fundamentals
• Fundamentals of Database Design
• Normalisation and Physical Database Design
• Database Management
• Web and Database Integration
• Database Technologies
  • Object-Relational DBMSs
    • Characteristics
    • Mechanisms and Implementation
  • Data Warehousing
    • Fundamentals
    • Building, Using, and Managing
  • SQL Programming
    • Database Queries
    • Data Handling Techniques

^top

Additional Information for Stage 5:

Managing Information Systems:

• The Software Development Process
  • Principles
  • Management Practices
• Open Systems Standards I
• Open Systems Standards II
• Client/Server Fundamentals
• Client/Server Technology
• Client/Server Implementation
• Internet, Intranet, and Extranet Technologies
• Software Engineering
  • Personal Software Process I
  • Personal Software Process II
• Client/Server Technologies
• The Client/Server Model

^top

Additional Information for Stage 6:

• Exam 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition:
  • Administering Microsoft SQL Server 2000
  • Overview of SQL Server 2000
  • Installing, Configuring and Upgrading SQL Server 2000
  • SQL Server 2000 Databases
  • Transferring and Transforming Data Security
  • Managing SQL Server 2000 Databases
  • Backing up Databases
  • Restoring Databases
  • Replication
  • Monitoring SQL Server 2000 Performance
  • SQL Server 2000 High Availability
  • SQL Server 2000, XML and the Web

^top

Additional Information for Stage 7:

• Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition:
  • Designing and Implementing Databases with Microsoft SQL Server 2000
  • Overview of SQL Server 2000
  • SQL Server 2000 Databases
  • Designing and Implementing Security
  • The Logical Data Model
  • Transact-SQL
  • Indexes
  • Programming Business Logic
  • Transactions and Distributed Data
  • Analysing and Optimising Queries
  • Transferring and Transforming Data
  • SQL Server 2000, XML and the Web

^top

Additional Information for Stage 8:

• Exam 70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment:
  • Basic Concepts
  • Managing Users, Groups and Computers
  • Managing Resource Access
  • Managing Hardware, Disks and Logical Devices
  • Managing the Server Environment
  • Managing Disaster Recovery

^top

Additional Information for Stage 9:

• Exam 70-293 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure:
  • Planning the Network Infrastructure
  • Planning for Name Resolution
  • Implementing Routing and Remote Access
  • Planning for Network Availability
  • Planning Server Roles and Server Security
  • Planning a Security Infrastructure

^top

Additional Information for Stage 10:

• Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance
  • Installing SQL Server 2005
  • Configuring SQL Server 2005
  • Creating and Implementing Database Objects in SQL Server 2005
  • Retrieving Data and Running Queries in SQL Server 2005
  • SQL Server 2005 Messaging and Querying Tools
  • Managing and Maintaining SQL Server 2005 Databases
  • SQL Server 2005 Database Performance and Optimisation
  • Monitoring and Diagnosing Database Problems in SQL Server 2005
  • SQL Server 2005 High Availability and Disaster Recovery
  • SQL Server 2005 Backup and Restores

^top

<< back to previous page