|
|
|
ADO.Net Training Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Programming And Development"]
|
|
|
| Product: |
ADO.Net Training Course
10 CDs
|
|
|
| Details: |
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.
This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organization. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio®.
At Course Completion
After completing the course, students will be able to:
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 with data, and 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. .
Whether you have been using Microsoft's ADO or have been creating applications that access data sources, this introduction to ADO.NET development will introduce you to how the .NET framework can be used with various data sources. Besides discussing data-centric applications, connecting to data sources, performing database operations, and DataSets, this course discusses the advanced features of database related technologies and their .NET implementation. Finally, it introduces the use of XML with data sources. Following this course, you will be able to build connected applications that make the most efficient use of modern data sources in the Microsoft .NET framework.
Data-Centric Applications and ADO.NET
Connecting to Data Sources
Performing Connected Database Operations
Building DataSets
Reading and Writing XML with ADO.NET
Building DataSets from Existing Data Sources
Building and Consuming a Web Service That Uses ADO.NET
Learning / Exam module: Course Duration: 36 hours
Learning Segments:
INTRODUCTION
Course Prerequisites
Course Overview
MODULE 1: Overview
What is ADO.NET?
Data Architectures
Connected & Disconnected Environments
Data Stores
Demo - ADO.NET Namespaces
Demo - ADO.NET File Locations
Data Retrieval & Updates
ADO vs ADO.NET
Demo - Web Resources
Review
MODULE 2: Overview
Data Providers
Collection of Classes
Demo - Connection Class
Demo - Creating Connections
Demo - Web Resources
Demo - SQL Server Security
Demo - Dynamic Help
Demo - Connection Objects
Demo - Exceptions
Connection Pools
Demo - Pool Management Tools
Demo - Web Resources
Review
MODULE 3: Overview
Command Object
Demo - ExecuteScalar
Demo - Select Statement
Demo - ExecuteNonQuery
Demo - ExecuteReader
Demo - ExecueXmlReader
Demo - Adding Parameters
Demo - Visual Studio .NET
Demo - Stored Procedures
Demo - Database Transactions
Review
MODULE 4: Overview
Demo - DataReader Object
Demo - Schema Table
Demo - DataReader Object
Data Binding
Demo - Output Parameters
Demo - Multiple Statements
Review
MODULE 5: Overview
DataSet Overview
DataSet Object Model
Demo - DataSet
Data Adapter
Demo - DataAdapter
Demo - DataSet Schemas
Demo - Fill Schemas
Review
MODULE 6: Overview
Demo - Extending DataSets
Demo - Back & Front End Schema
Demo - Custom Expressions
Demo - Additional Constraints
Demo - Foreign Key Constraints
Demo - Setting Foreign Key Rules
Demo - Data Relations
Demo - Selecting Data
Demo - DataView
Strongly Typed DataSets
Demo - Typed DataSet Tools
Review
MODULE 7: Overview
Demo - Updating DataSets
Demo - Tracking Updates
Demo - Row State & Data Row Version
Updating Data Sources
Demo - Data Source Update Code: Opt |
