2542 Advanced Data Access

2542: advanced data access with microsoft visual studio 2005

duración: 14 hrs.

about this workshop
elements of this syllabus are subject to change.
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).
audience profile
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.
at workshop completion
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.

session 1: unit 1: minimizing and handling database operation conflicts
this unit describes how to minimize data access conflicts, and how to handle these conflicts when they occur. It describes how to implement optimistic concurrency in the ado. Net disconnected model, and how to implement optimistic concurrency by using the various isolation levels available in sql server 2005.
lessons
•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
•exercise 1. Reading committed data by using locks
•exercise 2. Reading committed data by using statement-level snapshots
•exercise 3. Reading committed data by using transaction-level snapshots
•exercise 4. Handling data concurrency by using ado. Net
after completing this unit, students will be able to:
•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.
session 2: unit 2: handling large objects
this unit describes how to read and write large values efficiently to a sql server database. It describes how to read large binary values and large text values by using sequentialaccess for a sqldatareader. It also describes how to write large binary values and large text values, and how to conserve resources when writing large values.
lessons
•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
•exercise 1. Reading large values from sql server
•exercise 2. Writing large values to sql server
•exercise 3. Conserving resources when writing large values to sql server
after completing this unit, students will be able to:
•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.
session 3: unit 3: enhancing database performance
this unit describes how to enhance database performance by using new features available in ado. Net 2. 0. The unit describes how to perform asynchronous data operations, create multiple active result sets, perform batch updates, and perform bulk copies.
lessons
•ado. Net enhancements in the . Net framework 2. 0
•