MS SQL Server 2005: Programming with ADO




Distance-learning Center

Submit IT Questions

DURATION: 4 days

FEE: $1,580


  • Support Personnel
  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional


  • Temporary tables and table variables
  • Cursors
  • Dynamic SQL
  • Views
  • User-defined functions
  • Stored procedures
  • Triggers
  • Transactions
  • Exception handling
  • Connecting to data sources
  • Performing connected database operations
  • Building datasets
  • Reading and writing XML with ADO.NET
  • Building datasets from existing data sources
  • Strongly typed dataset objects and tableadapters
  • Submitting updates to the database
  • Distributed transactions

Contact Me
Send Outline
Private Course - Tailored
Cost Analysis

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

The course material and training aids utilized in SYS-ED courses are from multiple sources: courseware generated by staff members, licensed materials, public sources from the Internet, textbooks, and source vendor's documentation.

Not all courses are available for delivery in a distance-learning medium.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software companies, healthcare providers, and mid-sized businesses.

Individuals attending a SYS-ED course will be required to execute a statement that the employer has a licensed version of the software.