General Courses
10266A:Programming in C# with Microsoft Visual Studio 2010

  • Overview
  • Modules
  • Prerequisite
  • Schedule

The course focuses on C# program structure, language syntax, and implementation detailswith .NET Framework 4.0. This course describes the new enhancements in the C# 4.0 language by using Visual Studio 2010.

In this course, lower-intermediate level programmers gain the knowledge and skills they need to develop C# applications for the Microsoft .NET Framework 4.0. The course highlights the structure of C# 4.0 programs, language syntax, and implementation details. This course is not mapped to any exam.

Audience Profile

This course is intended for experienced developers who already have programming experience in C, C++, Visual Basic, or Java and understand the concepts of object-oriented programming.
This course is not designed for new programmers; it is targeted at professional developers with at least 12 months experience of programming in an object-oriented environment.

Module 1: Introducing C# and the .NET Framework  

  • Introduction to the .NET Framework
  • Creating Projects Within Visual Studio 2010
  • Writing a C# Application
  • Building a Graphical Application
  • Documenting an Application
  • Running and Debugging Applications by Using Visual Studio 2010

Module 2: Using C# Programming Constructs  

  • Declaring Variables and Assigning Values
  • Using Expressions and Operators
  • Creating and Using Arrays
  • Using Decision Statements
  • Using Iteration Statements

Module 3: Declaring and Calling Methods  

  • Defining and Invoking Methods
  • Specifying Optional Parameters and Output Parameters

Module 4: Handling Exceptions  

  • Handling Exceptions
  • Raising Exceptions

Module 5: Reading and Writing Files  

  • Accessing the File System
  • Reading and Writing Files by Using Streams

Module 6: Creating New Types  

  • Creating and Using Enumerations
  • Creating and Using Classes
  • Creating and Using Structs
  • Comparing References to Values

Module 7: Encapsulating Data and Methods  

  • Controlling Visibility of Type Members
  • Sharing Methods and Data

Module 8: Inheriting From Classes and Implementing Interfaces  

  • Using Inheritance to Define New Reference Types
  • Defining and Implementing Interfaces
  • Defining Abstract Classes

Module 9: Managing the Lifetime of Objects and Controlling Resources

  • Introduction to Garbage Collection
  • Managing Resources

Module 10: Encapsulating Data and Defining Overloaded Operators

  • Creating and Using Properties
  • Creating and Using Indexers
  • Overloading Operators

Module 11: Decoupling Methods and Handling Events  

  • Declaring and Using Delegates
  • Using Lambda Expressions
  • Handling Events

Module 12: Using Collections and Building Generic Types  

  • Using Collections
  • Creating and Using Generic Types
  • Defining Generic Interfaces and Understanding Variance
  • Using Generic Methods and Delegates

Module 13: Building and Enumerating Custom Collection Classes

  • Implementing a Custom Collection Class
  • Adding an Enumerator to a Custom Collection Class

Module 14: Using LINQ to Query  

  • Using the LINQ Extension Methods and Query Operators
  • Building Dynamic LINQ Queries and Expressions

Module 15: Integrating Visual C# Code with Dynamic Languages and COM Components  

  • Integrating C# Code with Ruby and Python
  • Accessing COM Components from C#

Before attending this course, students must have:

  • At least 12 months experience working with an Object Oriented language
  • Have C++ or Java knowledge:
    • Creating Classes
    • Inheritance and Abstraction
    • Polymorphism
    • Interfaces
    • Exceptions
  • Knowledge of the Visual Studio IDE.
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.
10267A: Introduction to Web Development with Microsoft Visual Studio 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010.

Audience Profile

This course is intended for Web developers who are beginners and have knowledge of Hypertext Markup Language (HTML) or Dynamic HTML (DHTML), along with some knowledge of a scripting language such as Visual Basic Scripting Edition or Microsoft Jscript.
Students are required to have the following skills:

  • Ability to construct a simple Web page using a Microsoft or 3rd Party tool. For example, create or customize a Web Page on a SharePoint site.

