Home » Microsoft Training Courses » Microsoft ADO.NET & SQL Programming

Microsoft ADO .NET and SQL Programming

From beginner to high level Microsoft Visual Basic ADO.NET and SQL Programmer - in one course!

Course Contents:

Stage 1: Software Programming Fundamentals

Stage 2: Programming Best Practices

Stage 3: Software Development Principles

Stage 4: Microsoft Exam 70-536 MCTS: Microsoft .NET Framework 3.5 - Application Development Foundation

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

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

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

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

Course Code:

MADO-1

Course Duration:

12 months

Typical Study Hours:

200 - 210 hours

Course Fees:

See our Fee Guide

Course Demo:

Request an online Course Demo

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:

• Microsoft Exam 70-536 MCTS: Microsoft .NET Framework 3.5 - Application Development Foundation

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

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

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

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

• 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

<< back to previous page