MAKING TRAINING & CERTIFICATION EASY
F1 - Microsoft CRM Gold Partner 15+ Years Experience
of CRM, Consultancy, customisation, training and support

View Recent History

(6157) Whats New in SQL Server 2008 - Clinic & Hands-on Lab - Microsoft Training Courses London South West UK
(2159) Deploying and Managing Microsoft Internet Security and Acceleration Server 2000 - Microsoft Training Courses London South West UK
(3041) First Look: Deploying Microsoft Windows Vista and the 2007 Office System Client Products - Microsoft Training Courses London South West UK
(1502) Designing and Implementing a Data Warehouse Using Microsoft SQL Server 7.0 - Microsoft Training Courses London South West UK
(2549) Advanced Distributed Application Development with Microsoft Visual Studio 2005 - Microsoft Training Courses London South West UK
(2571) Application Upgrade and Interoperability Using Visual Studio .NET (Visual Basic .NET) - Microsoft Training Courses London South West UK
F1 - Reservation for Training Course
Exchange Server 2007 Course Index - F1Computing Microsoft Training Courses London South West UK
(6428) Configuring and Troubleshooting Windows Server 2008 Terminal Services - Microsoft Training Courses London South West UK
(2730) Building Microsoft Content Management Server 2002 Solutions - Microsoft Training Courses London South West UK
(2349) Programming with the Microsoft .NET Framework (Microsoft Visual C#) - Microsoft Training Courses London South West UK
(8523) Microsoft CRM 3.0 Service Management - Microsoft Training Courses London South West UK
(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses London South West UK
(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses London South West UK
(2282) Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure - Microsoft Training Courses London South West UK
(1913) Exchanging and Transforming Data Using XML and XSLT - Microsoft Training Courses London South West UK
(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses London South West UK
(5047) Introduction to Installing and Managing Microsoft Exchange Server 2007 - Microsoft Training Courses London South West UK
(3199) First Look: Getting Started with the 2007 Microsoft Office System - Microsoft Training Courses London South West UK
NET Framework Development Course Index - F1Computing Microsoft Training Courses London South West UK
(F1036) Fast-Track to Microsoft .NET Core Certification Exam (70-536) - Microsoft Training Courses London South West UK
(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses London South West UK
(2017) Creating Web Parts for Digital Dashboards - Microsoft Training Courses London South West UK
Certification Fast-Track Course Index - F1Computing Microsoft Training Courses London South West UK
(5118) Supporting Windows Vista and Applications in the Enterprise - Microsoft Training Courses London South West UK
(2095) Implementing Microsoft SharePoint Portal Server 2001 - Microsoft Training Courses London South West UK
(F1022) Preparation Course for Exam 70-310 - Microsoft Training Courses London South West UK
(2535) Developing Board Support Packages for Windows CE .NET - Microsoft Training Courses London South West UK
(F1003) Visual FoxPro 6.0 Upgrade - Microsoft Training Courses London South West UK
(1631) Developing Windows CE Embedded Solutions - Microsoft Training Courses London South West UK
(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - Microsoft Training Courses London South West UK
(F1018) Web Database Programming with Java - Microsoft Training Courses London South West UK
SQL Server 7 Course Index - F1Computing Microsoft Training Courses London South West UK
(6417) Updating Your Application Platform Technology Skills to Windows Server 2008 - Microsoft Training Courses London South West UK
(4007) Creating Effective Presentations Using Microsoft Office PowerPoint 2003 - Microsoft Training Courses London South West UK
(2364) What's New in Microsoft Visual Studio 2005 for existing Visual Studio .NET Developers - Microsoft Training Courses London South West UK
(2072) Administering a Microsoft SQL Server 2000 Database - Microsoft Training Courses London South West UK
(2542) Advanced Data Access with Microsoft Visual Studio 2005 - Microsoft Training Courses London South West UK
Office (inc SharePoint) Course Index - F1Computing Microsoft Training Courses London South West UK
(2790) Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 - Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Visual Studio 2005

Advanced Data Access with Microsoft Visual Studio 2005 -
(Microsoft Training Course: 2542) - 2 days - £850 exc VAT

Save up to 50% of the cost of this course by checking our Certification Packages


> Target Audience
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. It 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.
> Course outline
  1. Minimizing and Handling Database Operation Conflicts
  2. Handling Large Objects
  3. Enhancing Database Performance
  4. Creating Managed Code Objects for SQL Server 2005
  5. Querying XML by Using XPath
  6. Transforming XML by Using XSLT Style Sheets
Module 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
  • Lab: Minimizing and Handling Database Operation Conflicts
Skills
  • Explain why data conflicts arise.
  • Describe the isolation levels that are available in SQL Server 2005.
  • Describe the guidelines for using SQL Server 2005 isolation levels.
  • Read committed data by using locks.
  • Read committed data by using statement-level snapshots.
  • Read committed data by using transaction-level snapshots.
  • Handle data concurrency by using ADO.NET.
top
Module 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
  • Lab: Handling Large Objects
Skills
  • Describe binary large objects and character large objects.
  • Explain the process for reading large objects from a database.
  • Explain the process for writing large objects to a database.
  • Read large values from SQL Server.
  • Write large values to SQL Server.
  • Conserve resources when writing large values to SQL Server.
top
Module 3: Enhancing Database Performance
  • ADO.NET Enhancements in the .NET Framework 2.0
  • SQL Server Provider Statistics
  • Lab: Enhancing Database Performance
Skills
  • Describe the ADO.NET enhancements in Microsoft .NET Framework 2.0.
  • Describe the support for run-time statistics in the .NET Framework Data Provider for SQL Server.
  • Access multiple result sets concurrently.
  • Perform asynchronous data access operations.
  • Perform a batch update.
  • Perform a bulk data copy.
top
Module 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
  • Lab: Creating Managed Code Objects for SQL Server 2005
Skills
  • Describe the benefits of creating managed code objects for SQL Server 2005.
  • Explain the process for importing an existing assembly into SQL Server 2005.
  • Explain the process for implementing managed code objects in SQL Server 2005.
  • Create managed stored procedures and triggers.
  • Create managed user-defined functions.
  • Create a managed aggregate.
  • Create a managed user-defined type.
top
Module 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
  • Lab: Querying XML by Using XPath
Skills
  • Describe the XPath data model.
  • Explain the process for selecting and editing XML data by using XPathNavigator.
  • Explain the process for evaluating XPath expressions by using XPathNavigator.
  • Select XML data by using XPathNavigator.
  • Evaluate XPath expressions by using XPathNavigator.
  • Create and use compiled XPath expressions.
  • Edit XML data by using XPathNavigator.
top
Module 6: Transforming XML by Using XSLT Style Sheets
  • What Is XSLT?
  • The Process for Executing an XSLT Style Sheet
  • What Are Extension Objects?
  • Lab: Transforming XML by Using XSLT Style Sheets
Skills
  • Describe the purpose of XSLT.
  • Explain the process for executing an XSLT style sheet.
  • Describe the purpose of extension objects.
  • Transform an XML document by using an XSLT style sheet.
  • Resolve external resources during XSLT processing.
  • Pass parameters into an XSLT style sheet.
  • Create and use extension objects.
top
> Pre-Requisites
Before attending this course, students should have the following pre-requisites:
  • Attended Course 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.
> Purpose
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.
> EXAMS
Microsoft recommends this course in preparation for the following exams: