Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques

Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques

Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques five-hour online learning course provides you with the skills and knowledge to develop highly scalable database-oriented solutions by using Microsoft .NET technologies.

Plus, Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques E-Learning lets you learn at your own pace. Work online or download courses to your computer to study when you are not connected to the Internet.

Our Price: $199 Add to Cart

Purchase Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques in the Enterprise to save on Microsoft Mastering Industrial Strength .NET E-learning
Title: Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 5 Hours
Language: English

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 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques 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.

System 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 GS Micro
JAWS from Freedom Scientific
MSAA enabled

Course Course 2622 Using Advanced Microsoft .NET Scalable Data Management Techniques Contents
Course Overview
Module Introduction
How to Use this Course
Course Information
Lab Instructions
Introduction to Mastering Industrial-Strength .NET
Module Introduction
Overview
Lesson Introduction
Why Industrial Strength?
Course Series Structure
Self Test
Dealing with Complexity
Lesson Introduction
.NET-Connected Application Architecture
Service Pipeline
Partner Pipeline
Patterns
Self Test
The Global Bank Application
Lesson Introduction
Application Overview
Lab: Introduction to Global Bank
Self Test
Module Summary
Identity
Module Introduction
Database Row Identity
Lesson Introduction
Comparing Natural Keys and Artificial Keys
Generating Artificial Keys
Using Auto-Increment Columns
Retrieving Identity Values
Generating Client-Side Identifiers
Lab: Managing Identities
Self Test
Module Summary
Transactions
Module Introduction
Database Transactions
Lesson Introduction
Using Transactions
Identifying Concurrency Problems
Self Test
SQL Server Locking
Lesson Introduction
Types of SQL Server Locking
Levels of SQL Server Locking
Exploring Lock Lifetime
Getting the Isolation Level Right
Isolation Levels in SQL Server
Self Test
Implementing Transactions Using ADO.NET
Lesson Introduction
Implementing SQL and ADO.NET Transactions
Lab: Exploring the Need for Transactions
Using Serializable Isolation
JOINS Without Rounds Trips
Passing Around Transactions
Self Test
Implementing Declarative Transactions with Enterprise Services
Lesson Introduction
Declarative and Cascading Transactions
Implementing Distributed and Declarative Components
Setting COM+ Isolation Levels
Disadvantages of Enterprise Services Components
Self Test
Implementing Cascading Transactions
Lesson Introduction
Characteristics of SWC
ThreadStatic Variables
Lab: Using ADO.NET and Pass the Parcel
Self Test
Module Summary
Application Locking Strategies
Module Introduction
Overview of Application-Controlled Locking
Lesson Introduction
Database Lock Problems
What Is Application-Controlled Locking?
Types of Application-Controlled Locking
Self Test
Application-Controlled Optimistic Locking
Lesson Introduction
Detecting Update Conflicts
Exploring Static Detection
Fixing Update Errors
Handling an Update Conflict
.NET 1.1 Problem and Dynamic Detection
Self Test
Application-Controlled Pessimistic Locking
Lesson Introduction
Exploring Pessimistic Locking
Creating a Lock Manager Component
Comparing Pessimistic Lock Types
How Lock Leasing Mechanisms Work
Lab: Application-Level Locking
Self Test
Module Summary
Deadlocks
Module Introduction
Database Deadlocks
Lesson Introduction
What Are Cyclic Deadlocks?
Avoiding Cyclic Deadlocks
What Are Lock Conversion Deadlocks?
Avoiding Lock Conversion Deadlocks
What Are Updlock-Induced Deadlocks?
Self Test
Handling Deadlocks
Lesson Introduction
Exploring Deadlock Error Log Output
Retrying the Transaction
Lab: Database Deadlocks
Self Test
Deadlock Handling
Lesson Introduction
Using Deadlock Retry Logic
Using RealProxy Interception
Comparing Interception Technique
Lab: Interception and Deadlock Replay
Self Test
Module Summary

Our Price: $199 Add to Cart

Frequently Asked Questions on Microsoft E-Learning

Question: What is Microsoft E-learning?
Answer: Official Microsoft E-Learning products provide a thorough learning experience by incorporating features designed to improve your product proficiency and boost your productivity. Assessments, hands-on virtual labs, expert advice, and an interactive, non-linear approach all contribute to make Microsoft E-Learning an engaging and flexible learning experience. Regardless of your type of organization, skill levels, or learning styles; Microsoft E-Learning can provide access to just the right software training anytime and anywhere - for IT Professional, developers, and home and office workers. Microsoft E-Learning content is created by Microsoft experts, so the training comes straight from the source.

Question: How Long and how I will have access to purchased Microsoft E-Learning?
Answer: When you purchase any Microsoft Elearning course from us, we will send product key to activate your Microsoft E-learning subscription directly on Microsoft official website. You will need internet access to attend your course. Subscription is for 365 days from your activation date.

Question: How we are able to sell Microsoft E-Learning so cheap?
Answer: We are an Authorized reseller for Microsoft E-Learning Solutions. As a reseller we have special pricing from Microsoft E-learning. You attend Microsoft E-Learning course directly at official Microsoft Elearning website. We only provide you activation key to activate your Microsoft elearning course. Only difference is you save money when you purchase from us.

Question: Can I try one of the course before I purchase?
Answer: Absolutely, There are plenty of courses available to try Free of cost and of course no obligation to purchase. Click here for complete Free Microsoft E-Learning Courses.

Question: Can I get Refund for my Microsoft Elearning purchase?
Answer: Sorry NO! All of our orders are FINAL. There is NO RETURN, NO REFUND, NO EXCHANGE. Once order is processed, everything is FINAL. So If you have any questions, please contact customer service at elearning@solartechlearning.com before you place an order.

Our Price: $199

Add to Cart

Click here for complete Microsoft Mastering Industrial Strength .NET E-learning Solutions.