Microsoft Database and Programming Developer .NET

From beginner to high level Microsoft Certifications covering a range of cross-training programming and database skills.

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-305 Developing and Implementing Web Applications with MS VB.NET and MS Studio .NET

Stage 7: Exam 70-306 Developing and Implementing Windows-based Apps with MSVB .NET and MS Studio .NET

Stage 8: Exam 70-310 Developing XML Web Services and Server Components with MS VB .NET and the MS .NET Framework

Stage 9: Exam 70-300 Analysing Requirements and Defining MS .NET Solution Architectures

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

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

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

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

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

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

Course Code:

DPD-4

Course Duration:

12 months

Typical Study Hours:

500 - 520 hours

Course Fees:

See our Fee Guide

In addition to the stages specified, we also include:

• CareerWise Interactive Job Skills Training
• VB Compiler
• Selectware

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-305 Developing and Implementing Web Applications with MS VB.NET and MS Studio .NET:
  • Introducing Microsoft .NET
  • Visual Basic NET for the VB6 Developer
  • Foundations of ASP.NET with VB.NET
  • ADO.NET with VB.NET
  • Configuration and Security with VB.NET
  • Testing, Debugging, and Maintaining Web Applications in VB.NET
  • Mastering ASP.NET with VB.NET
  • Web-based Application Deployment

^top

Additional Information for Stage 7:

• Exam 70-306 Developing and Implementing Windows-based Apps with MSVB .NET and MS Studio .NET:
  • Creating User Services for Windows Applications with VB.NET Testing, Debugging, and Maintaining Windows Applications in C#

^top

Additional Information for Stage 8:

• Exam 70-310 Developing XML Web Services and Server Components with MS VB .NET and the MS .NET Framework:
  • Building XML Web Services
  • Building Server Components with VB.NET

^top

Additional Information for Stage 9:

• Exam 70-300 Analysing Requirements and Defining MS .NET Solution Architectures:
  • Analysing Requirements and Defining Solution Architectures

^top

Additional Information for Stage 10:

• Exam 70-229: Designing and Implementing Databases with MS SQL Server 2000 Enterprise:
  • 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 11:

• 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 12:

• 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 13:

• 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 14:

• 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 15:

• 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

<< back to previous page