Advanced Data Access with Microsoft Visual Studio 2005

Hilton Computer Strategies
Houston, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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



Audience


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 Course Completion
At the end of the course, 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

Prerequisites
Before attending this course, students must have:

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

Microsoft Certified Professional Exams
There is no MCP exam associated with this course.

Student Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.



Course Outline

Module 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

Module 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



Module 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 2.0 framework

SQL Server provider statistics



Module 4: Creating Managed Code Objects for SQL Server 2005
This unit describes how to create database objects for SQL Server 2005 in a .NET Framework programming language. It describes how to create stored procedures, triggers, user-defined functions, aggregates, and user-defined types in managed code. Additionally, it describes how to deploy an assembly that contains managed objects into SQL Server 2005, and how to declare database objects to reference the managed objects.

Lessons

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



Module 5: Querying XML by using XPath
This unit describes how to use XPath in a .NET Framework application. It describes how to create an XPathNavigator object on an XML document, and how to locate content and evaluate expressions by using the XPathNavigator object. Additionally, it describes how to edit XML data by using the XPathNavigator object.

Lessons

The XPath data model

The process for selecting and editing XML data by using XPathNavigator

The process for evaluating XPath expressions by using XPathNavigator

Module 6: Transforming XML by Using XSLT Style Sheets
This unit describes how to transform XML documents in a .NET Framework application. It introduces how to load an XSLT style sheet in an application, and how to execute the style sheet to transform an XML document. The unit also describes how to pass parameters into a style sheet, and how to create and use extension objects.

Lessons

What is XSLT?

The process for executing an XSLT style sheet

What are extension objects?

...''

Phone:1-800-324-7415

School Address:

Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036 USA

Jobs & Resumes: Houston
Houses & Roommates: Houston

Visual Basic .NET
Programming with the .NET Framework (Visual Basic .NET)
XML and the Microsoft .NET Platform
Developing XML Web Services using Microsoft ASP.NET
Developing .NET Applications for Windows (C Sharp .NET)
C Sharp Programming with Microsoft .NET
Programming with XML in the Microsoft .NET Framework
XML Web Services (with MegaLAB)
Data Access and Manipulation using XML and ADO .NET
Core Data Access With Microsoft Visual Studio 2005
Web Application Technologies with Microsoft Visual Studio 2005
Windows Forms Technologies with Microsoft Visual Studio 2005
Distributed Application Development with Microsoft Visual Studio 2005
Programming .NET Framework Applications with Visual Studio 2005
Programming with the .NET Framework using Visual Studio 2005
Web Application Development Using C Sharp & ASP .NET 2.0
Web Application Development Using VB .NET & ASP .NET 2.0
Windows Application Development Using Microsoft VB .NET 2.0
Windows Application Development Using C Sharp .NET 2.0

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!