Career Vision Training Computer Training Courses
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLES * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade (70-649)
MCSE 2003 Corp Training Suite
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Cisco CCNA
Cisco CCNP
CISSP 2007
Certified Ethical Hacker (CEH)

View Complete List...
*

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
Acrobat 9 Essentials
Project 2007
PRINCE2 Foundation

View Complete List...
*

GRAPHICS & LAYOUT
Photoshop CS4 Essentials
Creative Suite 3: Design Bundle
Total Training Online Courses
Illustrator CS3 Essentials
CorelDRAW Graphics Suite X3

View Complete List...
*

MULTIMEDIA & ANIMATION
After Effects CS3 Essentials
CS3: Production Bundle
Encore DVD Pro 2.0
Final Cut Studio
Premiere Pro CS3 Essentials

View Complete List...
*

CAD & 3D
AutoCAD 2009
AutoCAD LT 2009
Civil 3D 2009
Inventor 2009
Revit Architecture 2009 Essentials

View Complete List...
*

SOFT SKILLS TRAINING
Better Business Writing
Customer Satisfaction
Excellence in Supervision
How to Get Things Done
Team Leadership

View Complete List...
*

WEB DESIGN & INTERNET
Dreamweaver CS4 Essentials
Expression Studio 2 Bundle
Flash CS4 Pro Essentials
Creative Suite 3: Web Bundle
E-Commerce Introduction

View Complete List...
*
*
Computer Training Courses
*
CareerVision is one of Europe's leading suppliers of self-paced computer training courses.
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

MOC 2389 - Programming with Microsoft ADO.NET Training

By CareerAcademy
MOC 2389 - Programming with Microsoft ADO.NET Training
Single User CD Course £282.00 + VAT
Buy Now
Single User Online Course £225.00 + VAT
Buy Now
Multi User CD Course £564.00 + VAT
Buy Now
 

More on Single User, Multi User & Network Licences