Module 1: Exploring Microsoft ASP.NET Web Applications in Microsoft Visual Studio 2010

  • Introduction to the .NET Framework
  • Overview of ASP.NET
  • Overview of the Lab Application

Module 2: Creating Web Applications by Using Microsoft Visual Studio 2010 and Microsoft .NET–Based Languages

  • Choosing a Programming Language
  • Overview of Visual Studio 2010
  • Creating a Simple Web Application

Module 3: Creating a Microsoft ASP.NET Web Form

  • Creating Web Forms
  • Adding and Configuring Server Controls in a Web Form

Module 4: Adding Functionality to a Microsoft ASP.NET Web Form

  • Working with Code-Behind Files
  • Handling Server Control Events
  • Creating Classes and Components by Using Visual Studio 2010
  • Handling Page Events

Module 5: Implementing Master Pages and User Controls

  • Creating Master Pages
  • Adding User Controls to an ASP.NET Web Form

Module 6: Validating User Input

  • Overview of User Input Validation
  • ASP.NET Validation Controls
  • Validating Web Forms

Module 7: Troubleshooting Microsoft ASP.NET Web Applications

  • Debugging in ASP.NET
  • Tracing in ASP.NET

Module 8: Managing Data in an Microsoft ASP.NET 4.0 Web Application

  • Overview of ADO.NET
  • Connecting to a Database  
  • Managing Data

Module 9: Managing Data Access Tasks by Using LINQ

  • Overview of LINQ
  • Managing XML Data by Using LINQ to XML
  • Managing SQL Data by Using LINQ to SQL and LINQ to Entities

Module 10: Managing Data by Using Microsoft ASP.NET Dynamic Data

  • Overview of ASP.NET Dynamic Data
  • Applying ASP.NET Dynamic Data
  • Customizing ASP.NET Dynamic Data Applications

Module 11: Creating a Microsoft ASP.NET Ajax-enabled Web Forms Application

  • Introduction to Ajax
  • Creating an ASP.NET Ajax Application by Using the Ajax Features for ASP.NET
  • Extending an ASP.NET Web Forms Application by Using the Ajax Control Toolkit

Module 12: Consuming Microsoft Windows Communication Foundation Services

  • Overview of Windows Communication Foundation Services
  • Calling Windows Communication Foundation Services
  • Working with WCF Data Services

Module 13: Managing State in Web Applications

  • State Management
  • ASP.NET Profiles
  • ASP.NET Caching

Module 14: Configuring and Deploying a Microsoft ASP.NET Web Application

  • Configuring an ASP.NET Web Application
  • Deploying an ASP.NET Web Application

Module 15: Securing a Microsoft ASP.NET Web Application

  • Overview of Web Application Security
  • Declaratively Configuring Authentication and Authorization
  • Working Programmatically with Authentication and Authorization

Module 16: Implementing Advanced Technologies Supported by Microsoft Visual Studio 2010 for Web Development

  • Working with the ASP.NET MVC 2 Framework
  • Working with Silverlight 4

Before attending this course, students must have at least one month of experience in .NET technologies. In addition to their professional experience, students who attend this training should have the following technical knowledge:

  • Knowledge of HTML or DHTML, including:
    • Tables
    • Images
    • Forms
  • Programming experience using Visual Basic .NET or Visual C# .NET, including:
    • Declaring variables
    • Using loops
    • Using conditional statements
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.
10550A: Programming in Visual Basic with Microsoft Visual Studio 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

This course teaches you Visual Basic language syntax, program structure, and implementation by using Microsoft Visual Studio 2010 and the Microsoft .NET Framework 4.
This course provides a solid foundation in Visual Basic to the level necessary to enable students to attend other courses in the Technical Specialist tracks

Audience Profile

