MS2310/2389 Web Application Development & Data Access with Visual Basic .NET & C# FAST TRACK

This course is 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

Given the nature of "Fastrack" courses, delegates will need to be prepared to spend study time in the evenings to fully cover the syllabus.

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

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 as described on Microsoft's .Net Web site.

Completed MS2124 or have equivalent knowledge

INTRODUCTION TO ASP.NET

ADDING CODE TO A MICROSOFT ASP.NET WEB FORM

TRACING IN MICROSOFT ASP.NET WEB APPLICATIONS

VALIDATING USER INPUT

CREATING USER CONTROLS

ACCESSING RELATIONAL DATA WITH VISUAL STUDIO.NET

READING, WRITING AND CONSUMING XML WEB SERVICES

ACCESSING RELATIONAL DATA WITH ADO.NET

ACCESSING DATA WITH MICROSOFT ADO.NET

CALLING STORED PROCEDURES WITH ADO.NET

CONSUMING AND CREATING XML WEB SERVICES

MANAGING STATE

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

HELPING TO PROTECT A MICROSOFT ASP.NET WEB APPLICATION

CONNECTING TO DATA SOURCES

PERFORMING CONNECTED DATABASE OPERATIONS

BUILDING DATASETS

READING AND WRITING XML WITH ADO.NET

BUILDING DATASETS FROM EXISTING DATA SOURCES

BUILDING AND CONSUMING A WEB SERVICE THAT USES ADO.NET

Helps prepare delegates for the following Microsoft examinations:

70–305 - Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio.NET
70–306 - Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
70–315 - Developing and Implementing Web Applications with Microsoft Visual C#™ .NET and Microsoft Visual Studio .NET
70–316 - Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET