Course Schedule:
| Location |
Days |
Course dates |
Duration |
Cost (ex GST) |
Availability |
Enrol Here |
| City |
Mon - Tue |
24 - 26 Nov 2008 |
3 days |
1620.00 |
Open |
Corporate Group / Individual |
Overview:
This course will provide you with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. It 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
Learning method:
This course will be presented in a lecture/tutorial sessions using a combination of lectures, group discussions and practical exercises. Each student will be provided with a comprehensive set of course notes.
This hands-on course combines exercises and practical work to solidify your learning.
What can you expect to gain from this course?
This course 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.
Pre-requisites:
Before attending this course, you 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
- 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
What can you expect to gain from this course?
After completing this course, you will be able to:
- 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 data
- process XML data by using the Document Object Model DOM
Course content:
Module 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?
Module 2:Querying and Updating Databases by Using Commands
- ADO.NET Commands
- The Process for Passing Parameters into Commands
Module 3:Performing Transactional Operations
- What Is a Transaction?
- The Process for Managing Local Transactions
- The Process for Managing Distributed Transactions
- Isolation Levels
Module 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?
Module 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
Module 6:Performing XML Operations on Disconnected Data
- XML Representations of DataSets
- What Are DiffGrams?
Module 7:Reading and Writing XML Data
- The Process for Serially Reading XML Data
- The Process for Serially Writing XML Data
Module 8:Processing XML Data by Using DOM
- What Is DOM?
- What Are DOM Trees?
- Types of XML Nodes in a DOM Tree