This course is intended for experienced developers who already have programming experience in Visual Basic, C, C++, C#, or Java, and understand the concepts of Object Oriented Programming. These developers will be likely to develop enterprise business solutions.
These professional developers will be attending the course so that they can quickly ramp up on Visual Basic Programming in the .NET Framework. The course focuses on Visual Basic program structure, language syntax, and implementation details with the .NET Framework 4.0. This course also focuses on new enhancement in the Visual Basic 2010 language using Visual Studio 2010.

Module 1: Introducing Visual Basic and the .NET Framework

  • Introduction to the .NET Framework 4
  • Creating Projects Within Visual Studio 2010
  • Writing a Visual Basic Application
  • Building a Graphical Application
  • Documenting an Application
  • Debugging Applications by Using Visual Studio 2010

Module 2: Using Visual Basic Programming Constructs

  • Declaring Variables and Assigning Values
  • Using Expressions and Operators
  • Creating and Using Arrays
  • Using Decision Statements
  • Using Iteration Statements

Module 3: Declaring and Calling Methods

  • Defining and Invoking Methods
  • Specifying Optional Parameters and ByRef Parameters

Module 4: Handling Exceptions

  • Handling Exceptions
  • Raising Exceptions

Module 5: Reading and Writing Files

  • Accessing the File System
  • Reading and Writing Files by Using Streams

Module 6: Creating New Types

  • Creating and Using Modules and Enumerations
  • Creating and Using Classes
  • Creating and Using Structures
  • Comparing References to Values

Module 7: Encapsulating Data and Methods

  • Controlling Visibility of Type Members
  • Sharing Methods and Data

Module 8: Inheriting from Classes and Implementing Interfaces

  • Using Inheritance to Define New Reference Types
  • Defining and Implementing Interfaces
  • Defining Abstract Classes

Module 9: Managing the Lifetime of Objects and Controlling Resources

  • Introduction to Garbage Collection
  • Managing Resources

Module 10: Encapsulating Data and Defining Overloaded Operators

  • Creating and Using Properties
  • Creating and Using Indexers
  • Overloading Operators

Module 11: Decoupling Methods and Handling Events

  • Declaring and Using Delegates
  • Using Lambda Expressions
  • Handling Events

Module 12: Using Collections and Building Generic Types

  • Using Collections
  • Creating and Using Generic Types
  • Defining Generic Interfaces and Understanding Variance
  • Using Generic Methods and Delegates

Module 13: Building and Enumerating Custom Collection Classes

  • Implementing a Custom Collection Class
  • Adding an Enumerator to a Custom Collection Class

Module 14: Using LINQ to Query Data

  • Using the LINQ Extension Methods and Query Operators
  • Building Dynamic LINQ Queries and Expressions

Module 15: Integrating Visual Basic Code with Dynamic Languages and COM Components

  • Integrating Visual Basic Code with Ruby and Python
  • Accessing COM Components from Visual Basic

This course requires that you meet the following prerequisites:

  • This course is targeted at developers who already have Visual Basic knowledge.
  • This course is not for new developers; at least 12 months experience working with an Object Oriented language is expected.
    • Creating classes
    • Inheritance and abstraction
    • Polymorphism
    • Interfaces
    • Delegates 
    • Events 
    • Exceptions
  • Experience with the Microsoft .NET Framework
  • Knowledge of the Visual Studio integrated development environment (IDE).
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.


70-511 MCTS: Windows Applications Development with Microsoft .NET Framework 4
10262A: Developing Windows® Applications with Microsoft® Visual Studio® 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

In this course, experienced developers who know the basics of Windows Forms development gain more advanced Windows Client design and development skills. WinForms and WPF programming models, as well as relative strengths and when to use each technology, are covered.

Audience Profile

This course is intended for Technology Specialists in the area of Windows Client Development who work in a development environment that uses Microsoft Visual Studio .NET 2010 and Microsoft .NET Framework 4.0 to create rich client applications for Windows.

Module 1: Windows Client Application Design

  • Windows Client Technologies
  • Architectural Patterns
  • Interoperability between Windows Forms and WPF

Module 2: Introduction to Visual Studio 2010 and WPF Version 4

  • What’s New in Visual Studio 2010?
  • What’s New in WPF Version 4

