From beginner to high level Microsoft Database and Programming Certifications covering a range of cross-training Visual Studio programming .NET, C# and SQL 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: Microsoft Exam 70-536 MCTS: Microsoft .NET Framework 3.5 – Application Development Foundation

Stage 7: Microsoft Exam 70-561 MCTS: Microsoft .NET Framework 3.5 – Application Development

Stage 8: Microsoft Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance

Stage 9: Microsoft Exam 70-433 TS: Microsoft SQL Server 2008, Database Development

Stage 10: Microsoft Exam 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Stage 11: Microsoft Exam 70-562 MCTS: Microsoft .NET Framework 3.5, ASP .NET Application Development

Stage 12: Microsoft Exam 70-630: MCTS: Microsoft Office SharePoint Server 2007, Configuration

Stage 13: Microsoft Exam 70-631: MCTS: Microsoft Windows SharePoint Services 3.0, Configuration

Stage 14: Microsoft Exam 70-541: MCTS: Microsoft Windows SharePoint Services 3.0 – Application Development

Stage 15: Microsoft Exam 70-542: MCTS Microsoft Office SharePoint Server 2007 – Application Development

Course Code:

DPDC-1

Course Duration:

12 months

Typical Study Hours:

430 – 440 hours

Course Fees and Demo:

Request Fee Guide, Demo and Free Reports

Includes:

Online IT Technical Book Library

Study Prerequisite:

Basic computer knowledge.

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:

• Microsoft Exam 70-536 TS: Microsoft .NET Framework 2.0 – Application Development Foundation VB
  • Visual Basic: System Types and Collections
  • Visual Basic: Serialisation and I/O
  • Visual Basic: Customised Programming
  • Visual Basic: Security
  • Visual Basic: Threading, Service Processing, and Application Domains
  • Visual Basic: Diagnostics and Management

^top

Additional Information for Stage 7:

• Microsoft Exam 70-561 TS: Microsoft .NET Framework 3.5, ADO.NET Application Development
  • Getting Started With ADO.NET Connections and Commands
  • Managing ADO.NET Connections and Commands with VB 2008
  • Getting Started with DataSets using Visual Basic 2008
  • Viewing and Navigating Data with ADO.NET DataSets using Visual Basic 2008
  • Updating ADO.NET DataSets With Visual Basic 2008
  • Using Query Notifications and Synchronizing Data with Visual Basic 2008
  • The ADO.NET Entity Framework and LINQ

^top

Additional Information for Stage 8:

• Microsoft Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance
  • SQL Server 2008 Installation
  • SQL Server 2008 Instance and Database Configuration
  • SQL Server 2008 Security Management
  • SQL Server 2008 Database Management
  • SQL Server 2008 Data Management
  • SQL Server 2008 Database Monitoring and Performance
  • SQL Server 2008 Backups, Restores, and Database Snapshots
  • SQL Server 2008 High Availability and Disaster Recovery

^top

Additional Information for Stage 9:

• Microsoft Exam 70-433 TS: Microsoft SQL Server 2008, Database Development
  • Creating and Implementing Database Objects in SQL Server 2008
  • Creating and Modifying Table and Index Partitions in SQL Server 2008
  • Running Queries and Manipulating Data in SQL Server 2008
  • Performing Advanced Query Techniques in SQL Server 2008
  • Creating and Implementing Programming Objects in SQL Server 2008
  • Querying and Managing XML Data in SQL Server 2008
  • Using SQL Server 2008 Messaging, Full-Text Search, Scripts, and Track Changes
  • Gathering Performance Data in SQL Server 2008

^top

Additional Information for Stage 10:

• Microsoft Exam 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
  • Implementing SQL Server 2008 Integration Services
  • Configuring SQL Server 2008 Integration Services Packages
  • Deploying SQL Server 2008 Integration Services Packages
  • Managing SSIS Packages in SQL Server 2008
  • Implementing SQL Server 2008 Reporting Services Solutions
  • Deploying and Delivering SQL Server 2008
  • Reporting Services Reports
  • Maintaining SQL Server 2008 Reporting Services
  • Implementing SQL Server 2008 Analysis Services Solutions
  • Querying Cubes and Working with Data Mining in SSAS
  • Managing SQL Server 2008 Analysis Services Solutions

^top

Additional Information for Stage 11:

• Microsoft Exam 70-562 MCTS: Microsoft .NET Framework 3.5, ASP .NET Application Development
  • Developing Web Applications with Visual Basic 2008 and ASP.NET 3.5
  • Creating and Consuming Server Controls with Visual Basic 2008 and ASP.NET 3.5
  • Data and Services Integration with Visual Basic 2008 and ASP.NET 3.5
  • ASP.NET AJAX and Client-Side Scripting with Visual Basic 2008 and ASP.NET 3.5
  • ASP.NET AJAX and Client-Side Scripting with Visual Basic 2008 and ASP.NET 3.5
  • Configuring and Deploying Web Application with Visual Basic 2008 and ASP.NET 3.5
  • Configuring and Deploying Web Application with Visual Basic 2008 and ASP.NET 3.5
  • Optimisation and Customisation with Visual Basic 2008 and ASP.NET 3.5

^top

Additional Information for Stage 12:

• Microsoft Exam 70-630: MCTS: Microsoft Office SharePoint Server 2007, Configuration
  • Implementing Microsoft Office SharePoint Server 2007
  • Configuring Microsoft Office SharePoint Server 2007 Content Management
  • Configuring Microsoft Office SharePoint Server 2007 Business Forms
  • Configuring Microsoft Office SharePoint Server 2007 Business Intelligence
  • Managing Microsoft Office SharePoint Server 2007 Administration
  • Upgrading to Microsoft Office SharePoint Server 2007

^top

Additional Information for Stage 13:

• Microsoft Exam 70-631: MCTS: Microsoft Windows SharePoint Services 3.0, Configuration
  • Deploying Windows SharePoint Services 3.0
  • Configure Network Infrastructure for Windows SharePoint Services 3.0
  • Configure Security for Windows SharePoint Services 3.0
  • Administer Windows SharePoint Services 3.0
  • Advanced Customisation in Windows SharePoint Services 3.0
  • Monitor Windows SharePoint Services 3.0

^top

Additional Information for Stage 14:

• Microsoft Exam 70-541: MCTS: Microsoft Windows SharePoint Services 3.0 – Application Development
  • Getting Started with WSS
  • Working with the WSS Object Model
  • Features and Solutions in WSS
  • Working with Lists and ListItems
  • Extending WSS with .NET Components
  • Creating Web Parts for WSS
  • Implementing and Deploying Workflows

^top

Additional Information for Stage 15:

• Microsoft Exam 70-542: MCTS Microsoft Office SharePoint Server 2007 – Application Development
  • Managing Enterprise Content with MOSS 2007
  • Integrating Business Data using MOSS 2007
  • Creating Business Intelligence Solutions with MOSS 2007
  • Application Platform Services within MOSS 2007
  • Searching Data Using MOSS 2007
  • Targeting and Customising with MOSS 2007

^top