Core Data Access with Microsoft Visual Studio 2005(Microsoft Training Course: 2541) - Microsoft Training Courses London South West UK

Exchange Server

Office (inc Access)

SQL Server

Visual Studio .NET

Windows

Web Development

Visual FoxPro

Programming

Business

Knowledge Management

Certification

Learning Options

Reserve a Place
06 May Bath
19 May London
02 Jun Bath
23 Jun London
07 Jul Bath
28 Jul London
04 Aug Bath
26 Aug London
01 Sep Bath
23 Sep London
06 Oct Bath
21 Oct London
03 Nov Bath
18 Nov London
01 Dec Bath
16 Dec London
05 Jan Bath
13 Jan London
02 Feb Bath
02 Feb Bath
02 Feb Bath
10 Feb London
10 Feb London
10 Feb London

View Other Courses in Same Category

Core Data Access with Microsoft Visual Studio 2005 - (Microsoft Training Course: 2541) - 3 days

Target Audience		Pre-requisites
Purpose		Print 2 Page Flyer
Exams		Price Options

COURSE OUTLINE

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

Target Audience: 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. It 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, students must have the following pre-requisites: Ability 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. Ability to program an application using a .NET Framework 2.0 compliant language. Knowledge of making assemblies available to other applications. 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. Purpose: At the end of the course, students 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.

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?
Lab: Connecting to Databases and Reading Data

Skills

Describe the key features of ADO.NET.
Explain the process for connecting to a database and reading data from a database.
Describe the benefits of connection pooling.
Connect to a database.
Save a connection string securely in an application configuration file.
Retrieve data from a database.
Handle connection events and exceptions.

Module 2: Querying and Updating Databases by Using Commands

ADO.NET Commands
The Process for Passing Parameters into Commands
Lab: Querying and Updating Databases by Using Commands

Skills

List the different types of ADO.NET commands.
Explain the process for creating and executing parameterized commands.
Create and run query commands.
Create and run parameterized commands.
Create and run update commands.

Module 3: Performing Transactional Operations

What Is a Transaction?
The Process for Managing Local Transactions
The Process for Managing Distributed Transactions
Isolation Levels
Lab: Performing Transactional Operations

Skills

Describe the concept of transactional operations.
Explain the process for managing a local transaction.
Explain the process for managing a distributed transaction.
Describe the effect of setting the isolation level for a transaction.
Perform data updates within a transaction.
Choose an appropriate isolation level for a transaction.
Enlist in a distributed transaction.

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?
Lab: Performing Disconnected Operations Programmatically

Skills

Describe the ADO.NET disconnected data model.
Explain the process for loading and saving data in a DataSet.
Describe how to use DataViews to provide a view on data.
Create a DataSet programmatically.
Populate and save a DataSet.
Add, modify, and delete data in a DataSet.
Merge DataSets.

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
Lab: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Skills

Explain the differences between untyped DataSets and typed DataSets.
Explain how table adapters work in conjunction with data tables in a typed DataSet.
Describe the process for creating a typed DataSet by using Visual Studio 2005 Wizards.
Create a typed DataSet by using the DataSet Designer.
Load, display, and save data in a typed DataSet.
Add code to a typed DataSet.
Create a typed DataSet by using the Data Source Configuration Wizard.

Module 6: Performing XML Operations on Disconnected Data

XML Representations of DataSets
What Are DiffGrams?
Lab: Performing XML Operations on Disconnected Data

Skills

Describe scenarios in which you can represent a DataSet as XML data.
Explain how a DiffGram retains information about modifications to a DataSet.
Save a DataSet as XML data.
Load a DataSet from XML.
Save and load DataSet schema information.

Module 7: Reading and Writing XML Data

The Process for Serially Reading XML Data
The Process for Serially Writing XML Data
Lab: Reading and Writing XML Data

Skills

Describe the process for serially reading XML data.
Describe the process for serially writing XML data.
Write XML data by using XmlWriter.
Read XML data by using XmlReader.

Module 8: Processing XML Data by Using DOM

What Is DOM?
What Are DOM Trees?
Types of XML Nodes in a DOM Tree
Lab: Processing XML Data by Using DOM

Skills

Explain what DOM is and describe how to process XML data in memory by using DOM.
Explain what a DOM tree is and describe how to represent XML documents as a DOM tree.
List the types of nodes in a DOM tree.
Read XML data by using DOM.
Modify XML data by using DOM.

Microsoft recommends this course in preparation for the following exams:

MCTS: Microsoft .NET Framework 2.0 - Windows-Based Client Development

MCTS: Microsoft .NET Framework 2.0 - Web-Based Client Development

UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft .NET Framework

UPGRADE: MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET Framework

UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1

Price Options ex VAT:

Classroom Training ?	Distance Learning ?	eLearning Options ?	Book Learning ?
£ 1050 (€1491)	£ 674.00 (€957)	-	No Books Supported for Course at present
	Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 01 May 2008