Core Data Access with Microsoft Visual Studio 2005

Module 1: Connecting to Databases and Reading Data

Connecting to a Database

Saving a Connection String Securely in an Application Configuration File

Retrieving Data from a Database

Handling Connection Events and Exceptions

Configuring and Using Connection Pooling

Module 2: Querying and Updating Databases by Using Commands

Creating and Running Query Commands

Creating and Running Parameterized Commands

Creating and Running Update Commands

Using Globalized Formats for Storing and Accessing Data (if time permits)

Module 3: Performing Transactional Operations

Performing Data Updates within a Transaction

Choosing an Appropriate Isolation Level for a Transaction

Enlisting in a Distributed Transaction

Managing Transactions in the Data Tier

Module 4: Performing Disconnected Operations Programmatically

Creating a DataSet Programmatically

Populating and Saving a DataSet

Adding, Modifying, and Deleting Data in a DataSet

Merging DataSets

Creating and Using DataViews

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

Creating a Typed DataSet by Using the DataSet Designer

Loading, Displaying, and Saving Data in a Typed DataSet

Adding Code to a Typed DataSet

Creating a Typed DataSet by Using the Data Source Configuration Wizard

Adding Queries to a Table Adapter

Module 6: Performing XML Operations on Disconnected Data

Saving a DataSet as XML Data

Loading a DataSet from XML

Saving and Loading DataSet Schema Information

Module 7: Reading and Writing XML Data

Writing XML Data by Using XmlWriter

Reading XML Data by Using XmlReader

Module 8: Processing XML Data by Using DOM

Reading XML Data by Using DOM

Writing XML Data by Using DOM

Advanced Data Access with Microsoft Visual Studio 2005

Module 1: Minimizing and Handling Database Operation Conflicts

Reading Committed Data by Using Locks

Reading Committed Data by Using Statement-Level Snapshots

Reading Committed Data by Using Transaction-Level Snapshots

Handling Data Concurrency by Using ADO.NET

Module 2: Handling Large Objects

Reading Large Values from SQL Server

Writing Large Values to SQL Server

Conserving Resources When Writing Large Values to SQL Server

Module 3: Enhancing Database Performance

Accessing Multiple Result Sets Concurrently

Performing Asynchronous Data Access Operations

Performing a Batch Update

Performing a Bulk Data Copy

Module 4: Creating Managed Code Objects for SQL Server 2005

Creating Managed Stored Procedures and Triggers

Creating Managed User-Defined Functions

Creating a Managed Aggregate

Creating a Managed User-Defined Type

Importing Existing Assemblies into SQL Server 2005

Module 5: Querying XML by Using XPath

Selecting XML Data by Using XPathNavigator

Evaluating XPath Expressions by Using XPath Navigator

Creating and Using Compiled XPath Expressions

Editing XML Data by Using XPathNavigator

Module 6: Transforming XML by Using XSLT Style Sheets

Transforming an XML Document by Using an XSLT Style Sheet

Resolving External Resources During XSLT Processing

Passing Parameters into an XSLT Style Sheet

Creating and Using Extension Objects

Core Web Application Technologies with Microsoft Visual Studio 2005

Module 1: Creating a Web Application

Creating a New Web Application

Configuring and Building a Web Application

Module 2: Programming a Web Application

Implementing Non-Default Event Handlers

Detecting Browser Capabilities and Setting Page Header Properties

Handling Page-Level Exceptions

Module 3: Adding and Configuring Server Controls

Building Graphical User Interfaces with HTML Controls

Building Graphical User Interfaces with Web Server Controls

Programming Web Server Controls and Working with Postbacks

Module 4: Creating a Common Layout by Using Master Pages

Designing a Master Page

Adding and Configuring Content Pages

Designing Nested Master Pages

Module 5: Managing State for a Web Application

Configuring ViewState Properties for Web Server Controls

Storing and Retrieving Application and Session State

Implementing Out-of-Process Session State

Storing and Managing State Data in the Cache Object

Module 6: Accessing and Displaying Data

Creating and Retrieving Database Connections

Accessing Data by Using SqlDataSource Controls and Data Controls

Accessing Objects as Data with ObjectDataSource Controls

Accessing XML Data by Using XmlDataSource Controls

Module 7: Controlling Access to a Web Application

Configuring Authentication and Authorization for a Web Application

Implementing a Membership Registration Page

Implementing a Login Page and Adding Login Controls

Creating a Membership Management Administrative User Interface

Module 8: Deploying a Web Application

Deploying a Web Application by Using the Copy Web Site Utility

Precompiling and Deploying a Web Application by Using the Publish Web Site Utility

Building a Windows Installer Package for Deploying a Web Application

Module 9: Making Web Applications Available to Mobile Devices

Managing Redirection for Mobile Devices

Designing and Implementing a Mobile Web Form

Designing Device-Specific Features for a Mobile Web Application

Browsing a Mobile Web Application with Specific Device Emulators

Advanced Web Application Technologies with Microsoft Visual Studio 2005

Module 1: Building Dynamic Web Applications

Dynamically Adding and Configuring Controls

Dynamically Applying Master Pages

Adding Localization Features

Dynamically Configuring Web Applications

Module 2: Creating Controls for Web Applications

Creating User Controls

Creating Custom Web Server Controls

Creating Composite Web Server Controls

Creating Templated Controls

Module 3: Optimizing Web Application Performance

Accessing the Page Scripting Object Model

Implementing ASP.NET Caching Techniques

Implementing Tracing and Instrumentation Techniques in Web Applications

Implementing Asynchronous Processing in Web Applications

Module 4: Implementing Personalization and Themes in Web

Applications

Configuring Personalization

Implementing Personalization Functionality

Adding Themes to the Web Application

Implementing Personalized Themes

Module 5: Building Web Part Pages and Web Parts

Creating a Web Part Page

Creating a Web Part

Creating Connected Web Parts