Provided by: Boston University Corporate Education Center Core Data Access with Microsoft Visual Studio 2005 Click here for more information or to take this course

---

---

home  : Unfiled

Training Provided by Boston University Corporate Education Center

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.

Audience
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.

At Workshop Completion

After completing this workshop, 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.
 

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
 

Workshop Outline
Unit 1: Connecting to Databases and Reading Data

This unit introduces the fundamental skills required to connect to a database and read data from the database. It describes how to use ADO.NET data providers to connect to various different kinds of databases, and how to execute a query that returns a scalar value from the database. It also describes how to use connection pooling to achieve scalability, and how to handle connection events and exceptions.

Lessons

What Is ADO.NET?
 
The Process for Connecting to a Database and Reading Data
 
What Is Connection Pooling?
 

Lab 1: Connecting to Databases and Reading Data

Exercise 1. Connecting to a Database
 
Exercise 2. Saving a Connection String Securely in an Application Configuration File
 
Exercise 3. Retrieving Data from a Database
 
Exercise 4. Handling Connection Events and Exceptions
 
Exercise 5. Configuring and Using Connection Pooling (if time permits)
 

After completing this unit, students will be able to:

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.
 

Unit 2: Querying and Updating Databases by Using Commands

This unit describes how to create and run commands that return a scalar value, return a result set, update data in the database, or update the schema of the database. It also describes how to create and run parameterized commands.

Lessons

ADO.NET Commands
 
The Process for Passing Parameters into Commands
 

Lab 2: Querying and Updating Databases by Using Commands

Exercise 1. Creating and Running Query Commands
 
Exercise 2. Creating and Running Parameterized Commands
 
Exercise 3. Creating and Running Update Commands
 
Exercise 4. Using Globalized Formats for Storing and Accessing Data (if time permits)
 

After completing this unit, students will be able to:

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.
 

Unit 3: Performing Transactional Operations

This unit describes how to manage transactions in a .NET application at the middle tier. It describes how to write ADO.NET code to start, commit, and rollback local transactions. It also describes how to specify an appropriate isolation level for a transaction, and how to enlist in distributed transactions.

Lessons

What Is a Transaction?
 
The Process for Managing Local Transactions
 
The Process for Managing Distributed Transactions
 
Isolation Levels
 

Lab 3: Performing Transactional Operations

Exercise 1. Performing Data Updates within a Transaction
 
Exercise 2. Choosing an Appropriate Isolation Level for a Transaction
 
Exercise 3. Enlisting in a Distributed Transaction
 
Exercise 4. Managing Transactions in the Data Tier (if time permits)
 

After completing this unit, students will be able to:

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.
 

Unit 4: Performing Disconnected Operations Programmatically

This unit describes how to create and use DataSets programmatically. It describes how to create DataSet, DataTable, and DataColumn objects, how to populate a DataSet manually, and how to load and save data by using a DataAdapter. It also describes how to create in-memory views on data by using a DataView.

Lessons

What Is the ADO.NET Disconnected Model?
 
The Process for Loading and Saving Data in a DataSet
 
What Are DataViews?
 

Lab 4: Performing Disconnected Operations Programmatically

Exercise 1. Creating a DataSet Programmatically
 
Exercise 2. Populating and Saving a DataSet
 
Exercise 3. Adding, Modifying, and Deleting Data in a DataSet
 
Exercise 4. Merging DataSets
 
Exercise 5. Creating and Using DataViews (if time permits)
 

After completing this unit, students will be able to:

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.
 

Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

This unit describes how to create typed DataSets, DataAdapters, and TableAdapters by using the TableAdapter Configuration Wizard and the Data Source Configuration Wizard in Visual Studio 2005. It also describes how to write type-safe code to access data in a typed DataSet.

Lessons

Comparing Untyped DataSets with Typed DataSets
 
What Are Table Adapters?
 
Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
 

Lab 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Exercise 1. Creating a Typed DataSet by Using the DataSet Designer
 
Exercise 2. Loading, Displaying, and Saving Data in a Typed DataSet
 
Exercise 3. Adding Code to a Typed DataSet
 
Exercise 4. Creating a Typed DataSet by Using the Data Source Configuration Wizard
 
Exercise 5. Adding Queries to a Table Adapter (if time permits)
 

After completing this unit, students will be able to:

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.
 

Unit 6: Performing XML Operations on Disconnected Data

This unit describes how to read and write DataSets in XML format. It describes how to read and write data only, schema only, or a combination of the two. It also describes how to read and write a DataSet as a DiffGram, so that modifications to the data can be retained when the DataSet is serialized to XML format.

Lessons

XML Representations of DataSets
 
What Are DiffGrams?
 

Lab 6: Performing XML Operations on Disconnected Data

Exercise 1. Saving a DataSet as XML Data
 
Exercise 2. Loading a DataSet from XML
 
Exercise 3. Saving and Loading DataSet Schema Information
 

After completing this unit, students will be able to:

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.
 

Unit 7: Reading and Writing XML Data

This unit describes how to use the XmlReader and XmlWriter classes to serially read and write XML data. It describes how to read elements, attributes, and text content in an XML document, and perform validation against an XML schema. It also describes how to create an XML document and write elements, attributes, namespace declarations, and text content.

Lessons

The Process for Serially Reading XML Data
 
The Process for Serially Writing XML Data
 

Lab 7: Reading and Writing XML Data

Exercise 1. Writing XML Data by Using XmlWriter
 
Exercise 2. Reading XML Data by Using XmlReader
 

After completing this unit, students will be able to:

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.
 

Unit 8: Processing XML Data by Using DOM

This unit describes how to process XML data in memory by using the Document Object Model (DOM). It describes how to load an XML document into a DOM tree, and validate the XML document against an XML schema. It also describes how to read existing XML content, modify XML content, and save the DOM tree to an XML document.

Lessons

What Is DOM?
 
What Are DOM Trees?
 
Types of XML Nodes in a DOM Tree
 

Lab 8: Processing XML Data by Using DOM

Exercise 1. Reading XML Data by Using DOM
 
Exercise 2. Writing XML Data by Using DOM
 

After completing this unit, students will be able to:

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.
 

Training Avaliability and Delivery

This is primarily ilt training This class may be available at a classroom in Boston, MA, or at one of these training facilities: Braintree, MA Boston, MA Tyngsboro, MA Boston, MA Waltham, MA Peterborough, NH Contact Boston University Corporate Education Center for more information

Schedule: 3 days Training Presented in: English

About Boston University Corporate Education Center - Training Provider

More Technology Training from Boston University Corporate Education Center

• A+ Boot Camp
• Accelerated ITIL Foundation
• Access 2003 Level I
• Access 2003 Level II
• Access 2003 Level III
• Access 2003 Level IV
• Administering a Microsoft SQL Server 2000 Database
• Administering Cisco Routers
• Adobe Photoshop 7.0
• Advanced C++ Programming
• Advanced Cisco Routing
• Advanced Computer and Network Support
• Advanced Java Programming
• Apache Web Services and Database Connectivity
• C++ for non-C Programmers
• Cartographic Issues: Map Projections and Map Design
• Certificate in Applied Business Analysis Evenings Saturdays
• Certified Pen Testing Specialist (CPTS)
• Certified Wireless Security Professional
• Cisco Certified Network Associate CCNA Boot Camp
• Cisco Network Final Project
• Cisco Networking Fundamentals
• Cisco Switching Technologies
• Cisco Voice Over IP (CVOICE)
• Cisco? Certified Network Professional (CCNP?) Boot Camp
• Citrix MetaFrame Presentation Server 3.0: Management and Maintenance
• Citrix MetaFrame Presentation Server 3.0: Troubleshooting Enterprise Environments
• Citrix MetaFrame Presentation Server 3.0: Enterprise Edition Administration
• Citrix MetaFrame Presentation Server 3.0: Upgrade from XP
• Citrix MetaFrame Secure Access Manager 2.2: Administration
• Citrix MetaFrame XP Presentation Server, Feature Release 3: Administration
• Citrix Presentation Server 4.0: Administration
• COBOL Programming Workshop
• Computer Support Specialist
• Configuration and Troubleshooting Project
• Configuring Windows Vista Application and Tools
• Customizing Microsoft SharePoint Products and Technologies 2003
• Design Patterns in Java
• Designing & Implementing OLAP Solutions Using Microsoft SQL Server 2000
• Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure
• Designing Microsoft SQL Server 2005 Server-Side Solutions
• Designing Security for Microsoft Networks
• Designing the Data Tier for Microsoft SQL Server 2005
• Developing Java Web Services
• Developing Microsoft NET Applications for Windows Visual Basic NET
• Developing Microsoft NET Applications for Windows Visual C NET
• Developing Web Applications Using Microsoft Visual Studio NET
• Developing XML Web Services Using Microsoft ASP.NET
• End-to-End BA Workshop
• Enterprise JavaBean Programming
• Excel 2003 Level I
• Excel 2003 Level II
• Excel 2003 Level III
• Exchanging & Transforming Data Using XML and XSLT
• Facilitating JAD Sessions
• Gathering and Documenting User Requirements with Use Cases
• GIS Project Development and Process
• Host Security
• HTML / CSS (Cascading Style Sheets)
• Implementing a Microsoft SQL Server 2005 Database
• Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts
• Implementing and Administering Security in a Microsoft Windows Server 2003 Network
• Implementing and Managing Microsoft Exchange Server 2003
• Implementing and Supporting Microsoft Windows XP Professional
• Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
• Implementing Microsoft Internet Security and Acceleration Server 2004
• Installing Administering and Configuring Microsoft Windows XP Professional
• Installing and Configuring the Windows Vista Operating System
• Interconnecting Cisco Network Devices ICND
• Intermediate Java Programming
• Internet Research
• Internetwork Troubleshooting
• Introduction to C Programming with Microsoft NET
• Introduction to Cisco Networking Technologies INTRO
• Introduction to Computer Maintenance
• Introduction to Computers
• Introduction to GIS Software: ESRI ArcGIS 9.x
• Introduction to GIS Technologies
• Introduction to Java Programming
• Introduction to Java Using WebSphere Studio Application Developer
• Introduction to Microsoft Visual C# Programming for Microsoft.Net Platform
• Introduction to Oracle9i: SQL
• Introduction to Programming
• Introduction to Relational Databases
• Introduction to Shell Scripting
• Introduction to Visual Basic NET Programming with Microsoft NET
• Introduction to XML
• Introduction to XML and the Microsoft .NET Platform
• Iterative Development and the Business Analyst
• ITIL Foundation Certification
• ITIL Practitioner Release and Control IPRC Certification
• ITIL Service Management Essentials
• ITIL Service Manager
• Jakarta Struts
• Jakarta Struts
• Java Servlets
• JavaServer Pages
• Learning Perl
• Linux Fundamentals
• Linux Fundamentals Boot Camp
• Linux Networking Services
• Linux System Administration
• Linux System and Network Administration Boot Camp
• Macromedia Dreamweaver MX
• Macromedia Flash MX
• Maintaining a Microsoft SQL Server 2005 Database
• Maintaining a Microsoft Windows Server 2003 Environment
• Managing a Microsoft Windows Server 2003 Environment
• Managing and Maintaining a Microsoft Windows Server 2003 Environment
• Managing Microsoft Systems Management Server 2003
• Mastering UNIX Shell Scripts
• Microsoft Programming with ADO.NET
• Microsoft Access 2003
• Microsoft Excel 2003
• Microsoft Outlook 2003
• Microsoft PowerPoint 2003
• Microsoft Security Guidance Training for Developers
• Microsoft Windows Server 2003 MCSA Boot Camp
• Microsoft Windows Server 2003 MCSE Boot Camp
• Microsoft Windows Server 2003 MCSE Upgrade Boot Camp
• Microsoft Word 2003
• Microsoft? Visual Basic? Scripting Edition and Microsoft Windows? Script Host Essentials
• Midterm Project
• MVS JCL for Non-Programmers
• Net Boot Camp
• Net+
• Network Security
• Object and Data Modeling Workshop
• Office Administrator Project
• Operating System Fundamentals
• Operating Systems Project
• Oracle 9i Data Warehousing Fundamentals
• Oracle 9i Forms Developer - Build Internet Applications
• Oracle 9i Reports Developer - Build Reports
• Oracle 9i: Program with PL/SQL
• Oracle Database 10g Administration Workshop I
• Oracle Database 10g Administration Workshop II
• Oracle Database 10g Introduction to SQL
• Oracle Database 10g Program with PL SQL
• Oracle Database 10g: New Features for Administrators
• Oracle9i Database Performance Tuning
• Oracle9i DBA Fundamentals I
• Oracle9i DBA Fundamentals II
• Outlook 2003 Level 1
• Outlook 2003 Level II
• Outlook 2003 Level III
• PHP 4 Introduction
• Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
• Planning Implementing and Maintaining Microsoft Windows Server 2003 Active Directory Infrastructure
• PowerPoint 2003 Level 1
• PowerPoint 2003 Level II
• Programming a Microsoft SQL Server 2000 Database
• Programming in C
• Programming the Microsoft Net Framework with Microsoft Visual C
• Programming the Microsoft Net Framework with Visual Basic Net
• Programming with Microsoft Visual Basic .NET
• Quality Assurance for the Business Analyst
• Querying Microsoft SQL Server 2000 with Transact-SQL
• Securing Cisco Network Devices (SND) v1.0
• Securing Networks with PIX and ASA (SNPA) v4.0
• Security
• Spatial Analysis Using GIS
• Spatial Databases and Database Development
• Supporting Microsoft Operating Systems
• Supporting Users Running Applications on a Microsoft Windows XP Operating System
• Supporting Users Running the Microsoft Windows XP Operating System
• The Business Analyst s Crash Course
• The JSP Standard Tag Library
• Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
• Updating Your Database Administration Skills to Microsoft SQL Server 2005
• Updating Your Database Development Skills to Microsoft SQL Server 2005
• Web Site Design
• WebSphere Application Server v5.1 Administration
• WebSphere v5 Performance Tuning Tools and Methodology Workshop
• What's New in Microsoft Visual Studio 2005 for existing Visual Studio .NET Developers(Workshop)
• Wireless LAN Administration
• Word 2003 Level I
• Word 2003 Level II
• Word 2003 Level III
• Workflow Modeling and State Machines
• XML Design and Implementation
• XML Programming Using Java