Book your MS2542 Advanced Data Access with Microsoft Visual Studio 2005 Training Course
This two day course is being run five times between Thursday 16th February 2012 and Thursday 7th June 2012 in Bath, London,
Book this course with us today from as little as £1,140.00 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
See all courses by the manufacturer MicrosoftSee all courses provided by F1 Computing
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Thursday 16 February 2012 | Bath |  | Save £60.00 | £1,140.00+VAT | |
| Thursday 01 March 2012 | London | | Save £60.00 | £1,140.00+VAT | |
| Monday 02 April 2012 | London | | Save £60.00 | £1,140.00+VAT | |
| Thursday 03 May 2012 | London | | Save £60.00 | £1,140.00+VAT | |
| Thursday 07 June 2012 | London | | Save £60.00 | £1,140.00+VAT |
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course OutlineSummary:
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.
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.
Objectives:
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.
Unit 1: Minimizing and Handling Database Operation Conflicts
This unit describes how to minimize data access conflicts, and how to handle these conflicts when they occur. It describes how to implement optimistic concurrency in the ADO.NET
disconnected model, and how to implement optimistic concurrency by using the various isolation levels available in SQL Server 2005.
Lessons
- Why Do Data Conflicts Arise?
- Isolation Levels Available in SQL Server 2005
- Guidelines for Using SQL Server 2005 Isolation Levels
After completing this unit, students will be able to:
- Explain why data conflicts arise.
- Describe the isolation levels that are available in SQL Server 2005.
- Describe the guidelines for using SQL Server 2005 isolation levels.
- Read committed data by using locks.
- Read committed data by using statement-level snapshots.
- Read committed data by using transaction-level snapshots.
- Handle data concurrency by using ADO.NET.
Unit 2: Handling Large Objects
This unit describes how to read and write large values efficiently to a SQL Server database. It describes how to read large binary values and large text values by using SequentialAccess for a SqlDataReader. It also describes how to write large binary values and large text values, and how to conserve resources when writing large values.
Lessons
- 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
After completing this unit, students will be able to:
- Describe binary large objects and character large objects.
- Explain the process for reading large objects from a database.
- Explain the process for writing large objects to a database.
- Read large values from SQL Server.
- Write large values to SQL Server.
- Conserve resources when writing large values to SQL Server.
Unit 3: Enhancing Database Performance
This unit describes how to enhance database performance by using new features available in ADO.NET 2.0. The unit describes how to perform asynchronous data operations, create multiple active result sets, perform batch updates, and perform bulk copies.
Lessons
- ADO.NET Enhancements in the .NET Framework 2.0
- SQL Server Provider Statistics
After completing this unit, students will be able to:
- Describe the ADO.NET enhancements in Microsoft .NET Framework 2.0.
- Describe the support for run-time statistics in the .NET Framework Data Provider for SQL Server.
- Access multiple result sets concurrently.
- Perform asynchronous data access operations.
- Perform a batch update.
- Perform a bulk data copy.
Unit 4: Creating Managed Code Objects for SQL Server 2005
This unit describes how to create database objects for SQL Server 2005 in a .NET Framework programming language. It describes how to create stored procedures, triggers, user-defined functions, aggregates, and user-defined types in managed code. Additionally, it describes how to deploy an assembly that contains managed objects into SQL Server 2005, and how to declare database objects to reference the managed objects.
Lessons
- 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
After completing this unit, students will be able to:
- Describe the benefits of creating managed code objects for SQL Server 2005.
- Explain the process for importing an existing assembly into SQL Server 2005.
- Explain the process for implementing managed code objects in SQL Server 2005.
- Create managed stored procedures and triggers.
- Create managed user-defined functions.
- Create a managed aggregate.
- Create a managed user-defined type.
Unit 5: Querying XML by Using Xpath
This unit describes how to use Xpath in a .NET Framework application. It describes how to create an XPathNavigator object on an XML document, and how to locate content and evaluate expressions by using the XPathNavigator object. Additionally, it describes how to edit XML data by using the XPathNavigator object.
Lessons
- The Xpath Data Model
- The Process for Selecting and Editing XML Data by Using XPathNavigator
- The Process for Evaluating Xpath Expressions by Using XPathNavigator
After completing this unit, students will be able to:
- Describe the Xpath data model.
- Explain the process for selecting and editing XML data by using XPathNavigator.
- Explain the process for evaluating Xpath expressions by using XPathNavigator.
- Select XML data by using XPathNavigator.
- Evaluate Xpath expressions by using XPathNavigator.
- Create and use compiled Xpath expressions.
- Edit XML data by using XPathNavigator.
Unit 6: Transforming XML by Using XSLT Style Sheets
This unit describes how to transform XML documents in a .NET Framework application. It introduces how to load an XSLT style sheet in an application, and how to execute the style sheet to transform an XML document. The unit also describes how to pass parameters into a style sheet, and how to create and use extension objects.
Lessons
- What Is XSLT?
- The Process for Executing an XSLT Style Sheet
- What Are Extension Objects?
After completing this unit, students will be able to:
- Describe the purpose of XSLT.
- Explain the process for executing an XSLT style sheet.
- Describe the purpose of extension objects.
- Transform an XML document by using an XSLT style sheet.
- Resolve external resources during XSLT processing.
- Pass parameters into an XSLT style sheet.
- Create and use extension objects
Description:
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.
F1 Computing
F1 Computing have 20 years of experience in developing their CRM product, Pro-ACTION, is now used to build and deploy solutions for customers.
F1 Computing aim to meet the requirements of your company and arm you and your employees with the skills to make your business a success. Through many years of refining their courses, F1 computing have established a name for themselves, as well as a great relationship with their clients.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.