"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

2542 - Advanced Data Access with Microsoft Visual Studio 2005

This coursep 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. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005.

The course also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

 

Computer_Code.jpg

Who should attend?

This course 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.

2542 - Advanced Data Access with Microsoft Visual Studio 2005

Before attending this course, students must have:

  • Have attended or studied Coure 2541, Core Data Access with Microsoft Visual Studio 2005, or possess equivalent knowledge and skills..
  • Know how to use delegates.
  • Be able to use database stored procedures, triggers, and aggregates.
  • Be able to explain XPath concepts and basic syntax.
  • Be able to explain XSLT style sheet concepts.

Module 1: Minimizing and Handling Database Operation Conflicts

  • Minimizing and Handling Database Operation Conflicts
  • Why Do Data Conflicts Arise?
  • Optimistic
  • Pessimistic
  • “Last One In Wins”
  • Isolation Levels in SQL Server 2005
  • Isolation Levels Matrix
  • Using SQL Server 2005 Isolation Levels
  • Using ADO.NET to Handle Conflicts

Module 2: Handling Large Objects

  • Handling Large Objects
  • Binary Large Objects
  • Character Large Objects
  • Large Value Data Types
  • Reading Large Objects from a Database
  • Writing Large Objects to a Database

Module 3: Transactional Operations

  • Enhancing Database Performance
  • ADO.NET Enhancements in the .NET Framework 2.0
  • MARS
  • Asynchronous Operations
  • SQL Server Provider Statistics

Module 4: Creating Managed Code Objects for SQL Server 2005

  • Creating Managed Code Objects for SQL Server 2005
  • .NET and SQL Server 2005
  • Managed Objects
  • The Benefits of Creating Managed Code Objects
  • Importing an Existing Assembly into SQL Server 2005
  • Implement Managed Code Objects in SQL Server 2005

Module 5: Querying XML by Using Xpath

  • XPath Data Model
  • Node Types
  • Selecting XML Data Using XPathNavigator
  • Editing XML Data Using XPathNavigator
  • Evaluating XPath Expressions Using XPathNavigator

Module 6: Transforming XML by Using XSLT Style Sheets

  • Transforming XML by Using XSLT Style Sheets
  • What is XSLT?
  • Using an XSLT Style Sheet
  • Executing an XSLT Style Sheet
  • Executing an XSLT Style Sheet Sample
  • Add Parameters
  • XslCompiledTransform Object
  • Using the Resolver
  • XslCompiledTransform Object Cont.
  • Extension Objects
  • Create Extension
  • Benefits and Drawbacks of Extension Objects

Duration:

Learning Materials:

Prerequisites:

What course next:



2 Days

All included



MCPD

MCTS SQL 2008 »

 



Get a Quote today »

 

Course Content
2542 - Advanced Data Access with Microsoft Visual Studio 2005

   • Minimizing and Handling Database Operation Conflicts
   • Handling Large Objects
   • Transactional Operations
   • Creating Managed Code Objects for SQL Server 2005
   • Querying XML by Using Xpath
   • Transforming XML by Using XSLT Style Sheets
 

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.