Module 3: Designing and Developing a User Interface

  • Defining Page Layout
  • Using Content Controls
  • Using Item Controls
  • Sharing Logical Resources in a Window

Module 4: Taking Control of the User Interface

  • Sharing Logical Resources in an Application
  • Creating Consistent User Interfaces by Using Styles
  • Changing the Appearance of Controls by Using Templates
  • Handling Events and Commands

Module 5: Testing, Unit Testing, and Debugging

  • WPF Testing Strategies
  • Debugging XAML
  • Providing User Feedback for Unhandled Exceptions
  • Understanding Security Features

Module 6: Simple Data Binding and Validation

  • Overview of Data Binding
  • Creating a Data Binding
  • Implementing Property Change Notification
  • Converting Data
  • Validating Data
  • Presenting Data at Design Time

Module 7: Data Binding to Collections

  • Binding to Collections of Objects
  • Using Collection Views
  • Creating Master-Detail User Interfaces
  • Using Data Templates
  • Presenting Design Time Data Collections

Module 8: Enhancing UI Responsiveness

  • Implementing Asynchronous Processes
  • Implementing Responsive User Interfaces

Module 9: Integrating Localization and User Assistance Features

  • Localization and Globalization
  • Implementing User Assistance Features
  • Providing User Accessibility Features

Module 10: WPF 2D Graphics, Multimedia, and Printing

  • Displaying 2D Graphics
  • Displaying Images
  • Adding Multimedia to WPF Applications
  • Creating and Printing Documents

Module 11: Control Customization

  • Overview of Control Authoring
  • Creating User Controls
  • Creating Custom Controls
  • Managing Control Appearance by Using Visual States
  • Integrating WPF and Windows Forms

Module 12: Attached Properties and Behaviors in WPF

  • Implementing Attached Properties
  • Implementing Drag-and-Drop User Interfaces
  • Implementing Expression Blend Behaviors, Triggers and Actions

Module 13: Animations in WPF

  • Using Animations
  • Using Triggers
  • Implementing Data Visualizations

Module 14: Application State, Settings, and Lifecycle

  • Creating Application Settings
  • Consuming Application Settings
  • Creating Custom Configuration Sections

Module 15: Configure and Deploy Windows Client Applications

  • Deployment Options
  • Deploying a Standalone WPF Application
  • Deploying an XBAP Application
  • Configuring Security Settings

This course requires that you meet the following prerequisites:

Before attending this course, students must have:

  • An understanding of the problem-solving techniques that apply to software development, including the following principles of software development:
    • modern software development models
    • typical phases of a software development lifecycle
    • concepts of event-driven programming
    • concepts of object-oriented programming
    • creating use-case diagrams
    • designing and building a user interface
    • developing a structured application
  • A general understanding of the purpose, function, and features of following .NET Framework topics:
    • Common Language Runtime
    • .NET Framework class library
    • Common Type System
    • Component interoperation
    • Cross-Language Interoperability
    • Assemblies in the Common Language Runtime
    • Application Domains
    • Runtime hosts supported by the .NET Framework
  • Experience using Visual Studio 2008 in the following task areas:
    • Declaring and initializing typed variables using the Camel case naming convention
    • Using arithmetic, relational, and logical operators in code statements
    • Using branching statements to control code execution
    • Using looping statements to iterate through collections or repeat steps until a specified condition is met
    • Creating classes and methods to establish the basic structure of an application
    • Using methods and events to implement the programming logic of an application
    • Identifying syntax and logic errors
    • Accessing and managing data from a data source
  • Experience in object oriented design and development as follows:
    • Creating and accessing classes and class properties
    • Creating and accessing methods and overloaded methods
    • Implementing inheritance, base classes, and abstract classes
    • Declaring, raising, and handling events
    • Responding to and throwing exceptions
    • Implementing interfaces and polymorphism
    • Implementing shared and static members
    • Implementing generics
    • Creating components and class libraries
  • Experience in N-Tier application design and development as follows:
    • Managing a software development process
    • Controlling input at the user interface level in Windows Client applications
    • Debugging, tracing, and profiling .NET applications
    • Monitoring and logging .NET applications
    • Implementing basic testing best practices
    • Performing basic Data Access tasks with LINQ
      • Basics of LINQ to XML
      • Basics of LINQ to Entities
      • Basics of LINQ to SQL
    • Implementing basic security best practices in .NET Applications
      • Basics of Code Access Security
      • Basics of Role-Based Security
      • Basics of Cryptography Services
    • Implementing basic service calls 
      • Basics of consuming XML Web Services
      • Basics of consuming WCF Services
    • Using .NET Configuration Files
    • Deploying .Net Framework Applications using ClickOnce and the MS Installer
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.


