• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

Software Development Courses   Microsoft .NET Framework and Programming

M2542: Advanced Data Access Development with Visual Studio 2005

View course dates

Course Duration: 2 Days

Course Code: M2542

Course Description:

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 ADO.NET 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).

 

Elements of this syllabus are subject to change.

Prerequisites:

Before attending this workshop, students must:


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

Prerequisite courses:

M2541: Core Data Access Development with Visual Studio 2005 (Workshop)

Relevant Certifications:

MCTS: .NET Framework 2.0 Web Applications

MCTS: .NET Framework 2.0 Windows Applications

MCDBA: on Microsoft SQL Server 2000

MCPD: Web Developer

MCPD: Windows Developer

MCPD: Enterprise Applications Developer

This course includes the following modules:

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?

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking or check availability.
Altrincham	2 days	£750			26 - 27
Hinckley	2 days	£750		22 - 23		26 - 27
Leeds	2 days	£750		29 - 30
London (KWS)	2 days	£750		8 - 9
London (Mid)	2 days	£700			5 - 6		16 - 17
Washington	2 days	£750			5 - 6		23 - 24

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course