Admission
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.
Core Data Access with Microsoft Visual Studio 2005
| Exam # |
Duration |
Language |
Level |
Type |
Classroom |
Code |
Fees |
|
-- |
24 |
English |
Professional |
Course |
Classroom |
Cs356 |
0 LE |
Description :
This course 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.
Objectives :
-
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.
Topics :
Connecting to Databases and Reading Data
-
What Is ADO.NET?
-
The Process for Connecting to a Database and Reading Data
-
What Is Connection Pooling?
Querying and Updating Databases by Using Commands
-
ADO.NET Commands
-
The Process for Passing Parameters into Commands
Performing Transactional Operations
-
What Is a Transaction?
-
The Process for Managing Local Transactions
-
The Process for Managing Distributed Transactions
-
Isolation Levels
Performing Disconnected Operations Programmatically
-
What Is the ADO.NET Disconnected Model?
-
The Process for Loading and Saving Data in a DataSet
-
What Are DataViews?
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
Performing XML Operations on Disconnected Data
-
XML Representations of DataSets
-
What Are DiffGrams?
Reading and Writing XML Data
-
The Process for Serially Reading XML Data
-
The Process for Serially Writing XML Data
Processing XML Data by Using DOM
-
What Is DOM?
-
What Are DOM Trees?
-
Types of XML Nodes in a DOM Tree
Recommended Knowledge :
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.
Recommended Course(s) :
|
.NET 2.0 Framework |
|
Visual Basic .NET Core |
|
XML Document Design |
Training Materials :
Microsoft Official Courseware (MOC)
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
•Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Windows Applications
•Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Web Applications
•MCPD: Designing and Developing Windows Applications by Using the Microsoft .NET Framework
•MCPD: Designing and Developing Web-Based Applications by Using the Microsoft .NET Framework
Category :
Programming
The Instructor:
Photoshop CS5-The Missing Manual
Photoshop CS6 For Dummies
Pro .NET Best Practices
Hardening Cisco Routers
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.