What you'll learn?

  • Set up trace logging
  • Identify the situation where caching can be used to optimize performance and manage to minimize the effects of stale data.
  • Recognize the security capabilities available for ADO.NET 2.0 and demonstrate ability to use available features to improve security.
  • Identify and differentiate between the available large objects (LOBs) type, and demonstrate ability to implements routines that read and write BLOBs Data.
  • Demonstrate ability to use the available tools that enable dealing with XML data type.
  • Demonstrate understanding for the connection pooling concept.

Description

Microsoft ADO.NET 2.0 represents a major improvement in data access capabilities. This book pick up where the core course left off and dives deep into advanced implementations of the new and old ADO.NET features.

Audience :

This course suits developer with basic knowledge of accessing data stores using ADO.NET 2.0 and willing to further their skills by learning more advanced techniques.

Topics :

Trace Logging

o  Using the logman.exe Utility

o  Performance Logs and Alerts Snap-In

o  Working with Event Trace Log Files

Security

o  Application Security Overview

o  Partial Trust Support

o  Preventing SQL Injection Attacks

o  Storing Encrypted Connection Strings

o  Using Stored Procedures

Working with Large Objects (LOBs)

o  Storing LOBs

o  Reading BLOBs

o  Writing BLOBs

Working with XML Data

o  Introducing XPath and XQuery

o  The xml Data Type

o  Using XML with ADO.NET

Data Caching and Performance

o  Deciding what to cache

o  Using the SqlDependency class

Advanced Connectivity to the Data Store

o  Connection Pooling

o  Asynchronous Data Access

Prerequisities :

Recommended Knowledge :

Ability to use one of the .NET Languages and basic knowledge of using ADO.NET 2.0 are two prerequisites to this course.

Recommended Course(s) :

Category :

  • Programming
  • Database

Training Materials :

YAT Official Courseware

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is part of YAT Professional Diploma in Programming – Expert Level.

Related Courses