Home >> IT Training >> Microsoft Classes

Advanced Data Access with Microsoft Visual Studio 2005 Training Classes

Our Advanced Data Access with Microsoft Visual Studio 2005 training class is different from others because we hire only professional IT consultants as instructors. Not only do they have years of experience, but they have the talent to pass that knowledge on to you. Because our IT training classes are taught by real professionals in real-time, you can bring in your workplace scenarios and have your questions answered right away. Our course is taught over two days so you leave confident in your new abilities.

In our classes, you will gain the knowledge you need to use advanced data access features in the Microsoft .NET framework on Microsoft Visual Studio 2005. You will learn about data conflicts and guidelines for using SQL Server Isolation levels. We teach you how to read and write large objects to a database and creatively manage code objects with two demonstrations on importing and existing assembly into SQL Server 2005 and implementing managed code objects. You will also learn about XPath data models and evaluate XPath expressions using XPath Navigator. We use materials from the Official Microsoft Learning Products so that you can be sure you are getting the best and most up to date information.

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

If you are an IT professional who is ready to take the next step in your career, enroll in our Advanced Data Access with Microsoft Visual Studio 2005 training class today.

Enrollment Fee: Call For More Information!
Number of Class Days: 2

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

Training Class Outline:

1. 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

2. Handling Large Objects

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

3. Enhancing Database Performance

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

4. Creating Managed Code Objects for SQL Server 2005

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

5. Querying XML by Using XPath

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

6. Transforming XML by Using XSLT Style Sheets

*What XSLT Is
*Executing an XSLT Style Sheet
*Extension Objects