Sandline Training
CD-ROM Video Based Courses
   
 

ADO.NET Training

This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL ServerT 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.

 

  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.


Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software - saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format - allowing you to get the most out of your time.

Our CD-rom courses incorporate audio, video, and text training and then the total experience is reinforced with exercises and practice tests to ensure that you have really grasped the material.

 
 


This Course includes:
Key:
Online Course = All items marked with are included.
CD's Only = Everything! - If its marked with then its included.
For Pricing - Click Here
Live Video,
instructor-led
 
CD
Courses =
5 Interactive
CD-ROM's
Online
Courses =
Online Streaming Video
(Broadband min 512k)
Featuring live instructor-led classroom-like sessions in digital video format. Multimedia-rich delivery brings experienced subject matter experts to your desktop or laptop.
Email Support  
1 Year's Technical Email Support
Free Upgrades  
12 months of Free Upgrades.
Compatibility with:  

Compatibility with:
NT | 95 | 98 | 2000 | ME | XP || |Server 2003 | Vista
 
   
 
 
 

ADO.NET (Course covers)

 
 
INTRODUCTION
Course Prerequisites
Course Overview
MODULE 1: Overview
What is ADO.NET?
Data Architectures
Connected & Disconnected Environments
Data Stores
ADO.NET Namespaces
ADO.NET File Locations
Data Retrieval & Updates
ADO vs ADO.NET
Web Resources
Review
MODULE 2: Overview
Data Providers
Collection of Classes
Connection Class
Creating Connections
Web Resources
SQL Server Security
Dynamic Help
Connection Objects
Exceptions
Connection Pools
Pool Management Tools
Web Resources
Review
MODULE 3: Overview
Command Object
ExecuteScalar
Select Statement
ExecuteNonQuery
ExecuteReader
ExecueXmlReader
Adding Parameters
Visual Studio .NET
Stored Procedures
Database Transactions
Review
MODULE 4: Overview
DataReader Object
Schema Table
DataReader Object
Data Binding
Output Parameters
Multiple Statements
Review
MODULE 5: Overview
DataSet Overview
DataSet Object Model
DataSet
Data Adapter
DataAdapter
DataSet Schemas
Fill Schemas
Review
MODULE 6: Overview
Extending DataSets
Back & Front End Schema
Custom Expressions
Additional Constraints
Foreign Key Constraints
 
Setting Foreign Key Rules
Data Relations
Selecting Data
DataView
Strongly Typed DataSets
Typed DataSet Tools
Review
MODULE 7: Overview
Updating DataSets
Tracking Updates
Row State & Data Row Version
Updating Data Sources
Data Source Update Code: Option 1
Data Source Update Code: Option 2
Updating Data Sources
Updating Errors
Detecting Updating Conflicts
Handling Updating Conflicts
Minimizing Conflicts
Minimizing Conflicts
Review
MODULE 8: Overview
Writing XML Data
Formatting XML
Reading XML Data
Writing XML Schema
Reading XML Schema
XML Data Document
XML Data Document
Serialization
Review
MODULE 9: Overview
Code Generation: Server Explorer
Code Generation: Toolbox
Writing Code
InfoMessage Event
Data Binding
DataGrid
Updating Data
Resources
Review
MODULE 10: Overview
Stateless Programming Overview
Integrated Security
Data Binding
DataGrid
DataView
Output Caching
Caching
Resources
Review
MODULE 11: Overview
Web Service Architecture
XML Web Service
Returning DataSets
Passing Parameters
Web Service Data Return
Consuming Web Services
Resources
Review
Final Comments
 
     



About Our Instructor


Steven Borg,

MCSD, MCT, Author
Steven's goal is to develop innovative solutions to difficult and interesting problems, especially those that improve communication between people or reduce transaction costs between businesses. Steven has over 14 years of experience creating technical solutions to a variety of civilian and military problems, as well as 9 years active involvement in adult learning. Steven has actively worked with Visual

Studio .NET and the .NET Framework for over 3 years. Steven has used his .NET experience to write two technical books for Wiley press, one of which was selected to be translated into Simplified Chinese. His Previous experience includes seven years of Microsoft Office development using Visual Basic for Applications. Six years of experience designing object-oriented Visual Basic applications using various CASE tools in a Rapid Application Design environment. Steven has very extensive knowledge of the .NET Framework and .NET development, including VB.NET, C# and ASP.NET, including all XML aspects of .NET. Steven has involved knowledge of object oriented development using the Component Object Model (COM/ActiveX), and object oriented design using the Unified Modeling Language (UML). He also has advanced programming skills in Visual Basic .NET, C#, XML, XSL, XSLT, Visual Basic, and Visual Basic for Applications and is knowledgeable in Java and SQL.



 

Full motion video
Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Instructor-Led Training
combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media CD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.

 


Hands-on Lab Simulation
Hands-on Lab Simulation is a
crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..
 

Free Upgrades
A unique benefit of the Sandline Learning System? is that
it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive CD-ROM's for up to 1 year from date of original purchase? absolutely free!

 
 


Free educational support from our certified staff  


 
 
 

ADO .NET Training Course

   
 
Online Course:
CD Study Kit:
List Price: £695  
You Save: £227  
Availability: In Stock  
Rating:  
 
            What's included in each option?
 
 

 
1yr Unlimited Online Access to 143 Courses
Save 95%