In this two-day instructor-led workshop, you will 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
Learn how to develop using XML and ADO.NET.
In this two-day instructor-led workshop, you will the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005. You will learn how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. Also, you will learn how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).
This course incorporates material from the Official Microsoft Learning Product 2542: Advanced Data Access with Microsoft Visual Studio 2005.
This course will help you prepare for the following certifications:
- MCTS: .NET Framework 2.0 Web Applications
- MCTS: .NET Framework 2.0 Windows Applications
- MCPD: Windows Developer on Visual Studio 2005
- MCPD: Enterprise Applications Developer on Visual Studio 2005
- 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
Corporate and Independent Software Vendor (ISV) application developers who want to learn more about specific technology areas in distributed application development.
1. Minimizing and Handling Database Operation Conflicts
- Why Data Conflicts Arise
- Isolation Levels Available in SQL Server 2005
- Guidelines for Using SQL Server 2005 Isolation Levels
- Binary Large Objects and Character Large Objects
- Reading Large Objects from a Database
- Writing Large Objects to a Database
- ADO.NET Enhancements in the .NET Framework 2.0
- SQL Server Provider Statistics
- Benefits of Creating Managed Code Objects
- Demonstration: Importing an Existing Assembly into SQL Server 2005
- Demonstration: Implementing Managed Code Objects in SQL Server 2005
- XPath Data Model
- Selecting and Editing XML Data by Using XPathNavigator
- Evaluating XPath Expressions by Using XPathNavigator
- What XSLT Is
- Executing an XSLT Style Sheet
- Extension Objects
Lab 1: Minimizing and Handling Database Operation Conflicts
- Reading Committed Data by Using Locks
- Reading Committed Data by Using Statement-Level Snapshots
- Reading Committed Data by Using Transaction-Level Snapshots
- Handling Data Concurrency by Using ADO.NET
- Reading Large Values from SQL Server
- Writing Large Values to SQL Server
- Conserving Resources When Writing Large Values to SQL Server
- Accessing Multiple Result Sets Concurrently
- Performing Asynchronous Data Access Operations
- Performing a Batch Update
- Performing a Bulk Data Copy
- Creating Managed Stored Procedures and Triggers
- Creating Managed User-Defined Functions
- Creating a Managed Aggregate
- Creating a Managed User-Defined Type
- Importing Existing Assemblies into SQL Server 2005
- Selecting XML Data by Using XPathNavigator
- Evaluating XPath Expressions by Using XPath Navigator
- Creating and Using Compiled XPath Expressions
- Editing XML Data by Using XPathNavigator
- Transforming an XML Document by Using an XSLT Style Sheet
- Resolving External Resources During XSLT Processing
- Passing Parameters into an XSLT Style Sheet
- Creating and Using Extension Objects
- Prerequisites & Certificates
- Course 6197: Core Data Access with Microsoft Visual Studio 2005 or equivalent knowledge and skills - Ability to use delegates - Ability to use database stored procedures, triggers, and aggregates - Ability to explain XPath concepts and basic syntax - Ability to explain XSLT style sheet concepts - Core Data Access with Microsoft Visual Studio 2005 (M2541)
Certificate of Completion * Eligible for SATV Purchase
- Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.
Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
- Map & Reviews
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 224 times.