Course 2389: Programming with Microsoft ADO.NET

Product type

Course 2389: Programming with Microsoft ADO.NET

Microsoft Learning
Logo Microsoft Learning

Need more information? Get more details on the site of the provider.

Description

Introduction This course teaches developers to build data-centric applications and Web services with Microsoft® ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework. This course contains virtual labs. A note about virtual System Requirements: If you access the Internet from behind a proxy server, you may not be able to take a virtual lab. This affects AOL and Gateway.net users who use a modified browser and those who access virtual lab technology from behind a corporate firewall. Modified browser users should use either Internet Explorer or Netscape Navigator (both 4.0 or higher). Users behind a corporate proxy server should access virtual lab technology through a commercial …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Introduction This course teaches developers to build data-centric applications and Web services with Microsoft® ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework. This course contains virtual labs. A note about virtual System Requirements: If you access the Internet from behind a proxy server, you may not be able to take a virtual lab. This affects AOL and Gateway.net users who use a modified browser and those who access virtual lab technology from behind a corporate firewall. Modified browser users should use either Internet Explorer or Netscape Navigator (both 4.0 or higher). Users behind a corporate proxy server should access virtual lab technology through a commercial ISP account. NOTE: Connection to the real PCs and servers is done via the VNS protocol. As a result, there is a requirement for a connection through ports 5800-5821 and 5900-5921. Objectives At the end of the course, students will be able to:
  • Use Microsoft ADO.NET to build and enhance data-centric applications and Web services.
Modules & Lessons Course Introduction Course Introduction Data-Centric Applications and ADO.NET Introduction Design of Data-Centric Applications ADO.NET Architecture ADO.NET and XML Lab Summary Connecting to Data Sources Introduction Choose a .NET Data Provider Define a Connection Manage a Connection Handle Connection Exceptions Manage Connection Pooling Lab Summary Performing Connected Database Operations Introduction Build Command Objects Execute Command Objects That Return a Single Value Explore Commands That Return Rows Explore Commands That Do Not Return Rows Investigate Transactions Lab Summary Building DataSets Introduction Build DataSets and DataTables Bind and Save a DataSet Define Data Relationships Modify Data in a DataTable Sort and Filter Data Lab Summary Reading and Writing XML with ADO.NET Introduction Create XSD Schemas Load Schemas and Data into DataSets Write XML from a DataSet Lab Summary Building DataSets from Existing Data Sources Introduction Configure a DataAdapter to Retrieve Information Populate a DataSet Using a DataAdapter Configure a DataAdapter to Update the Underlying Data Source Persist Changes to a Data Source Handle Conflicts Lab Summary Building and Consuming a Web Service That Returns Data Introduction Build and Consume a Web Service That Returns Data Lab Summary Course Summary Course Summary System Requirements To view this course, you need:
  • Browser Microsoft Internet Explorer 7 (or higher)
  • Browser Mozilla Firefox 2 (or higher)
  • Browser Apple Safari 2 (or higher)
  • Operating System Microsoft Windows 2000, XP, Vista, or Windows 7
  • Operating System Apple Mac OS X 10.4 (or higher)
  • Processor Pentium III 1 GHz (or better)
  • Processor Macintosh Intel-based or PowerPC G4 (or better)
  • RAM 512 MB (1 GB or more recommended)
  • Internet connection 256K (broadband recommended)
  • Adobe Flash Player 8 (current version recommended)
  • Adobe Reader 7 (or higher)
  • Other requirements may apply to supplemental offline activities. Omitting these optional activities does not affect course completion.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
  • Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:
  • Microsoft Internet Explorer 6.0 or higher
  • Window-Eyes from GW Micro
  • JAWS from Freedom Scientific
  • MSAA enabled
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.