PACKAGE INCLUDES

  • 10 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Certification Exam Simulator
  • Step-by-step hands-on-labs
  • Focused on practical solutions to real-world development problems

    COURSE INTRODUCTION

    Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft.NET Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to fully prepare for and pass your certification exams.

    ADO.NET is an evolutionary improvement to Microsoft ActiveX Data Objects (ADO) that provides platform interoperability and scalable data access. Using Extensible Markup Language (XML), ADO.NET can ensure the efficient transfer of data to any application on any platform. With Visual Studio .NET, developers program against objects, not tables and columns. ADO.NET features strongly typed programming, enabling developers to quickly write reliable data access code. Learn how to manipulate relational data using Microsoft's new ADO.NET library as you learn valuable techniques for building both Web and Windows applications!


    View CareerAcademy Demo Videos

    • COURSE OUTLINE

    Level 1

    Course Prerequisites
    1.1 Course Outline
    Introduction to ADO.NET
    1.1 What is ADO.NET
    1.2 Data Architectures
    1.3 Connected & Disconnected
    Environments
    1.4 Data Stores
    1.5 Demo - ADO.NET Namespaces
    1.6 Demo - ADO.NET File Locations
    1.7 Data Retrieval & Updates
    1.8 ADO vs ADO.NET
    1.9 Demo -Web Resources
    1.10 Review
    Lab - Integrated Development Features

    Level 2

    Data Source Connections
    1.1 Data Providers
    1.2 Collection of Classes
    1.3 Demo - Connection Class
    1.4 Demo - Creating Connections
    1.5 Demo - SQL Server Security
    1.6 Demo - Dynamic Help
    1.7 Demo - Connection Objects
    1.8 Demo - Exceptions
    1.9 Connection Pools
    1.10 Demo - Pool Management Tools
    1.11 Demo -Web Resources 2
    1.12 Review
    Lab - Connect to a Data Source

    Level 3

    Executing Commands
    1.1 Command Object
    1.2 Demo - ExecuteScalar
    1.3 Demo - Select Statement
    1.4 Demo - Execute Non Query
    1.5 Demo - Execute Reader
    1.6 Demo - Execute XML Reader
    1.7 Demo - Adding Parameters
    1.8 Demo - Visual Studio .NET
    1.9 Demo - Stored Procedures
    1.10 Demo - Database Transactions
    1.11 Review
    Lab Transaction Statements

    Level 4

    Retrieving Data
    1.1 Demo - Data Reader Object 1
    1.2 Demo - Schema Table
    1.3 Demo - Data Reader Object 2
    1.4 Data Binding
    1.5 Demo - Output Parameters
    1.6 Demo - Multiple Statements
    1.7 Review
    Lab - Command Objects
    Building DataSets
    2.1 Dataset Overview
    2.2 DataSet Object Model
    2.3 Demo - Dataset
    2.4 Data Adapter
    2.5 Demo - Data Adapter
    2.6 Demo - Dataset Schemas
    2.7 Demo - Fill Schemas
    2.8 Review
    Lab - Fill Schemas

    Level 5

    Extending DataSets
    1.1 Demo - Extending DataSets
    1.2 Demo - Back & Front End Schemas
    1.3 Demo - Custom Expressions
    1.4 Demo - Additional Constraints
    1.5 Demo - Foreign Key Constraints
    1.6 Demo - Setting Foreign Key Rules
    1.7 Demo - Data Relations
    1.8 Demo - Selecting Data
    1.9 Demo - Data View
    1.10 Strongly Typed DataSets
    1.11 Demo -Typed DataSets
    1.12 Review
    1.13 Create a DataSet

    Level 6

    Updating DataSets
    1.1 Demo - Updating DataSets
    1.2 Demo - Tracking Updates
    1.3 Demo - Row State & Data
    1.4 Updating Data Sources
    1.5 Demo - Data Source Update Code: Option 1
    1.6 Demo - Data Source Update Code: Option 2
    1.7 Demo - Updating Data Sources
    1.8 Demo -Updating Data Errors
    1.9 Demo - Detecting Updating Conflicts
    1.10 Handling Updating Conflicts
    1.11 Minimizing Conflicts
    1.12 Demo - Minimizing Conflicts
    1.13 Review

    Level 7

    XML Techniques
    1.1 Demo -Writing XML Data
    1.2 Demo - Formatting XML
    1.3 Demo - Reading XML Data
    1.4 Demo -Writing XML Schema
    1.5 Demo - reading XML Schema
    1.6 XML Data Document
    1.7 Demo - XML Data Document
    1.8 Demo - Serialization
    1.9 Review

    Level 8

    Application Development
    1.1 Demo - Code Generation: Server Explorer
    1.2 Demo - Code Generation: Toolbox
    1.3 Demo -Writing Code
    1.4 Demo - Info Message Event
    1.5 Demo - Data Binding
    1.6 Demo - DataGrid 1000
    1.7 Demo - Updating Data
    1.8 Resources
    1.9 Review

    Level 9

    ADO.NET in Web Development
    1.1 Stateless Programming Overview
    1.2 Demo - Integrated Security
    1.3 Demo - Data Binding
    1.4 Demo - Data Grid
    1.5 Demo - Data View
    1.6 Demo - Output Caching 1000
    1.7 Demo - Caching API
    1.8 Demo - Resources
    1.9 Review

    Level 10

    ADO.NET in XML Web Services
    1.1 Web Service Architecture
    1.2 Demo - XML Web Service
    1.3 Demo - Returning DataSets
    1.4 Demo - Passing Parameters
    1.5 Demo -Web Service Data Return
    1.6 Demo - Consuming Web Services
    1.7 Demo - Resources
    1.8 Review
    1.9 Final Comments
     
    Print Image Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CONTACT US   SITEMAP  
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk
    red arrow Website design by Aimpro UK red arrow Terms