70-513 MCTS : WCF Development with Microsoft .NET Framework 4
10263A: Developing WCF Solutions with Microsoft® Visual Studio® 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

This three-day instructor-led course provides participants with the knowledge and skills to develop distributed applications using WCF 4 and Microsoft Visual Studio 2010.

Important Note: Course 10263A is designed for experienced .NET developers who are interested in becoming Technology Specialists in the area of WCF application development (see intended audience and prerequisites in this syllabus). For classrooms that include less experienced students, instructors may choose to adjust the course timings and establish a slower pace through the training material. To deliver this course at a reduced pace, Microsoft Learning suggests teaching Modules 1-7 during the three days of classroom training and leaving module 8 for the students to explore on their own after the course is completed. This will enable the instructor to spend more time ensuring that students fully understand the concepts taught in the earlier modules. Learning Partners may also choose to extend the course materials and establish a 4-day customized training course that progresses at a slower pace.

Audience Profile

This course is intended for professional .NET programmers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. Students should have experience consuming services within their Web and/or Windows client applications and be interested in learning to develop service-oriented applications (SOA) using WCF. Students should be experienced users of Microsoft Visual Studio 2008 SP1, as well as cursory familiarity with Microsoft Visual Studio 2010 for Windows client or Web application development.

Module 1: Service-Oriented Architecture

  • What Is SOA?
  • The Benefits of SOA
  • Scenarios and Standards
  • Introduction to WCF

Module 2: Getting Started with Microsoft Windows Communication Foundation Development

  • Service Contract and Implementation
  • Hosting WCF Services
  • WCF Behaviors
  • Consuming WCF Services

Module 3: Hosting Microsoft Windows Communication Foundation Services

  • WCF Service Hosts
  • ServiceHost
  • Hosting WCF Services in Windows Services
  • IIS, WAS, and AppFabric
  • Configuring WCF Hosts
  • Service Hosting Best Practices

Module 4: Defining and Implementing Microsoft Windows Communication Foundation Contracts

  • What Is a Contract?
  • Contract Types
  • Messaging Patterns
  • Designing WCF Contracts

Module 5: Endpoints and Behaviors

  • Multiple Endpoints and Interoperability
  • WCF Discovery
  • WCF Default Endpoints
  • Instancing and Concurrency
  • Reliability

Module 6: Testing and Troubleshooting Microsoft Windows Communication Foundation Services

  • Errors and Symptoms
  • WCF Faults
  • Debugging and Diagnostics Tools
  • Runtime Governance

Module 7: Security

  • Introduction to Application Security
  • The WCF Security Model
  • Transport and Message Security
  • Authentication and Authorization
  • Claim-Based Identity

Module 8: Introduction to Advanced Microsoft Windows Communication Foundation Topics

  • The Asynchronous Invocation Pattern
  • Extending WCF
  • Routing
  • Workflow Services

Before attending this course, students must have:

  • Understanding of the problem-solving techniques that apply to software development.
  • General understanding of the purpose, function, and features of the .NET Framework.
  • Experience developing software using Visual Studio 2008 or Visual Studio 2010.
  • Experience in object-oriented design and development using the C# programming language.
  • Experience in n-tier application design and development.
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.


70-515 MCTS : Web Applications Development with Microsoft .NET Framework 4
10264A: Developing Web Applications with Microsoft® Visual Studio® 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

In this course, students will learn to develop advanced ASP.NET MVC and Web Forms applications using .NET Framework 4 tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used. This will also prepare the student for exam 70-515.

Audience Profile

This course is intended for professional Web developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. Members of the audience have a minimum of two to three years of experience developing Web-based applications by using Microsoft Visual Studio and Microsoft ASP.NET. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1 and newer releases of the Visual Studio product. The audience understands how to use the new features of Visual Studio 2010.

Module 1: Overview of Web Application Design

  • Overview of IIS 7.0
  • Overview of ASP.NET 4.0
  • Introduction to the MVC Framework
  • Overview of the Request Life Cycle

Module 2: Designing a Web Application

  • Web Applications: Case Studies
  • Web Application Design Essentials
  • Guidelines for Determining When to Use Web Forms and MVC

Module 3: Developing MVC Models

  • Exploring Ways to Create MVC Models
  • Creating a Data Repository

Module 4: Developing MVC Controllers

  • Implementing MVC Controllers
  • Creating Action Methods

Module 5: Developing MVC Views

  • Implementing MVC Views
  • Implementing Strongly-Typed MVC Views
  • Implementing Partial MVC Views

Module 6: Designing for Discoverability

  • Overview of Search Engine Optimization
  • Creating the Robots and Sitemap Files
  • Using ASP.NET Routing

Module 7: Writing Server-Side Code for Web Forms

  • Overview of the Structure of a Web Application
  • Controlling ViewState
  • Localizing a Web Application
  • Persisting Data on a Web Forms Page
  • Validating User Input

Module 8: Optimizing Data Management for Web Forms

  • Managing Data by Using LINQ to Entities
  • Using Data Source Controls
  • Using ASP.NET Dynamic Data

Module 9: Ensuring Quality by Debugging, Unit Testing, and Refactoring

  • Debugging and Refactoring Code
  • Unit Testing Code
  • Processing Unhandled Exceptions
  • Test Driven Development

Module 10: Securing a Web Application

  • Configuring Authentication
  • Configuring ASP.NET Membership
  • Managing Authorization by Using ASP.NET Roles

Module 11: Applying Master Pages and CSS

  • Applying Master Pages
  • Applying CSS, Skins, and Themes

Module 12: Developing Client Side Scripts and Services

  • Developing Client-Side Scripts
  • Implementing AJAX
  • Creating Services

Module 13: Implementing Advanced AJAX in a Web Application

  • Implementing Ajax in ASP.NET MVC Pages Using Microsoft Ajax
  • Implementing Ajax in ASP.NET MVC Pages Using jQuery
  • Working With jQuery and Ajax Events

Module 14: Deploying a Web Application

  • Overview of Web Application Deployments
  • Overview of Web Site Deployments
  • Deploying AdventureWorks

Module 15: Developing a Web Application by Using Silverlight

  • Introduction to Rich Internet Applications
  • Overview of Silverlight
  • Creating a Silverlight Application

This course requires that you meet the following prerequisites:

