Package Includes:
  • 10 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs
  • Exclusive LearningZone Live Mentor (Value at $195)
    Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
  • Focused on practical solutions to real-world development problems
  • Proven technique- Actual Exam Secrets Review
  • Certification Exam Pass Guarantee
  • Free 1 Year Upgrade Policy
OURexpertText
Richard Hundhausen

Richard Hundhausen -Microsoft Regional Director (MCT, CTT+, MCSD, MCSE, MCDBA)
Richard Hundhausen is the founder of the Idaho Delphi and the Boise Visual Developers User Group (now the Boise Software Developer's Group) . He has been a technical editor and has collaborated on numerous .NET developer study guides for Wiley Gearhead Press, Pinnacle Publishing and New Riders. He has been working in IT for about 20 years, the last 10 as an independent consultant.

Richard is currently a Microsoft Regional Director. He has been the Key Note Speaker and trainer for Microsoft Corp. He presented a series of of Windows 2003 Server and .NET 1.1 training seminars for Microsoft Asia. He has also presented Visual Studio .NET and the .NET architecture to academic audiences in Cambridge, MA (MIT, Harvard, and Boston University) and Houston, TX (Rice, University of Houston, University of Texas, Texas A&M).

Course Features:
Course Outline TXT
Level 1
Course Prerequisites
1.1 Course Outline
Introduction to ADO.NET
1.1 What is ADO.NET
1.2 Data Architectures
1.3 Connected & Disconnected
Environments
1.4 Data Stores
1.5 Demo - ADO.NET Namespaces
1.6 Demo - ADO.NET File Locations
1.7 Data Retrieval & Updates
1.8 ADO vs ADO.NET
1.9 Demo -Web Resources
1.10 Review
Lab - Integrated Development Features
Level 2
Data Source Connections
1.1 Data Providers
1.2 Collection of Classes
1.3 Demo - Connection Class
1.4 Demo - Creating Connections
1.5 Demo - SQL Server Security
1.6 Demo - Dynamic Help
1.7 Demo - Connection Objects
1.8 Demo - Exceptions
1.9 Connection Pools
1.10 Demo - Pool Management Tools
1.11 Demo -Web Resources 2
1.12 Review
Lab - Connect to a Data Source
Level 3
Executing Commands
1.1 Command Object
1.2 Demo - ExecuteScalar
1.3 Demo - Select Statement
1.4 Demo - Execute Non Query
1.5 Demo - Execute Reader
1.6 Demo - Execute XML Reader
1.7 Demo - Adding Parameters
1.8 Demo - Visual Studio .NET
1.9 Demo - Stored Procedures
1.10 Demo - Database Transactions
1.11 Review
Lab Transaction Statements
Level 4
Retrieving Data
1.1 Demo - Data Reader Object 1
1.2 Demo - Schema Table
1.3 Demo - Data Reader Object 2
1.4 Data Binding
1.5 Demo - Output Parameters
1.6 Demo - Multiple Statements
1.7 Review
Lab - Command Objects
Building DataSets
2.1 Dataset Overview
2.2 DataSet Object Model
2.3 Demo - Dataset
2.4 Data Adapter
2.5 Demo - Data Adapter
2.6 Demo - Dataset Schemas
2.7 Demo - Fill Schemas
2.8 Review
Lab - Fill Schemas
Level 5
Extending DataSets
1.1 Demo - Extending DataSets
1.2 Demo - Back & Front End Schemas
1.3 Demo - Custom Expressions
1.4 Demo - Additional Constraints
1.5 Demo - Foreign Key Constraints
1.6 Demo - Setting Foreign Key Rules
1.7 Demo - Data Relations
1.8 Demo - Selecting Data
1.9 Demo - Data View
1.10 Strongly Typed DataSets
1.11 Demo -Typed DataSets
1.12 Review
1.13 Create a DataSet
Level 6
Updating DataSets
1.1 Demo - Updating DataSets
1.2 Demo - Tracking Updates
1.3 Demo - Row State & Data
1.4 Updating Data Sources
1.5 Demo - Data Source Update Code: Option 1
1.6 Demo - Data Source Update Code: Option 2
1.7 Demo - Updating Data Sources
1.8 Demo -Updating Data Errors
1.9 Demo - Detecting Updating Conflicts
1.10 Handling Updating Conflicts
1.11 Minimizing Conflicts
1.12 Demo - Minimizing Conflicts
1.13 Review
Level 7
XML Techniques
1.1 Demo -Writing XML Data
1.2 Demo - Formatting XML
1.3 Demo - Reading XML Data
1.4 Demo -Writing XML Schema
1.5 Demo - reading XML Schema
1.6 XML Data Document
1.7 Demo - XML Data Document
1.8 Demo - Serialization
1.9 Review
Level 8
Application Development
1.1 Demo - Code Generation: Server Explorer
1.2 Demo - Code Generation: Toolbox
1.3 Demo -Writing Code
1.4 Demo - Info Message Event
1.5 Demo - Data Binding
1.6 Demo - DataGrid 1000
1.7 Demo - Updating Data
1.8 Resources
1.9 Review
Level 9
ADO.NET in Web Development
1.1 Stateless Programming Overview
1.2 Demo - Integrated Security
1.3 Demo - Data Binding
1.4 Demo - Data Grid
1.5 Demo - Data View
1.6 Demo - Output Caching 1000
1.7 Demo - Caching API
1.8 Demo - Resources
1.9 Review
Level 10
ADO.NET in XML Web Services
1.1 Web Service Architecture
1.2 Demo - XML Web Service
1.3 Demo - Returning DataSets
1.4 Demo - Passing Parameters
1.5 Demo -Web Service Data Return
1.6 Demo - Consuming Web Services
1.7 Demo - Resources
1.8 Review
1.9 Final Comments