2542 - Advanced Data Access with Microsoft Visual Studio
ObjectivesDDLS has enhanced the standard MOC course to enable students using Visual Studio 2003, 2005, 2008 and .Net framework 2.0 and 3.5 to benefit from this course. IMPORTANT - The content of these courses is still applicable and current for developers using Visual Studio 2008 and .Net 3.5 even though the courses were written based on earlier releases. 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. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET and Microsoft SQL Server. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT). ***When students sit this .Net course they will also receive complimentary materials that have been specifically prepared by DDLS instructors to supplement the Microsoft courseware. These supplementary materials are exclusively created for DDLS Microsoft .NET students and cannot be purchased anywhere else***
Entry requirementsBefore attending this workshop, students must: • Have attended or studied Workshop 2541, Core Data Access with Microsoft Visual Studio, 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.
Academic title2542 - Advanced Data Access with Microsoft Visual Studio
Course descriptionSkills Gained:
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.
Key Topics:
• Minimizing and Handling Database Operation Conflicts
• Handling Large Objects
• Enhancing Database Performance
• Creating Managed Code Objects for SQL Server 2005
• Querying XML by Using XPath
• Transforming XML by Using XSLT Style Sheets
Target Audience:
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.