 |
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
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
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- 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 Visual Basic 2010 Training
|
Course Number: ADO-104
Duration: 3 days
view class outline
ADO.NET Training Overview
Accelebrate's ADO.NET Training: ADO.NET Using Visual Basic 2010 course 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=categorygroup&page=microsoft.
ADO.NET Training Prerequisites
All attendees should have a basic knowledge of SQL and of programming the .NET Framework using Visual Basic and understand the fundamentals of XML. A working knowledge of SQL Server and writing simple Windows Forms applications is also desirable.
Hands-on/Lecture Ratio
This ADO.NET Training Using Visual Basic 2010 class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15-20 minutes.
ADO.NET Training 2010 Materials
All students receive more than 500 pages of comprehensive courseware and Murach’s ADO.NET 4 Database Programming with VB 2010.
Software Needed on Each Student PC
- Windows XP with Service Pack 3 or Windows Vista or 7 with at least 3GB RAM
- Visual Studio 2010, Professional Edition or higher
- SQL Server or SQL Server 2008 Express (which comes with Visual Studio 2010) with sample databases that Accelebrate provides
- Related lab files that Accelebrate provides
ADO.NET Training 2010 Objectives
Attendees will learn to:
- Understand the architecture and main classes of ADO.NET
- Gain fluency in programming ADO.NET using Visual Basic
- Gain a thorough understanding of the use of disconnected DataSets for building highly scalable applications
- Acquire a working knowledge of the tight coupling of XML with ADO.NET
- Use additional features in ADO.NET, including asynchronous operations, multiple active result sets, and bulk copy
- Acquire a working knowledge of LINQ and the Entity Framework
- Implement a realistic case study that ties together many concepts of ADO.NET in a practical demonstration
|
ADO.NET Training Using Visual Basic 2010 Outline
- Introduction to ADO.NET
- Microsoft Data Access Technologies
- From ADO to ADO.NET
- ADO.NET Architecture
- Namespaces and Classes
- Interfaces
- DataSets and Disconnected Access
- First ADO.NET Programs
- Acme Computer Case Study
- ADO.NET Connections
- .NET Data Providers
- IDbConnection
- Connection Classes
- Connection Strings
- Connection Pooling
- Connection Events
- Error Handling
- ADO.NET Commands
- IDbCommand
- Command Objects
- Creating Commands
- Executing Commands
- Parameterized Queries
- Command Types
- Using Stored Procedures
- Batch Queries
- DataReaders and Connected Access
- DataReaders
- IDataReader
- IDataRecord
- Type-Safe Accessors
- Null Columns
- ExecuteReader Options
- Multiple Result Sets
- Obtaining Schema Information
- Data Sets and Disconnected Access
- DataSet
- DataAdapter
- Command Objects
- DataTable
- DataColumn
- DataRow
- Row States and Versions
- Accept or Reject Changes
- DataTable Events
- Updating a Database from a DataSet
- Command Builders
- More About DataSets
- Filtering DataTables
- Multiple Table DataSets
- Schema
- Constraints
- Relations
- Navigating a DataSet
- DataMapping
- Creating a DataSet Programmatically
- 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
- XML and ADO.NET
- Strong Coupling Between ADO.NET and XML
- Rendering XML from a DataSet
- Controlling XML Output
- Reading XML into a DataSet
- XML Schema and DataSets
- Typed DataSets
- Table Adapters
- Synchronizing DataSets and XML
- XML Serialization
- Concurrency and Transactions
- DataSets and Concurrency
- Optimistic Concurrency
- Pessimistic Concurrency
- Handling Concurrency Violations
- ADO.NET Transactions
- Database Transactions
- Additional Features
- Asynchronous Database Operations
- Multiple Active Result Sets
- Bulk Copy
- LINQ and Entity Framework
- Language Integrated Query (LINQ)
- Bridging Objects and Data
- Using Object Relational Designer
- Filtering, Ordering and Aggregation
- Inserts, Deletes and Updates
- LINQ to SQL
- LINQ to DataSet
- ADO.NET Entity Framework
- LINQ to Entities
- Conclusion
|
Java® and all Java-based marks are registered trademarks of the Oracle Corporation 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.
|
|
|
|
