Home >> IT Training >> Microsoft Classes

Data Access with Microsoft Visual Studio 2005 Training Classes

Why is our Data Access with Microsoft Visual Studio 2005 training class different from others you can find on the web? We hire only qualified, full-time IT consultants that have years of experience and the ability to pass that knowledge onto their students. Because our classes are taught by these professionals in real-time, you can bring them your workplace scenarios and have your questions answered right away. We teach the information over five intense days so that you leave the course confident in your abilities.

In our IT training classes, you will learn advanced skills of accessing and editing data using ADO.NET. We will start by teaching you the fundamentals of connecting to a database and reading data. You will learn about ADO.NET commands and about passing parameters to commands. You will manage local and distributed transactions and specify an appropriate isolation level. We teach you to Visual Studio 2005 wizards as well as how to read and write XML data. We will show you how to process XML data using DOM, how to handles large objects and create managed code objects for SQL Server 2005. The course ends by teaching you to execute an XSLT style sheet.

For companies with more than six employees who need training, our onsite Data Access with Microsoft Visual Studio 2005 training class can save both time and money. By brining the classroom to your facility, we can save your employees valuable commute time and save the company an average of 30% off the cost of a course taught in a traditional classroom.

If you are ready to take the next step in your career, enroll in our Data Access with Microsoft Visual Studio 2005 training class today. Just click on the blue button to get started.

Enrollment Fee: 2995.00 USD
Number of Class Days: 5

Data Access with Microsoft Visual Studio 2005 schedule:
Call for more information

Training Class Outline:

1. Connecting to Databases and Reading Data

*ADO.NET
*Connecting to a Database and Reading Data
*What Is Connection Pooling?

2. Querying and Updating Databases by Using Commands

*ADO.NET Commands
*Passing Parameters into Commands

3. Performing Transactional Operations

*Transactions
*Managing Local Transactions
*Managing Distributed Transactions
*Isolation Levels

4. Performing Disconnected Operations Programmatically

*The ADO.NET Disconnected Model
*Loading and Saving Data in a DataSet
*DataViews

5. Performing Disconnected Operations by Using Visual Studio 2005 Wizards

*Comparing Untyped DataSets with Typed DataSets
*What Are Table Adapters?
*Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards

6. Performing XML Operations on Disconnected Data

*XML Representations of DataSets
*DiffGrams

7. Reading and Writing XML Data

*Serially Reading XML Data
*Serially Writing XML Data

8. Processing XML Data by Using DOM

*DOM
*DOM Trees
*Types of XML Nodes in a DOM Tree

9. Minimizing and Handling Database Operation Conflicts

*Why Data Conflicts Arise
*Isolation Levels Available in SQL Server 2005
*Guidelines for Using SQL Server 2005 Isolation Levels

10. Handling Large Objects

*Binary Large Objects and Character Large Objects
*Reading Large Objects from a Database
*Writing Large Objects to a Database

11. Enhancing Database Performance

*ADO.NET Enhancements in the .NET Framework 2.0
*SQL Server Provider Statistics

12. Creating Managed Code Objects for SQL Server 2005

*Benefits of Creating Managed Code Objects
*Demonstration: Importing an Existing Assembly into SQL Server 2005
*Demonstration: Implementing Managed Code Objects in SQL Server 2005

13. Querying XML by Using XPath

*The XPath Data Model
*Selecting and Editing XML Data Using XPathNavigator
*Evaluating XPath Expressions Using XPathNavigator

14. Transforming XML by Using XSLT Style Sheets

*XSLT
*Executing an XSLT Style Sheet
*Extension Objects