Home » Microsoft Training Courses » MCITP Database Administrator & 
Developer

Microsoft Certified IT Professional MCITP Database Administrator & Developer

This training course provides three of the top Microsoft professional qualifications in database development

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: Microsoft Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance

Stage 7: Microsoft Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

Stage 8: Microsoft Exam 70-444 PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

Stage 9: Microsoft Exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

Stage 10: Microsoft Exam 70-442 PRO: Designing and Optimising Data Access by Using Microsoft SQL Server 2005

Course Code:

MCT-3

Course Duration:

12 months

Typical Study Hours:

220 - 240 hours

Course Fees:

See our Fee Guide

Course Demo:

Request an online Course Demo

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-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

Additional Information for Stage 7:

• Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
  • Designing a Database Server Infrastructure for SQL Server 2005
  • Designing Security for a Database Server Infrastructure for SQL Server 2005
  • Designing the Physical Database for SQL Server 2005
  • Designing a Database Server High Availability Solution for SQL Server 2005
  • Designing a Database Failover Solution for SQL Server 2005
  • Designing a Database Server Data Recovery Solution for SQL Server 2005

^top

Additional Information for Stage 8:

• Exam 70-444 PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
  • Optimising SQL Server 2005 Performance
  • Optimising a Database Data Recovery Plan for SQL Server 2005
  • Monitoring and Maintaining a Database in SQL Server 2005
  • Managing Database Data in a SQL Server 2005 Environment
  • Managing Data Between Servers and Databases
  • Managing and Maintaining Database Security in SQL Server 2005

^top

Additional Information for Stage 9:

• Exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005
  • Designing an Application Solution for SQL Server 2005
  • Designing Database Objects
  • Programming with SQL Server 2005
  • Using XML
  • CLR Integration
  • Database Testing and Code Management
  • Developing Applications that Use SQL Server Business Intelligence Services
  • Developing Applications that Use SQL Server Support Services
  • Database Deployment and Data Distribution

^top

Additional Information for Stage 10:

• Exam 70-442 PRO: Designing and Optimising Data Access by Using Microsoft SQL Server 2005
  • Designing Access to SQL Server Data
  • Designing Efficient Application Access
  • Designing Queries in SQL 2005
  • Designing a SQL Server 2005 Cursor Strategy
  • Designing a SQL Server 2005 Transaction Strategy
  • SQL Server 2005 Error Handling Techniques
  • Optimising Query Performance and Index Strategies
  • Optimising Storage in SQL Server 2005
  • Scaling Applications and Resolving Performance Issues

^top

<< back to previous page