Core & Advanced Data Access with Microsoft Visual Studio 2005

2541/2542 : 5 Day Instructor-Led Workshop

Explore the ADO.NET features for working with data in .NET

This five-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. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. The workshop describes how to XML data. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

Deliverables:
Attendees receive the following items when taking this course:

  • Microsoft courseware 2541 (Core Data Access with Microsoft® Visual Studio® 2005)
  • Microsoft courseware 2542 (Advanced Data Access with Microsoft® Visual Studio® 2005)
  • Interface exclusive student/lab manual
  • Interface Certificate of Achievements for
    • 2541
    • 2542

NOTE: It is strongly recommended for attendees to take the following courses prior to this class (or relevant experience):

Prerequisites:
Before attending this course, students must:

  • Be able to manage a solution environment using the Visual Studio 2005 integrated development environment IDE and tools
  • Understand the .NET Framework 2.0 and the Common Language Runtime
  • Be able to program an application using a .NET Framework 2.0 compliant language
  • Know how to make assemblies available to other applications
  • Have a good understanding of basic relational database concepts
  • Be able to use basic SQL commands
  • Have a good understanding of XML including XML declaration, elements, attributes, and namespaces
  • Be able to explain XML schema concepts

Topics covered:

  • Connecting to databases and reading data
  • Querying and updating databases by using commands
  • Performing transactional operations
  • Performing disconnected operations programmatically
  • Performing disconnected operations by using Visual Studio 2005 Wizards
  • Performing XML operations on disconnected data
  • Reading and writing XML data
  • Processing XML data by using DOM Minimizing and handling databases 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

At course completion:
After completing this course, 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
  • Connect to databases and read data
  • Query and update databases by using commands
  • Perform transactional operations
  • Perform disconnected operations programmatically
  • Perform disconnected operations by using Visual Studio 2005 Wizards
  • Perform XML operations on disconnected data
  • Read and write XML
  • Process XML data by using the document object model DOM