MOC-2389: Programming with Microsoft ADO.NET Training

MOC 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET Training Package Includes

• 10 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
• Printable courseware
• Step-by-step hands-on-labs
• Comprehensive, understandable, and reusable as reference material
• Focused on practical solutions to real-world development problems
• 2 Microsoft Authorized MeasureUp Exam Simulations
• Exclusive LearningZone Live Mentor(Value at £290) Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7)

Course Introduction

ADO.NET is an evolutionary improvement to Microsoft ActiveX Data Objects (ADO) that provides platform interoperability and scalable data access. Using Extensible Markup Language (XML), ADO.NET can ensure the efficient transfer of data to any application on any platform. With Visual Studio .NET, developers program against objects, not tables and columns. ADO.NET features strongly typed programming, enabling developers to quickly write reliable data access code. Learn how to manipulate relational data using Microsoft's new ADO.NET library as you learn valuable techniques for building both Web and Windows applications!

• MCSD Exam 70–305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• MCSD Exam 70–306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• MCSD Exam 70–315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
• MCSD Exam 70–316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
• MCSD Exam 70–310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
• MCSD Exam 70–320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET

List of Course Features

MOC 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET Course Contents
 

Level 1

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