2389 - Prerequisites

The course assumes that students have the following skills:

• Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views

• Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands

• Exposure to XML documents, style sheets, and schemas

• Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic

• Experience building user interfaces, including Web applications or Microsoft Windows® applications

2389 - Course Outline

Module 1: Data-Centric Applications and ADO.NET

Take a closer look: Download Sample Module 1 (Portable Document Format, 1.12 MB).

The following topics are covered in this module:

• Design of Data-Centric Applications

• ADO.NET Architecture

• ADO.NET and XML

After completing this module, students will be able to:

• Give examples of storage options.

• Diagram the architecture of data-centric applications.

• Choose a connected, disconnected, or mixed environment based on application requirements.

• Use the System.Data namespaces in applications.

• Diagram the ADO.NET object model.

• Analyze typical business scenarios.

• Explain how to use ADO.NET with XML.

Lab 1.1: Data-Centric Applications and ADO.NET

Module 2: Connecting to Data Sources

Take a closer look: Download Sample Module 2 (Portable Document Format, 1.02 MB).

The following topics are covered in this module:

• Choosing a .NET Data Provider

• Defining a Connection

• Managing a Connection

• Handling Connection Exceptions

• Connection Pooling

After completing this module, students will be able to:

• Choose a .NET data provider.

• Connect to SQL Server.

• Connect to OLE DB data sources.

• Manage a connection.

• Handle common connection exceptions.

• Implement and control connection pooling.

Lab 2.1: Connecting to Data Sources

Module 3: Performing Connected Database Operations

The following topics are covered in this module:

• 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

After completing this module, students will be able to:

• Build a command object.

• Execute a command that returns a single value.

• Execute a command that returns a set of rows, and process the result.

• Execute a command that defines database structure and permissions by using the data definition language (DDL) and data control language (DCL).

• Execute a command that modifies data.

• Use transactions.

Lab 3.1: Performing Connected Database Operations

Module 4: Building DataSets

The following topics are covered in this module:

• 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

After completing this module, students will be able to:

• Describe the disconnected environment.

• Build a DataSet and a DataTable.

• Bind a DataSet to a DataGrid.

• Open and save a DataSet.

• Define a data relationship.

• Modify data in a DataTable.

• Find and select rows in a DataTable.

• Sort and filter a DataTable by using a DataView.

Lab 4.1: Building, Binding, Opening, and Saving DataSets
Lab 4.2: Manipulating DataSets

Module 5: Reading and Writing XML with ADO.NET

The following topics are covered in this module:

• Creating XSD Schemas

• Loading Schemas and Data into DataSets

• Writing XML from a DataSet

After completing this module, students will be able to:

• Generate an XSD schema from a DataSet by using graphical tools.

• Save a DataSet structure to an XSD schema file.

• Create and populate a DataSet from an XSD schema and XML data.

• Save DataSet data as XML.

• Write and load changes by using a DiffGram.

Lab 5.1: Working with XML Data in ADO.NET

Module 6: Building DataSets from Existing Data Sources

The following topics are covered in this module:

• 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

After completing this module, students will be able to:

• Configure a DataAdapter to retrieve information.

• Populate a DataSet by using a DataAdapter.

• Configure a DataAdapter to modify information.

• Persist data changes to a data source.

• Manage data conflicts.

Lab 6.1: Retrieving Data into a Disconnected Application
Lab 6.2: Retrieving and Updating Customers and Orders Data

Module 7: Building and Consuming a Web Service That Uses ADO.NET

The following topic is covered in this module:

• Building and Consuming a Web Service That Returns Data

After completing this module, students will be able to:

• Build a Web service.

• Consume a Web service in a client application.

• Troubleshoot errors in an ADO.NET application.

Lab 7.1: Troubleshooting an ADO.NET Application

2524 - Prerequisites

Before attending this course, students must have:

• Familiarity with C# or Microsoft Visual Basic® .NET.

• Programming in C++, Java, or Microsoft Visual Basic.

• An understanding of how to read and write XML documents.

• Experimented with simple C# applications.

• Developed distributed applications by using Visual Basic, Java, or C++.

Module 1: The Need for XML Web Services

Take a closer look: Download Sample Module 1 (Portable Document Format, 707 KB).

This module provides students with an understanding of the problem space that Web services address. The module compares various approaches to implementing distributed applications. Because the Web services in this course are implemented by using Microsoft ASP.NET and the Microsoft .NET Framework, alternate options for implementing distributed applications by using the .NET Framework are discussed to better define what kinds of solutions Web services are appropriate for.

After completing this module, you will be able to explain how Web services emerged as a solution to the problems with traditional approaches to designing distributed applications. This includes:

• Describing the evolution of distributed applications.

• Identifying the problems with traditional distributed application architectures and technologies.

• Describing Web services and briefly explaining how they address the design problems in traditional distributed applications.

• Listing the alternate options for distributed application development.

• Identifying the kinds of scenarios where Web services are an appropriate solution.

