Skip to content

Advanced Data Access with Microsoft Visual Studio 2005

Infero Training Ltd

Summary

Price
£763.20 inc VAT
Or £63.60/mo. for 12 months...
Study method
Classroom
Duration
2 days · Part-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Location & dates

Location

Address
Station St
New Street Station Forecourt
BIRMINGHAM
West Midlands
B24ND
United Kingdom
View on Map

Address
Friary
Friary
BRISTOL
Avon
BS16EA
United Kingdom
View on Map

Address
The Space Centre
Judd Street
CENTRAL LONDON
LONDON
WC1H9NT
United Kingdom
View on Map

Address
Parkside
Parkside
COVENTRY
West Midlands
CV12HG
United Kingdom
View on Map

Overview

This two-day instructor-led 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. The workshop describes how to access data and how to implement database functionality by using Microsoft ADONET 2.0 and Microsoft SQL Server 2005. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

Description

Session 1: Unit 1: 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

Session 2: Unit 2: 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

Session 3: Unit 3: Enhancing Database Performance

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

Session 4: Unit 4: 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

Session 5: Unit 5: 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

Session 6: Transforming XML by Using XSLT Style Sheets

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

Who is this course for?

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

Requirements

• Have attended or studied Workshop 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.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Web development, Development, IT