 |
Courses & Certifications
|
 |
MS2541 Core Data Access with Microsoft Visual Studio 2005
| Course start date: |
23-Feb-2009, 27-Apr-2009, 25-May-2009 |
| Training Location |
9 Denison St, Newcastle West |
| Training Format: |
Classroom |
| Duration: |
3 Days |
| Price: | $1,800.00 Inc GST |
Overview
This three-day instructor-led workshop provides students with the knowledge and skills to develop
data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop
describes how to access and update data in a database by using ADO.NET. The workshop also describes how to
create, read, and write XML data.
Prerequisites
Before attending this workshop, 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
Course Outline
Unit 1: Connecting to Databases and Reading Data
- What Is ADO.NET?
- The Process for Connecting to a Database and Reading Data
- What Is Connection Pooling?
Unit 2: Querying and Updating Databases by Using Commands
- ADO.NET Commands
- The Process for Passing Parameters into Commands
Unit 3: Performing Transactional Operations
- What Is a Transaction?
- The Process for Managing Local Transactions
- The Process for Managing Distributed Transactions
- Isolation Levels
Unit 4: Performing Disconnected Operations Programmatically
- What Is the ADO.NET Disconnected Model?
- The Process for Loading and Saving Data in a DataSet
- What Are DataViews?
|
Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
- Comparing Untyped DataSets with Typed DataSets
- What Are Table Adapters?
- Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
Unit 6: Performing XML Operations on Disconnected Data
- XML Representations of DataSets
- What Are DiffGrams?
Unit 7: Reading and Writing XML Data
- The Process for Serially Reading XML Data
- The Process for Serially Writing XML Data
Unit 8: Processing XML Data by Using DOM
- What Is DOM?
- What Are DOM Trees?
- Types of XML Nodes in a DOM Tree
|
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
|
|
