From beginner to high level Microsoft Database and Programming Certifications covering a range of cross-training Visual Studio programming ADO.NET 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-502 MCTS: Microsoft .NET Framework 3.5 – Windows Presentation Foundation Application Development

Stage 12: Microsoft Exam 70-503 MCTS: Microsoft .NET Framework 3.5 – Windows Communication Foundation Application Development

Stage 13: Microsoft Exam 70-504 MCTS: Microsoft .NET Framework 3.5 – Windows Workflow Foundation Application Development

Stage 14: Microsoft Exam 70-505 MCTS: Microsoft .NET Framework 3.5 – Windows Forms Applications

Course Code:

DPDE-1

Course Duration:

12 months

Typical Study Hours:

410 – 420 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-502 TS: Microsoft .NET Framework 3.5 – Windows Presentation Foundation Application Development
  • Creating WPF Applications with Visual Basic 2008
  • Creating User Interfaces with WPF and Visual Basic 2008
  • WPF Content Creation and Management with Visual Basic 2008
  • WPF Databinding with Visual Basic 2008
  • Customizing and Deploying WPF Applications with Visual Basic 2008

^top

Additional Information for Stage 12:

• Microsoft Exam 70-503 MCTS: Microsoft .NET Framework 3.5 – Windows Communication Foundation Application Development
  • Getting Started with WCF
  • Securing and Managing a WCF Application
  • WCF Contracts, Behaviors, and Data Management

^top

Additional Information for Stage 13:

• Microsoft Exam 70-504 MCTS: Microsoft .NET Framework 3.5 – Windows Workflow Foundation Application Development
  • WCF Contracts, Behaviors, and Data Management
• Activities, Rules, and Conditions in WF with Visual Basic 2008
• Transactions, Compensations, and Runtime Services in WF with Visual Basic 2008

^top

Additional Information for Stage 14:

• Microsoft Exam 70-505 MCTS: Microsoft .NET Framework 3.5 – Windows Forms Applications
  • Windows Forms Creation with Visual Basic 2008
  • Data Integration with Visual Basic 2008
  • Database Environments and XML Handling with Visual Basic 2008
  • Printing, MDI Forms, and Usability with Visual Basic 2008
  • Custom Controls and Asynchronous Programming with Visual Basic 2008
  • Application Configuration and Deployment with Visual Basic 2008

^top