 |
 Introduction to WF with C#
Introduction to WPF with C#
Introduction to C# 2.0 Programming
Beginning ASP.NET with C# training
Building Web Services with C# training
ADO.NET 2.0 Using C#
.NET Remoting using C#
Visual Studio 2005 Tools for Microsoft Office training
 Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
Complimentary C# Training Seminar
Organizations in the Atlanta, Georgia area are encouraged
to contact Accelebrate® about having a complimentary, one-hour C# seminar
delivered for their developers. Contact
us today for more information.
Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Fayetteville / Little Rock, Arkansas
- Oakland / San Jose / San Francisco, 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
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Kingston, Jamaica
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge, Louisiana
- Valletta, Malta
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Taunton, Massachusetts / Providence, Rhode Island
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Lansing, Michigan
- Saginaw / Flint / Bay City / Midland, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- Gulfport / Biloxi, Mississippi
- Whiteman Air Force Base / Kansas City, Missouri
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Newark, New Jersey
- Princeton, New Jersey & Philadelphia, Pennsylvania
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- 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 C#
|
Course Number: 157
Duration: 3 days
view class outline
ADO.NET 2.0 Using C# Training Overview
ADO.NET 2.0 Using C# teaches attendees how to use ADO.NET, Microsoft's architecture for integrating data from relational databases, XML documents, and other sources with your applications.
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. To receive a customized proposal and price quote, 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 C# Training Prerequisites
All attendees should be well-versed in the fundamentals of C# and have experience building C# 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 C# Training Materials
All students receive more than 500 pages of comprehensive courseware and Apress' Pro ADO.NET.
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 C# Training Objectives
- To master using ADO.NET to integrate relational database and XML data with your applications.
|
ADO.NET 2.0 Using C# 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
|
| |
|
|
Accelebrate®
Comes to You! |
|
Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.
For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
|
|
| |
