ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Sweden     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   020 795 420   +1 678 648 3113  
Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses   Home   Contact Us
ASP.NET Training VB.NET Training C# Training .NET 3.5 Training .NET 4.0 Training ASP.NET MVC Training
ASP Training Visual Basic and VBA Training Microsoft Expression Training VS 2005 Tools for Office Training
PowerShell Training SharePoint Training Silverlight Training SQL Server Training IIS Training Live Online Training

ADO.NET Using VB.NET 2008 Training
Introduction to WF with VB.NET Tra
Introduction to WPF with VB.NET
Introduction to WCF with VB.NET
Introduction to VB.NET 2.0
Beginning ASP.NET with VB.NET Training
Building Web Services with VB.NET
.NET Remoting using VB.NET 2005
Visual Studio 2005 Tools for Microsoft Office training


Please contact us
for GSA pricing
and CMAS pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T

 CMAS Approved Contractor Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
3-09-70-2645A




Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Flint, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Trenton, New Jersey
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Stockholm, Sweden
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

ADO.NET Training: ADO.NET 2.0 Using VB.NET 2005

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 127
Duration: 3 days
view class outline

Looking for ADO.NET using VB.NET 2008 Training?

ADO.NET 2.0 Using VB.NET 2005 Training Overview

ADO.NET 2.0 Using VB.NET 2005 teaches attendees how to use ADO.NET, Microsoft's architecture for integrating data from relational databases, XML documents, and other sources with your applications.

Important Note

We can include .NET Framework 3.0/3.5 topics upon request – please indicate this in the comments when you contact us.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/microsoft.htm.

ADO.NET 2.0 Using VB.NET 2005 Training Prerequisites

All attendees should be well-versed in the fundamentals of VB.NET and have experience building VB.NET applications.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15-20 minutes.

ADO.NET 2.0 Using VB.NET 2005 Training Materials

All students receive more than 500 pages of comprehensive courseware and Apress' Pro ADO.NET 2.0.

Software Needed on Each Student PC

  • Windows 2000, Windows XP, Windows Vista, or Windows Server 2003
  • Optional: Internet Information Server 5, 6, 7, or later (enable prior to loading SQL Server 2005 and Visual Studio 2005)
  • Visual Studio 2005 (or 2008) (with SQL Server Express enabled)
  • If instruction on .NET Framework 3.0 or 3.5 is desired, please install the .NET Framework 3.0 or 3.5 SDK
  • A minimum of 1GB RAM

ADO.NET 2.0 Using VB.NET 2005 Training Objectives

  • To master using ADO.NET to integrate relational database and XML data with your applications.

ADO.NET 2.0 Using VB.NET 2005 Training Outline

  • Accessing Data with ADO.NET
    • The ADO.NET Object Model
    • Connecting to Data
    • Understanding Connection Pooling
    • Using Provider Statistics
  • Retrieving Data
    • Introducing Command Classes
    • Working with Data Readers
    • Digging Deeper into Commands and DataReaders
  • Caching Data in DataSets
    • Populating a DataTable
    • Filling DataSets Using a DataAdapter
    • Using the Load Method
    • Retrieving Schema Information
    • DataSets and XML
  • Applying Constraints
    • Using Constraints
    • Foreign Key Constraints
    • Other Constraints
  • Data Relations
    • Creating DataRelations
    • Navigation Pathways
    • Expressions and Relations
    • Specifying XML Nesting
  • Updating Data
    • Creating Commands with CommandBuilders
    • Creating Custom Commands
    • Using Stored Procedures
    • Performing Batch Updates
  • Using Strongly Typed DataSet Classes
    • Using a Loosely Typed DataSet
    • Creating a Strongly Typed DataSet
    • Using a Strongly Typed DataSet
    • Issues with Using a Strongly Typed DataSet
  • Handling Exceptions and Data Errors
    • Using Structured Exception Handling
    • Handling Provider Errors
    • Using Transactions
    • Handling Concurrency Conflicts
  • Searching, Sorting, and Filtering
    • The Sample Project
    • Working with DataTables
    • Working with DataViews
  • Handling AutoIncrement Columns
    • The AutoIncrement Property
    • Retrieving New Database Values
    • Avoiding Multi-User Conflicts
    • Merging Inserted Rows
    • Other Considerations
  • XML Techniques
    • ADO.NET and XML
    • Saving DataSet Data as XML
    • Loading XML Data into a DataSet
    • Working with DataSets and XML Together
    • Working with XML Data in SQL Server
  • Features Supporting SQL Server 2005
    • Enumerating Servers on a Network
    • Asynchronous Processing
    • Multiple Active Result Sets (MARS)
    • Bulk Copy Operations
    • SQL Server Max Data Types
    • SQL Server User Defined Types
    • SQL Server Snapshot Isolation
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training