Untitled Document

2542: Advanced Data Access with Microsoft Visual Studio 2005

List Price:	Special Price:
~~$795.00~~

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

This instructor-led course 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 course also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

This course is a requirement for the following Exam(s) :

MCTS Exam 70-526 : Microsoft .NET Framework 2.0 - Windows-Based Client Development
MCTS Exam 70-528 : Microsoft .NET Framework 2.0 - Web-Based Client Development
MCPD Exam 70-551 : MCPD Web Developer Upgrade Training
MCPD Exam 70-552 : MCPD Windows Developer Upgrade Training.

Package Includes:

6 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Hands-On Lab Demonstrations
Exclusive LearningZone Live Mentor (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Microsoft Officially Authorized Exam Simulations
Proven technique- Actual Exam Secrets Review
Certification Exam Pass Guarantee
Free 1 Year Upgrade Policy

Jeff Cook - MCT, MCSD, MCAD, MCP, A+ and MCDBA
He has been a Microsoft Certified Trainer for 6 years and has been in the training industry for 9 years. Also, he has developed mid-level and Enterprise level applications allowing him to implement a large amount of "real world" experience into his training.

Jeff has been an employee of Premier Knowledge Solutions, Inc since June 1998 with over 1,400 days of teaching experience and an average student survey score of 9.62 on a 10 point scale.

Course Features:

Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
Microsoft Authorized Practice Exams
Our Training includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
Labs
Gain hands-on knowledge through watching the instructor actually perform the lab in a video-based demonstration. Following the conclusion, students can mimic the previously performed actions and apply them in the "real world".
Certificate of Completion
Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving an official Distance Education Certificate of Completion.

Module 1 - Minimizing and Handling Database Operation Conflicts

Minimizing and Handling Database Operation Conflicts
Demo - Show Example of Database Conflict
Why Do Data Conflicts Arise?
Optimistic
Pessimistic
“Last One In Wins”
Demo - Show Effects of Locks
Isolation Levels in SQL Server 2005
Isolation Levels Matrix
Using SQL Server 2005 Isolation Levels
Using ADO.NET to Handle Conflicts
Demo - Handle Database Concurrency Issues
Lab Demonstration 1
Module 1 Review

Module 2 - Handling Large Objects

Handling Large Objects
Binary Large Objects
Character Large Objects
Large Value Data Types
Reading Large Objects from a Database
Demo - Read Large Objects
Writing Large Objects to a Database
Demo -Write Large Object to a Database
Lab Demonstration 2
Module 2 Review

Module 3 - Transactional Operations

Enhancing Database Performance
ADO.NET Enhancements in the .NET Framework 2.0
MARS
Demo - How MARS Works
Asynchronous Operations
Demo - Show Effects of Asynchronous Operations
Demo - Show Batch Dataset Update
Demo - Show Bulk Data Copy
SQL Server Provider Statistics
Demo - Setting up a Performance Trace
Lab Demonstration 3
Module 3 Review

Module 4 - Creating Managed Code Objects for SQL Server 2005

Creating Managed Code Objects for SQL Server 2005
.NET and SQL Server 2005
Managed Objects
Demo - Create/Deploy a Stored Procedure & Function to SQL Server
The Benefits of Creating Managed Code Objects
Importing an Existing Assembly into SQL Server 2005
Implement Managed Code Objects in SQL Server 2005
Demo - Create SQL Project
Lab Demonstration 4
Module 4 Review

Module 5 - Querying XML by Using Xpath

XPath Data Model
Node Types
Selecting XML Data Using XPathNavigator
Demo - Use XPathNavigator to Select Data
Editing XML Data Using XPathNavigator
Demo - Use XPathNavigator to Edit Data
Evaluating XPath Expressions Using XPathNavigator
Demo - Use XPathNavigator to Evaluate Data
Module 5 Review

Module 6 - Transforming XML by Using XSLT Style Sheets

Transforming XML by Using XSLT Style Sheets
What is XSLT?
Demo - Create and show XSLT Style Sheet
Using an XSLT Style Sheet
Executing an XSLT Style Sheet
Executing an XSLT Style Sheet Sample
Demo - Use XSLT Style Sheet
Add Parameters
XslCompiledTransform Object
Using the Resolver
XslCompiledTransform Object Cont.
Demo - Use Parameters and XslCompiledTransform
Extension Objects
Create Extension
Benefits and Drawbacks of Extension Objects
Demo - Create and Use Extension Object
Lab Demonstration 5
Module 6 Review
Course Closure