In addition to their professional Web development experience, students who attend this training should have the following technical knowledge:

  • An understanding of the problem-solving techniques that apply to software development, including the following principles of software development:
    • modern software development model
    • typical phases of a software development lifecycle
    • concepts of event-driven programming
    • concepts of object-oriented programming
    • creating use-case diagrams
    • designing and building a user interface
    • developing a structured application
  • A basic understanding of the following scripting techniques and some hands-on experience writing scripts:
    • Web scripting techniques
    • Macro scripting techniques
    • Windows scripting techniques
  • A general understanding of the purpose, function, and features of following .NET Framework topics:
    • Common Language Runtime
    • .NET Framework class library
    • Common Type System
    • Component interoperation
    • Cross-Language Interoperability
    • Assemblies in the Common Language Runtime
    • Application Domains
    • Runtime hosts supported by the .NET Framework
  • Experience using Visual Studio 2008 in the following task areas:
    • Declaring and initializing typed variables using the Camel case naming convention
    • Using arithmetic, relational, and logical operators in code statements
    • Using branching statements to control code execution
    • Using looping statements to iterate through collections or repeat steps until a specified condition is met
    • Creating classes and methods to establish the basic structure of an application
    • Using methods and events to implement the programming logic of an application
    • Identifying syntax and logic errors
    • Accessing and managing data from a data source
  • Experience in object oriented design and development as follows:
    • Creating and accessing classes and class properties
    • Creating and accessing methods and overloaded methods
    • Implementing inheritance, base classes, and abstract classes
    • Declaring, raising, and handling events
    • Responding to and throwing exceptions
    • Implementing interfaces and polymorphism
    • Implementing shared and static members
    • Implementing generics
    • Creating components and class libraries
  • Experience in N-Tier application design and development as follows:
    • Managing a software development process
    • Controlling input at the user interface level in Windows Client and Web applications
    • Debugging, tracing, and profiling .NET applications
    • Monitoring and logging .NET applications
    • Implementing basic testing best practices
    • Performing basic Data Access tasks with LINQ
    • Implementing basic security best practices in .NET Applications
    • Implementing basic service calls 
    • Using .NET Configuration Files
Deploying .NET Framework Applications using ClickOnce and the MS Installer
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.


70-516 MCTS : Accessing Data with Microsoft .NET Framework 4
10265A: Developing Data Access Solutions with Microsoft® Visual Studio® 2010

  • Overview
  • Modules
  • Prerequisites
  • Schedule

In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET

Audience Profile

This course is intended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. They will have experience implementing data access and data binding within their Web and/or Windows client applications and are interested in learning to optimize data access code in their applications by using the Entity Framework, LINQ, and ADO.NET. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The audience has some experience using Visual Studio 2010 for either Windows client or Web application development.
Typically, this audience has the following knowledge/experience:

  • Experience developing n-tier applications that access various data sources
  • Experience implementing data binding within their applications
  • Some experience using LINQ and ADO.NET
  • A conceptual understanding of the Entity Framework

Module 1: Architecture and Data Access Technologies

  • Data Access Technologies
  • Data Access Scenarios

Module 2: Building Entity Data Models

  • Introduction to Entity Data Models
  • Modifying the Entity Data Model
  • Customizing the Entity Data Model

Module 3: Querying Entity Data

  • Retrieving Data by Using LINQ to Entities
  • Retrieving Data by Using Entity SQL
  • Retrieving Data by Using EntityClient Provider
  • Retrieving Data by Using Stored Procedures
  • Unit Testing Your Data Access Code

Module 4: Creating, Updating, and Deleting Entity Data

  • Understanding Change Tracking in the Entity Framework
  • Modifying Data in an Entity Data Model

Module 5: Handling Multi-User Scenarios by Using Object Services

  • Handling Concurrency in the Entity Framework
  • Transactional Support in the Entity Framework

Module 6: Building Optimized Solutions by Using Object Services

  • The Stages of Query Execution
  • Change Tracking and Object Materialization
  • Using Compiled Queries
  • Using Design-Time Generated Entity Framework Views
  • Monitoring Performance
  • Performing Asynchronous Data Modifications

Module 7: Customizing Entities and Building Custom Entity Classes

  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes

Module 8: Using POCO Classes with the Entity Framework

  • Requirements for POCO Classes
  • POCO Classes and Lazy Loading
  • POCO Classes and Change Tracking
  • Extending Entity Types

Module 9: Building an N-Tier Solution by Using the Entity Framework

  • Designing an N-Tier Solution
  • Defining Operations and Implementing Data Transport Structures
  • Protecting Data and Operations

Module 10: Handling Updates in an N-Tier Solution by Using the Entity Framework

  • Tracking Entities and Persisting Changes
  • Managing Exceptions in an N-Tier Solution

Module 11: Building Occasionally Connected Solutions

  • Offline Data Caching by Using XML
  • Using the Sync Framework

Module 12: Querying Data by Using WCF Data Services

  • Introduction to WCF Data Services
  • Creating a WCF Data Service
  • Consuming a WCF Data Service
  • Protecting Data and Operations in a WCF Data Service

Module 13: Updating Data by Using WCF Data Services

  • Creating, Updating, and Deleting Data in a WCF Data Service
  • Preventing Unauthorized Updates and Improving Performance
  • Using WCF Data Services with Nonrelational Data

Module 14: Using ADO.NET

  • Retrieving and Modifying Data by Using ADO.NET Commands
  • Retrieving and Modifying Data by Using DataSets
  • Managing Transactions and Concurrency in Multiuser Scenarios

Module 15: Using LINQ to SQL

  • Implementing a Logical Data Model by Using LINQ to SQL
  • Managing Performance and Handling Concurrency

This course requires that you meet the following prerequisites:

Before attending this course, students must have:

  • An understanding of the problem-solving techniques that apply to software development, including the following principles of software development:
    • Modern software development models
    • Typical phases of a software development lifecycle
    • Concepts of event-driven programming
    • Concepts of object-oriented programming
    • Creating use-case diagrams
    • Designing and building a user interface
    • Developing a structured application
  • A basic understanding of the following scripting techniques and some hands-on experience writing scripts:
    • Web scripting techniques
    • Macro scripting techniques
    • Windows scripting techniques
  • A general understanding of the purpose, function, and features of following .NET Framework topics:
    • Common Language Runtime
    • .NET Framework class library
    • Common Type System
    • Component interoperation
    • Cross-language interoperability
    • Assemblies in the Common Language Runtime
    • Application domains
    • Runtime hosts supported by the .NET Framework
  • Experience using Visual Studio 2008 in the following task areas:
    • Declaring and initializing typed variables using the Camel case naming convention
    • Using arithmetic, relational, and logical operators in code statements
    • Using branching statements to control code execution
    • Using looping statements to iterate through collections or repeat steps until a specified condition is met
    • Creating classes and methods to establish the basic structure of an application
    • Using methods and events to implement the programming logic of an application
    • Identifying syntax and logic errors
    • Accessing and managing data from a data source
  • Experience in object oriented design and development as follows:
    • Creating and accessing classes and class properties
    • Creating and accessing methods and overloaded methods
    • Implementing inheritance, base classes, and abstract classes
    • Declaring, raising, and handling events
    • Responding to and throwing exceptions
    • Implementing interfaces and polymorphism
    • Implementing shared and static members
    • Implementing generics
    • Creating components and class libraries
  • Experience in N-Tier application design and development as follows:
    • Managing a software development process
    • Controlling input at the user interface level in Windows client and Web applications
    • Debugging, tracing, and profiling .NET applications
    • Monitoring and logging .NET applications
    • Implementing basic testing best practices
    • Performing basic data access tasks with LINQ
      • Basics of LINQ to XML
      • Basics of LINQ to Entities
      • Basics of LINQ to SQL
    • Implementing basic security best practices in .NET Applications
      • Basics of Code Access Security
      • Basics of Role-Based Security
      • Basics of Cryptography Services
    • Implementing basic service calls 
      • Basics of creating and consuming XML Web Services
      • Basics of creating and consuming WCF Services
    • Using .NET Configuration Files
    • Deploying .NET Framework Applications using ClickOnce and the MS Installer
  • Data access experience in Windows client application development as follows:
    • Connect to a data source
    • Implement data binding
    • Implement data validation at the UI layer
  • Data access experience in Web application development as follows:
    • Connect to a data source
    • Implement dynamic data
    • Implement data validation at the UI layer
Brunei Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
Sri Lanka Schedule
{January}
{February}
{March}
{April}
{May}
{June}
{July}
{August}
{September}
{October}
{November}
{December}
*Schedules posted are subject to change without prior notice. Please contact us for class reservation.