Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* 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 * ARTICLE * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade
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
PRINCE2 Foundation
PRINCE2 Practioner Complete
IT Infrastructure Library ITIL

View Complete List...
*

GRAPHICS & LAYOUT
Creative Suite 3: Design Bundle
PhotoShop CS3 Essentials
Illustrator CS3 Essentials
InDesign CS3 Essentials
Photoshop Elements 5

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 2008
AutoCAD Architecture 2008
AutoCAD LT 2008
3ds max 9 and VIZ
Civil 3D 2007

View Complete List...
*

SOFT SKILLS TRAINING
Assertiveness
Communication Series
Customer Service Series
Effective Presentation Skills
Telephone Courtesy and Customer Service

View Complete List...
*

WEB DESIGN & INTERNET
Creative Suite 3: Web Bundle
Dreamweaver CS3 Bundle
Flash CS3 Bundle
Expression Studio Bundle
E-Commerce Introduction

View Complete List...
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

MOC 2541: Core Data Access with Visual Studio 2005
By CareerAcademy
MOC 2541 - Core Data Access with Visual Studio 2005 Training
MOC 2541: Core Data Access with Visual Studio 2005
Single User CD Course £248.00 + VAT
Buy Now
Single User Online Course £198.00 + VAT
Buy Now
Multi User CD Course £496.00 + VAT
Buy Now
 

More on Single User, Multi User & Network Licences



PACKAGE INCLUDES

  • 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • 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-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

    This instructor-led course provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET. The course also describes how to create, read, and write XML data.

    		•

    COURSE OUTLINE

    Module 1 - Connecting to Databases and Reading Data

    ADO.Net
    Connect and Read Data
    Creating a Connection
    Demo - Creating and Using Connections/Commands
    Connection Events
    Connection Exceptions
    Connection Pooling
    Pool Settings
    Demo - Connection Pooling
    Module 1 Review

    Module 2 - Querying and Updating Databases

    ADO.Net Commands
    Command Properties
    Command Methods
    Demo - Create Commands
    Bind Data to Control
    Demo - Binding Commands to Controls
    Pass Parameters to Command
    Parameter Properties
    Demo - Execute a Command with Parameters
    Server Explorer
    Demo - Using Server Explorer
    Module 2 Review

    Module 3 - Transactional Operations

    What is a Transaction?
    Transaction Support
    Transaction Characteristics
    Managing Local Transactions
    Local Transaction Example
    Demo - Local Transaction
    Managing Distributed Transactions
    Create Transaction
    Demo - Use Distributed Transaction
    Isolation
    Isolation Levels
    Isolation Matrix
    Demo - Show Effects of Isolation Levels
    Lab Demonstration 1
    Module 3 Review

    Module 4 - Disconnected Operations

    ADO.NET Disconnected Model
    Create DataSet Model
    Demo - Create a Dataset
    Special Columns
    Constraints and Relations
    Demo - Add Special (Nondata) Columns
    DataSet Relations
    Demo - Create Dataset Relation
    Demo - Use Relation to Access Child Records
    Data Adapter
    Loading and Saving Data in a DataSet
    Data Adapter Properties
    Demo - Create and Use Data Adapter
    Data Views
    Data View Properties
    Demo - Create and Use Data view
    Module 4 Review

    Module 5 - Performing Disconnected Operations by Using Visual Studio 2005 Wizards

    Disconnected Datasets
    Untyped vs. Typed Datasets
    Tables in Typed Dataset
    Demo - Creating a Dataset and Datatable
    Retrieve Data from a DataTable
    DataTable Methods
    DataTable Properties
    Demo - Work with Datatable's
    Table Adapters
    Demo - Create Table adapter
    Lab Demonstration 2
    Module 5 Review

    Module 6 - XML Operations on Disconnected Data

    XML and ADO.Net
    Work with XML and DataSets
    Demo - Load a Dataset from XML
    Demo - Write XML from Dataset
    Diff Gram
    Demo - Show Results of Diff gram
    Module 6 Review

    Module 7 - Reading and Writing XML Data

    Serially Reading XML Data
    Create XML Reader
    Sample XML Reader
    Demo - Create and Use XML reader
    Serially Writing XML Data
    Create XML Writer
    Sample XML writer
    Demo - Create and Use XML writer
    Module 7 Review

    Module 8 - Processing XML Data by Using DOM

    What Is DOM?
    Load an XML Document
    Demo - Create and Load XML Dom Object
    What Are DOM Trees?
    Dom Tree
    XML Nodes in a DOM Tree
    XML Collection Classes
    Demo - Use XML Dom Object by Navigating Nodes
    Lab Demonstration 3
    Module 8 Review

     
    Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST  PROVIDERS CONTACT US  SITEMAP 
    *

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

    CareerVision
    61 CarolineStreet, 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