 |
Courses & Certifications
|
 |
MS2542 Advanced Data Access with Microsoft Visual Studio 2005
| Course start date: |
01-Dec-2008, 23-Feb-2009, 27-Apr-2009, 25-May-2009 |
| Training Location |
9 Denison St, Newcastle West |
| Duration: |
2 Days |
| Price: | $1,200.00 Inc GST |
Overview
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.
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.
Course Outline
Unit 1: Minimizing and Handling Database Operation Conflicts
- Why Do Data Conflicts Arise?
- Isolation Levels Available in SQL Server 2005
- Guidelines for Using SQL Server 2005 Isolation Levels
Unit 2: Handling Large Objects
- What Are Binary Large Objects and Character Large Objects?
- The Process for Reading Large Objects from a Database
- The Process for Writing Large Objects to a Database
Unit 3: Enhancing Database Performance
- ADO.NET Enhancements in the .NET Framework 2.0
- SQL Server Provider Statistics
|
Unit 4: Creating Managed Code Objects for SQL Server 2005
- The Benefits of Creating Managed Code Objects
- Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005
- Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005
Unit 5: Querying XML by Using XPath
- The XPath Data Model
- The Process for Selecting and Editing XML Data by Using XPathNavigator
- The Process for Evaluating XPath Expressions by Using XPathNavigator
Unit 6: Transforming XML by Using XSLT Style Sheets
- What Is XSLT?
- The Process for Executing an XSLT Style Sheet
- What Are Extension Objects?
|
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
|
|
