ADO.NET

Global Knowledge UK
Coventry, Dublin, London, Wakefield, Wokingham, United Kingdom

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

Course Description:

'' This three-day instructor led course provides delegates with the technical skills required to build data-centric, applications and Web Services with ADO .NET, SQL Server 2000 and the Microsoft .NET Framework.

Objectives
Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML.
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 & modify the data programmatically
Build a DataSet from an existing data source.
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.
Build a Web service that uses ADO.NET to query and update a data source.
Troubleshoot errors within an ADO.NET application

Pre-Requisites
Delegates are required to meet the following prerequisites:

Understanding of Database Basics: 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

Target Audience
This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for their organisation. It is designed for developers who have component and web-application development skills and have previously built solutions using Visual Studio.

Content
Overview of Data-centric Applications
ADO .NET Architecture
Connecting to SQL Server and Other Data Sources
Accessing Data in a Connected Environment
Modifying and Manipulating Data in a Connected Environment
Building and Manipulating Schemas for a Local Data Cache
Accessing Data in a Disconnected Environment
Modifying and Manipulating Data in a Disconnected Environment

Managing Transactions
Building a Distributed Application that Accesses Data
...''

Phone:+44 (0) 118 977 7766

School Address:

Global Knowledge UK
Mulberry Business Park,
Fishponds Rd, Wokingham, RG41 2GY

Jobs & Resumes: Coventry, Dublin, London, Wakefield, Wokingham
Houses & Roommates: Coventry, Dublin, London, Wakefield, Wokingham

Windows 2000 Clustering
Designing & Populating a Data Warehouse With Microsoft SQL Server 2000
C# Programming
E-Business Solutions Using Microsoft BizTalk Server 2004
Microsoft Windows XP Operating System
MS Windows Server 2003 Active Directory & Network Infrastructure
Microsoft Windows XP Professional
ASP.NET Web Application Using Visual Studio .NET
Programming the Microsoft .NET Framework with C#
Visual Basic.Net
XML Web Services Using Microsoft ASP.Net
MS Internet Information Services (IIS) 6.0
Microsoft Identity Integration Server (MIIS) 2003
Microsoft SQL Server 2005
Security for MS SQL Server 2005
Network Security
Internet Security and Acceleration (ISA) Server 2004
Networking for Call Pilot
VOIP Technologies

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.