MS2389 Programming with Microsoft ADO.NET

Learning IT
Stirling,Glasgow,Inverness, 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 Microsoft ADO.NET, Microsoft SQL Server™ 2000, and the Microsoft .NET Framework.

Course Duration:
3 Days instructor led

Course Prerequisites:
Before attending this course, students must have:


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
Microsoft Certified Professional Exams:
This course will help the student prepare for the following Microsoft Certified Professional exams:

Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Exam 70-306: Developing and Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Exam 70-316: Developing and Implementing Windows based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Course Outline:

Data-Centric Applications and ADO.NET
Design of Data-Centric Applications
ADO.NET Architecture
ADO.NET and XML
After completing this module, students will be able to:
Lab 1.1: Data-Centric Applications and ADO.NET

Connecting to Data Sources
Choosing a .NET Data Provider
Defining a Connection
Managing a Connection
Handling Coonection Exceptions
Connection Pooling
Lab 2.1: Connecting to Data Sources


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
Lab 3.1: Performing Connected Database Operations

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
Lab 4.1: Building, Binding, Opening, and Saving DataSets
Lab 4.2: Manipulating DataSets

Reading and Writing XML with ADO.NET
Creating XSD Schemas
Loading Schemas and Data into DataSets
Writing XML from a DataSet
Lab 5.1: Working with XML Data in ADO.NET

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
Lab 6.1: Retrieving Data into a Disconnected Application
Lab 6.2: Retrieving and Updating Customers and Orders Data

Building and Consuming a Web Service That Uses ADO.NET
Building and Consuming a Web Service That Returns Data
Lab 7.1: Troubleshooting an ADO.NET Application

...''

Phone:01786 478 478 Fax: 01786 478 222

School Address:

Head Office
Drummond House
Wellgreen
Stirling
FK8 2DZ

Tel: 01786 478 478
Fax: 01786 478 222


Glasgow Office
The Ca’d’Oro
45 Gordon Street
Glasgow
G1 3PE

Tel:0141 248 5000
Fax:0141 221 5003


Inverness Office
The Green House
Beechwood Business Park
Inverness
IV2 3BL

Tel: 01463 717716
Fax: 01463 667344

Jobs & Resumes: Stirling, Glasgow, Inverness
Houses & Roommates: Stirling, Glasgow, Inverness

MS2152 IMPLEMENTING MICROSOFT WINDOWS 2000 PROFESSIONAL AND SERVER
MS2153 IMPLEMENTING A MICROSOFT WINDOWS 2000 NETWORK INFRASTRUCTURE
MS2154 IMPLEMENTING AND ADMINISTERING MICROSOFT WINDOWS 2000 DIRECTORY SERVICES
MS2126 Managing a Microsoft Windows 2000 Network Environment
MS1561 DESIGNING A MICROSOFT WINDOWS 2000 DIRECTORY SERVICES INFRASTRUCTURE
MS2087 Implementing Microsoft Windows 2000 Clustering
MS2310 Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET
MS2710 Analyzing Requirements and Defining Microsoft .NET Solution Architectures
MS2559 Introduction to Microsoft Visual Basic .NET Programming
MS2373 Programming with Microsoft Visual Basic .NET
Developing .NET Windows Applications (Microsoft Visual Basic .NET)
MS2557 Building COM+ Applications Using Microsoft.NET Enterprise Services
MS2524 Developing XML Web Services Using Microsoft ASP.NET
MS2379 Developing and Deploying Microsoft BizTalk Server 2000 Solutions
Planning, Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000
MS2207 Updating Systems Administrator and Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003

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: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.