Module 2: XML Web Service Architectures

Take a closer look: Download Sample Module 2 (Portable Document Format, 676 KB).

This module broadly describes the service-oriented architecture, which is a conceptual architecture. Then, the module explains the roles and how Web service architectures are a type of service-oriented architecture.

After completing this module, you will be able to describe the architecture of a Web services-based solution. This includes:

• Identifying how Web service architectures are a type of service-oriented architecture.

• Describing the elements of a Web service architecture and explaining their roles.

• Describing the Web service programming model.

Module 3: The Underlying Technologies of XML Web Services

After completing this module, you will be able to describe the underlying technologies of Web services and explain how to use the .NET Framework to implement Web services by using these technologies.

This includes:

• Describing the structures of an HTTP request and response.

• Issuing HTTP POST and GET requests and processing the responses by using the .NET Framework.

• Describing data types by using the XML Schema Definition language (XSD).

• Explaining how to control the way a .NET Framework object is serialized to XML.

• Describing the structures of a Simple Object Access Protocol (SOAP) request and response.

• Issuing a SOAP request and processing the response by using the .NET Framework.

Module 4: Consuming XML Web Services

After completing this module, you will be able to implement a Web service consumer by using Visual Studio .NET.

This includes:

• Explaining the structure of a Web Service Description Language (WSDL) document.

• Explaining the Web services discovery process.

• Locating service contracts by using Disco.exe.

• Generating Web service proxies by using Wsdl.exe.

• Implementing a Web service consumer by using Visual Studio .NET.

• Invoking a Web service synchronously and asynchronously by using a Web service proxy.

Module 5: Implementing a Simple XML Web Service

This module provides students with the skills that are required to implement and debug a Web service by using Visual Studio .NET.

This includes:

• Creating a Web service project.

• Implementing Web service methods, exposing them, and controlling their behavior.

• Managing state in an ASP.NET-based Web service.

• Debugging Web services.

Module 6: Publishing and Deploying XML Web Services

This module teaches students how to deploy and publish Web services and locate Web services by using the Microsoft Universal Description, Discovery, and Integration (UDDI) software development kit (SDK). A local development UDDI registry is used in the demonstrations for this module, but the mechanics of publishing and finding Web services is no different on the public UDDI registry nodes.

After completing this module, you will be able to publish and deploy a Web service. This includes:

• Explaining the role of UDDI in Web services.

• Publishing a Web service in a UDDI registry by using the UDDI SDK.

• Searching a UDDI registry to locate Web services by using the UDDI SDK.

• Explaining the various options for publishing a Web service on an intranet.

• Explaining some of the options for modifying the default configuration of a Web service.

Module 7: Securing XML Web Services

This module teaches students how to use the security services of the Microsoft Windows® operating system, Microsoft Internet Information Services (IIS), and the.NET Framework and common language runtime to secure Web services.

After completing this module, you will be able to secure a Web service. This includes:

• Identifying the differences between authentication and authorization.

• Explaining how to use the security mechanisms that Microsoft Internet Information Services (IIS) and Windows provide for authentication.

• Using SOAP headers for authentication in a Web service.

• Using role-based security and code access security for authorization in a Web service.

• Encrypting the communication between a Web service consumer and a Web service.

Module 8: Designing XML Web Services

This module teaches students which design issues to consider when designing real-world Web services. The issues discussed are related to data type constraints, performance, reliability, versioning, deployment in Internet Service Provider (ISP) and Application Service Provider (ASP) scenarios, and aggregating Web services. The module also discusses HTML screen scraping as a pseudo Web service.

After completing this module, you will be able to evaluate the trade-offs and issues that are involved in designing a real-world Web service. This includes:

• Identifying the restrictions that are imposed on data types by the various Web services protocols.

• Explaining how the use of Application and Session state can affect the performance and scaling of Web services.

• Explaining how to use output and data caching to improve Web service performance.

• Implementing caching in a Web service.

• Explaining how asynchronous Web service methods can improve performance.

• Explaining the need for instrumenting Web services.

• Identifying the components of a Web service that can be versioned.

• Explaining how to implement a virtual Web service by using screen scraping.

• Implementing a Web service that uses multiple Web services.

• Identifying the trade-offs in the techniques that are used for exposing aggregated Web services.

Module 9: Global XML Web Services Architecture

This module teaches students how to use the security services of the Microsoft Windows operating system, IIS, and the .NET Framework and common language runtime to secure Web services.

After completing this module, you will be able to:

• Describe limitations inherent to the specifications with which today’s Web services are built.

• Describe the design principles and specifications of Global XML Web services Architecture (GXA).

• Describe Web service application scenarios made possible by Web Services Routing Protocol (WS-Routing) and Web Services Referral Protocol (WS-Referral).

• Explain how to use Web Services Security Language (WS-Security) and Web Services License Language (WS-License) to perform authentication and authorization for Web services.

• Design Web services that anticipate and can leverage the features that GXA will offer when released.