This five-day instructor-led course forms part of the Fastrack2.NET programme. By combining Microsoft Official Curriculum with a focused and accelerated delivery, an individual can gain a deep understanding of .NET technologies in the shortest possible time. With a quicker pace of delivery, these courses are designed for individuals with existing Visual Basic experience who need to start developing with Microsoft .NET. By reducing the time to acquire sound .NET skills, we provide greater flexibility and reduced cost of platform migration.

This course combines an accelerated schedule of learning, and will teach Visual Basic programmers and Web application developers the fundamentals of Web application site implementation using ASP.NET. The course focuses on using the Microsoft Visual Studio .NET environment and the Microsoft .NET platform to create an ASP.NET Web application that delivers dynamic content to a Web site. In addition, the course covers building data-centric applications and Web services with ADO.NET and SQL Server.

This course covers many of the objectives of the Microsoft MCP, MCAD or MCSD certification programmes exams 70-305(VB) & 70-315

Experience developing applications with Visual Basic 4.0 or later

Exposure to XML documents, style sheets and schemas

Understanding of relational database concepts such as table, row, column, primary keys, foreign keys, constraints and views.

Familiarity with Microsoft's .NET strategy

Completed Fastrack2.NET Part 1 or have equivalent knowledge

INTRODUCTION AND WELCOME TO THE EVENT

INTRODUCTION TO ASP.NET:

Identify the languages that support ASP.NET.

Choose an appropriate development language for their needs.

Create a component by using Visual Studio .NET

Creating Web Forms

Using Server Controls

Creating the default.aspx Web Form

Creating the life.aspx Web Form

ADDING CODE TO A MICROSOFT ASP.NET WEB FORM:

Using Code-Behind Pages

Adding Event Procedures to Web Server Controls

Using Page Events

TRACING IN MICROSOFT ASP.NET WEB APPLICATIONS:

Understanding Tracing

Remote Debugging

VALIDATING USER INPUT:

The following areas are covered:

Using Validation Controls

Page Validation

CREATING USER CONTROLS:

Adding User Controls to an ASP.NET Web Form

Creating User Controls

More ….dependant on timing

ACCESSING RELATIONAL DATA WITH VISUAL STUDIO.NET:

Overview of ADO.NET

Creating a Connection to the Database

Displaying a DataSet in a List-Bound Control

Overview in preparation for ADO.NET modules

READING, WRITING AND CONSUMING XML WEB SERVICES:

Overview of Using XML Web Services

Calling an XML Web Service by HTTP

Using a Proxy to Call an XML Web Service

Creating an XML Web Service

ACCESSING RELATIONAL DATA WITH ADO.NET: (Introduction):

Overview of ADO.NET

Creating a Connection to the Database

Displaying a DataSet in a List-Bound Control

ACCESSING DATA WITH MICROSOFT ADO.NET:

Connecting to a Database

Accessing Data with DataSets

Using Multiple Tables

Accessing Data with DataReaders

CALLING STORED PROCEDURES WITH ADO.NET:

Overview of Stored Procedures

The instructor may choose to cover ADO.NET material from later in the course at this time.

READING AND WRITING XML DATA:

Overview of XML Architecture in ASP.NET

XML and the DataSet Object

Working with XML Data

Using the XML Web Server Control

CONSUMING AND CREATING XML WEB SERVICES:

Overview of Using XML Web Services

Calling an XML Web Service by HTTP

Using a Proxy to Call an XML Web Service

Creating an XML Web Service

MANAGING STATE:

State management

Application and Session Variables

Cookies and Cookieless Sessions

CONFIGURING, OPTIMIZING, AND DEPLOYING A ASP.NET WEB APPLICATION:

Using the Cache Object

Using ASP.NET Output Caching

Configuring an ASP.NET Web Application

Deploying an ASP.NET Web Application

HELPING TO PROTECT A MICROSOFT ASP.NET WEB APPLICATION:

Web Application Security Overview

Working with Windows-Based Authentication

Working with Forms-Based Authentication

Overview of Microsoft Passport Authentication

CONNECTING TO DATA SOURCES:

Working in a Connected Environment

Defining a Connection

Managing a Connection

Handling Connection Exceptions

Connection Pooling

PERFORMING CONNECTED DATABASE OPERATIONS:

Working in a Connected Environment

Building Command Objects

Executing Commands That Return a Single Value

Executing Commands That Return Rows

Executing Commands That Do Not Return Rows

Using Transactions

BUILDING DATASETS:

Working in a Disconnected Environment

Building DataSets and DataTables

Binding and Saving a DataSet

Defining Data Relationships

Modifying Data in a DataTable

Sorting and Filtering

READING AND WRITING XML WITH ADO.NET:

Creating XSD Schemas

Loading Schemas and Data into DataSets

Writing XML from a DataSet

BUILDING DATASETS FROM EXISTING DATA SOURCES:

Configuring a DataAdapter to Retrieve Information

Populating a DataSet Using a DataAdapter

Configuring a DataAdapter to Update the Underlying Data Source

Persisting Changes to a Data Source

How to Handle Conflicts

BUILDING AND CONSUMING A WEB SERVICE THAT USES ADO.NET:

Building and Consuming a Web Service That Returns Data

Delegates will learn how to

• Build a DataSet schema, populate it with data, and modify the data programmatically
• Create an ASP.NET Web application project by using Visual Studio .NET
• Configure and deploy an ASP.NET Web application
• Connect to SQL Server and other data sources
• Explain the Microsoft .NET Framework and ASP.NET
• Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML
• Add server controls to an ASP.NET Web Form
• Accomplish complex data access tasks from an ASP.NET Web application
• Access Extensible Markup Language (XML) data and read it into a DataSet
• Help protect an ASP.NET Web application by using a variety of technologies
• Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML
• Create a component in Visual Basic .NET or C#
• Create and populate ASP.NET Web Forms
• Add functionality to server controls that are on an ASP.NET Web Form
• Use the Trace and Debug objects that are provided with Visual Studio .NET
• Use validation controls to validate user input.
• Access data by using the built-in data access tools that are available in Visual Studio .NET
• Use Microsoft ADO.NET to access data in an ASP.NET Web application
• Call an XML Web service from an ASP.NET Web application and incorporate the returned data into a Web application
• Store application and session data by using a variety of methods
• Build a DataSet from an existing data source.
• Build a Web service that uses ADO.NET to query and update a data source
• Troubleshoot errors within an ADO.NET application