Layout Table~~~~3247~3247~~

5 Sessions - 15 Hours of Interactive Training~
ADO.NET is Microsoft’s latest technology for accessing data from various sources and is a central part of the .NET framework. The ADO.NET Part 1 training course from LearnKey begins with fundamentals like the ADO.NET Object Model and proceeds sequentially to more advanced topics. Expert instructors Andy Baron, Mary Chipman, and Ken Getz show you how to use ADO.NET to connect with data sources and access and modify data. At the conclusion of this training course, you will be familiar with connection objects, command objects and the other objects and classes that comprise ADO.NET.

Prerequisites: Previous programming experience recommended and familiarity with .NET, XML, database design/development, and C#.NET or VB.NET helpful.

Benefits
• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand web development knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner. .~~~3247~3248~~

Course Outline Table~~~~3247~3249~~

Session 1~Section A: Getting Started with ADO.NET
· Introduction
· Using Form Wizard
· Create Connection
· Select DataSet
· DataSet Relationship
· Set up Form
· Run Form

Section B: Data Form Wizard Code
· Examine Code
· Typed DataSet
· XML Schema Info
· Typed DataSet Code
· Form Wizard Objects

Section C: DataAdapter Configuration
· DataAdapter Properties
· Configuration Wizard
· SQL Select Statement
· Advanced Options

Section D: Evolution & Benefits
· ODBC & ADO
· OLE DB & ADO
· ADO.NET
· Scalability
· Interoperability

Section E: ADO.NET Object Model
· Connected Objects
· Disconnected Objects
· Data Provider Objects
· Connected Provider Objects
· Data-Caching Objects
· Typed DataSet
· DataView
· DataAdapter Object

Section F: Connection Strings
· Connection String
· Create Connection
· SQL OleDB
· Microsoft Jet Database
· Connection Code

Section G: Data Links
· Create UDL
· Add References
· DataLink Code

Section H: Jet Connections
· Unsecured Connection
· User-level Security
· Database Password
· Jet Connection Code~~~3247~3250~~

Session 2~Section A: SqlClient Provider
· Integrated Security
· SQL Authentication
· SQL Connection Code · Invalid Syntax

Section B: Connection Events
· StateChange Handler
· StateChange Code
· ODBC .NET Data Provider
· Reference ODBC DLL
· Create DSN
· Use DSN
Section C: Other Connections
· Excel Spreadsheet
· Excel Connection Code
· Oracle Database
· My SQL Database

Section D: Connection Pooling
· Closing Connections
· SQL Server Profiler
· Disable Pooling
· Perfmon Connections

Section E: Retrieving Schema Information
· GetOleDbSchema Table
· Retrieval Code
· Saving Connection Strings
· Save Options
· Web Connections
· Web Conf File
· App Settings
· App Variables

Section F: Command Classes
· Command Objects
· Create Command Object
· Constraints Class
· ExecuteNonQuery Method
· Execute DML Query
· Execute DDL Query
· Execute Method
· Execute Scaler Method

Section G: DataReader
· DataReader Efficiency
· GetOrdinal Method
· Type-specific Method
· Get Values Method
· Multiple Results Sets
· Schema Info
· Multiple DataReaders~~~3247~3251~~

Session 3~Section A: Calling Stored Procedures
· Basic SP Query
· Passing Parameters
· Setting Up Parameters
· Use OleDB Namespace
· Multiple Namespaces
· Using Interface Inheritance

Section B: Output Parameters & ASP Binding
· SP with Output
· Working with Output Parameters
· Data Binding in ASP.NET
· Bind to DataReader
· Fill DataGrid Controls

Section C: DataSets & DataTables
· Using DataSet
· DataTable Objects
· Retrieving Data
· Add a DataRow

Section D: Filling with a DataAdapter
· Retrieve Product List
· Create DataAdapter
· Create Query
· Fill Method
· Multiple Result Sets
· Using DataAdapter
· Tablemapping
Section E: Retrieving Schema Info
· View Schema Info
· Data Columns Schema
· AddwithKey

Section F: DataSets & XML
· Using XML
· GetXML Method
· Write XML Method
· ReadXML Method
· Display IE

Section G: Apply Constraints
· Defining Constraints
· Using Constraints
· Primary Key
· Clearing DataSet
· Fill Method Options
· Adding Constraints
· Primary Key Constraints

Section H: Merging DataSets
· Merge Method
· Add Primary Key
· Merge without PK
· Merge with PK~~~3247~3252~~

Session 4~Section A: Foreign Key Constraints
· FK Behavior
· Cascading Updates
· Filling DataSet
· Add FK Constraint

Section B: Other Constraints
· Column Properties
· Working with Nulls
· Lengths & Defaults
· Setting Property Constraints

Section C: Database Relations
· Relational Database
· Schema Info
· Enforce Options
· Save Database Diagram
· DataRelation in DataSets
· Relation Constraints
· Relation Method
· Enforce Constraints

Section D: Navigation Pathways
· Navigate by Relations
· Fill Methods
· Bind ListBox
· Select Category
· Select ParentRow
· Expressions & Relations
· Categories Expression
· Products Expression

Section E: Relations in Action
· Write XML Application
· Write Nested XML
· Wizard & DataRelations

Section F: Command Builder
· Updating Data
· Insert Command
· Update Command
· Delete Command
· Submit Changes
· Load DataSet
· CommandBuilder Methods
· Update Method

Section G: Creating Commands
· Custom Commands
· Setup DataAdapter
· Add Parameters
· Column Binding
· Define Command
· Updating with DataAdapter

Section H: Get Changes
· Create New DataSet
· DataRow Version
· RowState
· Accept & Reject Changes~~~3247~3253~~

Session 5~Section A: Using Stored Procedures
· Create SPs
· Assign Command
· Execute NonQuery
· Create Stored Procedure
· Perform Insert
· Create SQLCommand Object
· Update with DataAdapter
· Perform Delete

Section B: Complex Updating
· Delete Issues
· Performing Updates
· Concurrency Checking
· Update DataSet
· Merge & Accept
· Update Data Source

Section C: Creating Typed DataSets
· Using DataSets
· Strongly Typed DataSets
· Multiple DataAdapters
· Using DataSets
· Investigate Class
· Class View
· Use Typed DataSet
· Using Typed DataSets

Section D: Untyped DataSets
· Typed DataSet
· Find Values
· Modify DataSets
· Add Row to DataSets
· Working with Null Values
· Navigate Relations
· Using GetProductsRows

Section E: Typed DataSet Issues
· DataBinding
· DataBinding Properties
· Efficiencies
· Convert DataSets
· Annotations
· Benefits & Drawbacks~~~3247~3254~~

Ordering~~~~3247~3255~~

ADO.NET For Developers Part 1 Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|372138|PER USER%3A ONLINE Course|!78738|LIBRARY LICENCE%3A CD Course|372135|~3247~3256~ado.net~