2542 Advanced Data Access with Microsoft Visual Studio 2005

New Horizons Computer Learning Centers
Training overview
2 days
Next start date: Contact for info. - United States of America

Course description

This workshop provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005.

Course Outline

Minimizing and Handling Database Operation Conflicts

  • Why Do Data Conflicts Arise?
  • Isolation Levels Available in SQL Server 2005
  • Guidelines for Using SQL Server 2005 Isolation Levels

Handling Large Objects

  • What Are Binary Large Objects and Character Large Objects?
  • The Process for Reading Large Objects from a Database
  • The Process for Writing Large Objects to a Database

Enhancing Database Performance

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

Creating Managed Code Objects for SQL Server 2005

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

Querying XML by Using XPath

  • The XPath Data Model
  • The Process for Selecting and Editing XML Data by Using XPathNavigator
  • The Process for Evaluating XPath Expressions by Using XPathNavigator

Transforming XML by Using XSLT Style Sheets

  • What Is XSLT?
  • The Process for Executing an XSLT Style Sheet
  • What Are Extension Objects?

Course Objectives

After completing this workshop, students will be able to:
- Minimize and handle database operation conflicts.
- Handle large objects.
- Enhance database performance.
- Create managed code objects for SQL Server 2005.
- Query XML by using XPath.
- Transform XML by using XSLT style sheets.

Who should attend?

This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

About New Horizons Computer Learning Centers

New Horizons Computer Learning Centers - Find Training

Premier Provider of Computer Courses and Certifications

New Horizons Computer Learning Centres provide high quality, flexible and intuitive training that is always delivered by award-winning instructors and uses the best resources available. New Horizons is the world’s largest independent IT training company, that has provided industry-leading technical training for...

Read more and show all training delivered by this supplier

New Horizons offer an extensive array of the vendor-authorized training and certifications that are in highest demand—including Microsoft, Cisco, CompTIA and VMware. They are the Worl'ds Largest IT Training provider delivering courses at more than 300 centers.

Contact info

New Horizons Computer Learning Centers

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available