Programming with Microsoft ADO.NET

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course will teach developers to build data-centric, applications and Web services with ADO.NET, SQL Server 2000 and the Microsoft.NET Framework.

Prerequisites
Delegates should understand database basics including table, row, column, primary keys, foreign keys, constraints, views); concepts including SELECT, INS, UPD, DEL from tables; exposure to XML documents, stylesheets, and schema; Visual Basic.NET, Visual Basic for applications, or previous version of Visual Basic; describe distributed application architecture; building UI �Web applications or Windows applications.

Delegates will learn how to
Connect to SQL Server and other data sources
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
Build a DataSet schema, populate it with data, and modify the data programmatically
Troubleshoot errors within an ADO.NET application
Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets and interacting with XML DataDocuments
Build a DataSet from an existing data source
Build a Web Service that uses ADO.NET
Outline
DATA-CENTRIC APPLICATIONS AND ADO.NET:

Design of Data-Centric Applications; ADO.NET architecture, ADO.NET and XML

CONNECTING TO DATA SOURCES:

Choosing a .NET Data Provider; 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

Leads to examinations
70�05 �Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio.NET
70�06 �Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
70�15 �Developing and Implementing Web Applications with Microsoft Visual C#�.NET and Microsoft Visual Studio .NET
70�16 �Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Programming with Microsoft ADO.NET training resources.

Introduction to Programming
Introduction to XML and the Microsoft .NET Platform
Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect
Programming the Microsoft .NET Framework
Programming the Microsoft .NET Framework with Visual Basic.NET
Programming with C#
Programming with Managed Extensions for Microsoft Visual C++ .NET
Programming with Microsoft Visual Basic .NET
Microsoft .NET Framework 2.0 Foundation
Advanced Distributed Application Development with Microsoft Visual Studio 2005
Advanced Foundations of Microsoft .NET 2.0 Development

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.