Description

Summary: This five-hour online learning course for advanced developers teaches the use of advanced scalable data management techniques in .NET based applications.

Audience: Advanced Developer
Available Offline: Yes
Subscription: 12 months

Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 5 Hours
Language: English

Description:
This five-hour online learning course provides you with the skills and knowledge to develop highly scalable database-oriented solutions by using Microsoft .NET technologies.

This course will enable you to identify the various techniques for managing database table identity keys, develop transactional systems in a multilayered application, analyze the data locking strategies, and handle potential deadlocks that may occur when manipulating data in the database.

Course Objectives

At the end of the course, students will be able to:

• Describe the use of auto-increment columns and Globally Unique Identifiers (GUIDs) for managing database table row identity.
• Handle data identity in a distributed system by using ADO.NET.
• Describe SQL transaction handling and componentized transaction management in .NET.
• Implement optimistic and pessimistic distributed application locking in .NET.
• Identify why deadlocks occur and describe how to handle them.
• Automate deadlock handling by using Real Proxy interception.

Technical Requirements

To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Accessibility Requirements

The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled