Scheduled Training Courses
This Training course can also be run on request as a One to One or a Classroom Booking.
Overview
Course Description:
This two-day instructor-led course provides delegates with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005.
Course Code: 2542 Stage: 1
Duration: 2 Days Level: Introduction
Course Objectives:
This two-day instructor-led course provides delegates 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 course 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, along with course 2541 - Core Data Access with Microsoft Visual Studio 2005, prepares the delegates for exams 070-526 TS: Microsoft .NET Framework 2.0 - Windows Based Client Development and 070-528 TS: Microsoft .NET Framework 2.0 - Web-Based Client Development.
Before attending this course, students must have:
- Have attended or studied Course 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 Content:
- Minimise 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
Follow On Courses:
- 2544 | Advanced Web Application Technologies with Microsoft Visual Studio 2005 (2 Days)
- 2546 | Core Windows Forms Technologies with Microsoft Visual Studio 2005
- 2547 | Advanced Windows Forms Technologies with Microsoft Visual Studio 2005
*BESPOKE COURSE | Course Duration, Level & Duration: Depends On Content & Individuals