2542 Advanced Data Access with Microsoft Visual Studio 2005 - Details
Description:
This 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.More Information
Duration
2 days
Who Should Attend
This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.
Prerequisites
2541 Core Data Access with Microsoft Visual Studio 2005.Know how to use delegates. Be able to use database stored procedures, triggers, and aggregates.
On Completion
After completing this workshop, students will be able to: - Minimize and handle database operation conflicts. - Handle large objects. - Enhance database performance. - Create managed code objects for SQL Server 2005. - Query XML by using XPath. - Transform XML by using XSLT style sheets.
Outline
| Lesson 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 |
| Lesson 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 |
| Lesson 3: Enhancing Database Performance |
| ADO.NET Enhancements in the .NET Framework 2.0 SQL Server Provider Statistics |
| Lesson 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 |
| Lesson 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 |
| Lesson 6: Transforming XML by Using XSLT Style Sheets |
| What Is XSLT? The Process for Executing an XSLT Style Sheet What Are Extension Objects? |
Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.
Contact us to learn more about our courses and certifications.