 |
Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
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
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Kamloops / Vancouver, British Columbia
- 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
- 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
- Honolulu, Hawaii
- 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
- Annapolis / 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
- Fredericton / Moncton / Saint John, New Brunswick
- 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
- Bismarck & Fargo, North Dakota
- Halifax, Nova Scotia
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Québec City / Montreal, Québec
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- 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
- 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
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
ADO.NET Training: ADO.NET Using C# 2008 Training
|
Course Number: ADO-202
GSA/Previous Course Number: 159
Duration: 3 days
view class outline
ADO.NET Training Using C# 2008 Overview
Accelebrate's ADO.NET Training: ADO.NET Using C# 2008 teaches attendees how to use ADO.NET, Microsoft's architecture for integrating data from relational databases, XML documents, and other sources with your applications. Students learn to connect to data sources, retrieve and manipulate data, and perform data updates.
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/?action=category&page=csharp.
ADO.NET Training Using C# 2008 Prerequisites
All attendees should have some familiarity with Visual Studio 2008, the .NET Framework, and the fundamentals of programming with Visual C#.
Hands-on/Lecture Ratio
This ADO.NET Training Using C# 2008 class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15-20 minutes.
ADO.NET Training Using C# 2008 Materials
All students receive more than 500 pages of comprehensive courseware and Apress' Pro ADO.NET.
Software Needed on Each Student PC
- Windows XP with at least 2GB RAM or Windows Vista or 7 with at least 3GB RAM
- Visual Studio 2008 SP1 or later
- SQL Server or SQL Server Express 2005 or 2008 with sample databases that Accelebrate provides
- Related lab files that Accelebrate provides
ADO.NET Training Using C# 2008 Objectives
- Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
- Retrieve data, using the DataAdapter, Command, and DataReader classes
- Create and configure Command parameters
- Cache data using the DataTable and DataSet classes
- Apply constraints to DataTable and DataColumn objects
- Create relations between DataTable objects, using the DataRelation class
- Update data using DataAdapter and Command classes
- Work with strongly typed DataSet and DataTable classes
- Retrieve and update data using TableAdapter classes
- Handle exceptions and data errors, including concurrency errors
- Search, sort, and filter data using the DataView class
- Work with auto-increment columns in multi-user applications
- Retrieve and generate XML data
- Take advantage of new SQL Server 2005/2008 features
|
ADO.NET Training Using C# 2008 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/2008
- 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
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
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.
|
|
| |
