Support

Advanced Data Access with Microsoft Visual Studio 2005

6 sessions available starting from $1,360.00

Subject: Microsoft ASP.NET

Ages: All ages

Skill level: All difficulty levels

Course Code: 2542
Course Duration: 2 days

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

Skills Gained

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

see more

Course Code: 2542
Course Duration: 2 days

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

Skills Gained

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.

Course Modules

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.

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.

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.

Session 4: Unit 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.

Session 5: Unit 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.

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

Who Should Attend

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.

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.

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Microsoft Office SharePoint Server 2007 Training Course | Records Management Solutions
Microsoft Office SharePoint Server 2007 Training Course | Records Management Solutions
1 session available for $1,360.00
SQL Server 2008 Training Course | For the Experienced Oracle Database Administrator
SQL Server 2008 Training Course | For the Experienced Oracle Database Administrator
3 sessions available starting from $2,720.00
Microsoft Exchange Server 2010 Course (Beta) Ignite
Microsoft Exchange Server 2010 Course (Beta) Ignite
5 sessions available starting from $2,040.00

see all listings »


Found In