(Learning segments)

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 Windows Forms with Microsoft Visual Studio 2005

Module 1: Creating a Simple Windows Forms Application

Adding and Configuring Windows Forms and Controls

Creating Event Handlers and Monitoring Events

Adding Controls and Handlers at Run Time

Adding a Form Keyboard Handler

Module 2: Configuring Standard Controls

Creating the EmployeeViewer Form

Creating the ReportGenerator Form

Creating the ReportGeneratorHelp Form

Module 3: Building Menus

Creating and Configuring a MenuStrip Control

Creating and Configuring a ContextMenuStrip Component

Hiding and Disabling a ToolStripMenuItem

Creating and Configuring a ToolStripComboBox

Module 4: Displaying and Editing Data by Using Data-Bound Controls

Adding a Data Source to a Project

Binding Data to a Control

Creating a Bound Form by Using the BindingSource and BindingNavigator Components

Displaying Data by Using the DataGridView Control

Binding to Data at Run Time

Module 5: Providing User Assistance and Enhancing Usability

Adding and Configuring User Assistance Controls

Implementing Accessibility Features

Implementing Globalization and Localization

Running a Procedure at Set Intervals

Displaying Data Source Errors

Module 6: Creating Consistent Applications by Using Dialog Boxes and Forms Inheritance

Adding and Configuring Dialog Box Components

Creating a Custom Dialog Box

Implementing Windows Forms Inheritance

Modifying an Existing Form to Inherit from a Base Form

Module 7: Printing Content and Creating Reports

Adding Print Capability to a Windows Forms Application

Implementing Reporting by Using the CrystalReportViewer Component

Module 8: Performing Asynchronous Tasks by Using the BackgroundWorker Component

Running and Canceling a Background Process by Using the BackgroundWorker Component

Module 9: Deploying Applications by Using ClickOnce

Publishing a ClickOnce Application

Installing and Testing a ClickOnce Application

Advanced Windows Forms with Microsoft Visual Studio 2005

Module 1: Building MDI Applications

Creating MDI Parent and Child Forms

Displaying and Comparing Information on MDI Child Forms

Implementing Menu Merging in MDI Applications

Module 2: Customizing Windows Forms and Controls

Creating a Control That Inherits from an Existing Control

Creating a Nonrectangular Windows Form

Creating a Custom User Control

Module 3: Creating Customized Print Components

Printing a Report by Using GDI+

Creating a Customized Print Preview Dialog Box

Module 4: Performing Drag-and-Drop Operations and

Implementing Clipboard Support

Implementing Drag-and-Drop Functionality in a Windows Forms Application

Adding Clipboard Support to an Application

Performing Drag-and-Drop Operations by Using TextBox and PictureBox Controls

Module 5: Performing Asynchronous Tasks by Using Multithreaded Techniques

Loading a Bitmap Asynchronously

Performing Calculations by Using Multithreading

Module 6: Enhancing the Presentation of Windows Forms

Applications

Programming the DataGridView Control

Viewing and Persisting Application Settings by Using the PropertyGrid Control

Implementing a User Interface in the Style of Outlook by Using RAD Features

	Full motion video Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor. Instructor-Led Training Combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media DVD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.

	E-BOOKS (PDF) We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.Supplied on DVD for DVD courses or downloadable for Online Courses.

	Practice Exam Simulators We offer exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam! Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test. If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.


	Hands-on Lab Simulation Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..


	Free Upgrades A unique benefit of the our Learning System, is that it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive DVD's for up to 1 year from date of original purchase? absolutely free!