The Region Leader in Professional Hands-On IT TrainingProfessional On-Line IT TrainingYour Trusted Onsite Training Partner
Computer Training at Your Site
IT Training and Certification Guru
MCAD: Visual Basic, MCSA, MCP, MCSD, MCDBA
You Are Here: You Are Here Home >Courses > MCAD-VB Training

2389 - Programming with Microsoft ADO.NET

Part of Microsoft MCAD - VB.NET Training Package
Product Code: RTK-MCAD-2389

"...The training videos are excellent. The extra information - web site references, tips, techniques, and other general information - really made the difference. The classroom-like presentations are superb. I give this product a high endorsement. "
R. Bundy. CTO, Co-Founder
www.SocalNETug.org
The Best Alternative to In-Class Training:
  • Repeat as many times as you want;
  • Full Audio, Video, and Demonstration components;
  • Interactive Hands-on-lab Simulations;
  • Live Mentor;
  • Get answers by chatting with instructor;
  • Exam Simulation Software (get one more below);
  • No "dummy or annoying students" in a class;
  • Schedule at your own pace and time.
Shortcuts to:
  Save hundred of dollars with RTEK 2000!
BUY NOW for only $575.00!
Or choose one or more exams. Retail Price $795.00

This course is a requirement for the following Exam(s):

  • MCAD 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 Framework


Package Includes:

  • 10 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware Save up to 25% on #1 Exam Preparation Software!
  • Exclusive LearningZone Live Mentor Click for Details (Value at $195)
  • Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
  • Interactive Hands-on-lab Simulations. Try out one the labs (demo)...
  • Focused on practical solutions to real-world development problems
  • Proven technique- Actual Exam Secrets Review
  • Free 1 Year Upgrade Policy

The Expert Trainer:

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:
  • Main Menu
    Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
  • PowerPoint
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
  • Controls
    Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
  • Exclusive Learning Zone
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
  • Study Guides
    Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
  • Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
  • Resume Option
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
  • Full Motion Video
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
  • Certificate of Completion
    Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
  • Live Demonstrations
    Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
Course Outline:

Level 1
Net Framework Overview
1.1 Overview of the .NET Framework
1.2 Lab Application Setup
Lab - Skills Measured by Exam 70-305
Using Visual Studio .NET 1h 14m 44s
2.1 Using Microsoft Visual Studio .NET
2.2 Creating an ASP.NET Web App with VB
2.3 ASP.NET Web Application
2.4 Internet Information Services
Lab - Using the Visual Studio.Net IDE
Lab - Internet Information Services (IIS)

Level 2
Using .NET Based Languages
1.1 Runtime Components
1.2 .NET Base Class Library
1.3 Classes and Structures
1.4 Scope and Access Levels
1.5 Garbage Collection
1.6 Choosing a Language
1.7 What are Classes and Components
1.8 Build a Web Application
Lab - Creating a Component

Level 3
ASP.NET Web Forms
1.1 Create a Form
1.2 Using Server Controls
1.3 Demonstration
1.4 HTML Controls
1.5 Adding Controls
1.6 Lab - Creating a Web Form
Lab - Converting HTML Page to a Web Form

Level 4
Adding Code to a .NET Web Form
1.1 Using Events
1.2 Event Procedures
1.3 Create an Event
1.4 Using Page Events
1.5 Post Back Events
1.6 Linking Controls Together
1.7 Linking Controls Examples
1.8 Lab - Adding Functionality
Lab - Handling Events in VB
Tracing in ASP.NET Web Apps
2.1 Tracing in to a Component
2.2 Remote Debugging
2.3 Lab - Tracing in Web Applications
Lab - Remote Debugging

Level 5
Validating User Input
1.1 What is Input Validation
1.2 Spoofing and Malicious Code
1.3 Client and Server-Side Validation
1.4 Validation Controls
1.5 Using Validation Controls
1.6 Adding Validation Controls to a Web Form
1.7 Combining Validation Controls
1.8 Input Validation Controls
1.9 Regular Expression Validator Control
1.10 Demonstration
1.11 Custom Validation Control
1.12 Page Validation
1.13 Validation Summary Control
1.14 Adding Controls
1.15 Review
1.16 Lab - Validating User Input
1.17 Adding Textbox Controls

Creating User Controls
2.1 Adding User Controls
2.2 Adding a User Control
2.3 Demonstration
2.4 How to use a User Control
2.5 How to Insert a User Control

Level 6
Relational Data
1.1 ADO.NET
1.2 Using Namespaces
1.3 ADO.NET Object Model
1.4 Review 1
1.5 Accessing Data with ADO.NET
1.6 Creating a Connection to a Database
1.7 Data Adaptor Object Model
1.8 Demonstration 1
1.9 Generating a DataSet
1.10 Demonstration
1.11 Displaying a DataSet
1.12 Demonstration 3
1.13 Data Grid Control
1.14 Review 2
1.15 Lab - Accessing Relational Data 1
1.16 Summary
Lab - Accessing Relational Data 2

Level 7
Accessing Data with ADO.NET
1.1 introduction to Using ADO.NET
1.2 Using DataSets vs. DataReader
1.3 SQL Server Security
1.4 Creating the Connection
1.5 Demonstration
1.6 Accessing Date with DataSets
1.7 Creating a DataAdapter
1.8 Creating a DataSet
1.9 Programmatically Using a DataSet
1.10 Using a DataView Object
1.11 Binding a DataSet
1.12 Demonstration 2
1.13 Handling Errors
1.14 Storing Relationships
1.15 Creating Relationships
1.16 Navigating Between Tables
1.17 Demonstration 3
1.18 Accessing Data with DataReaders
1.19 What is a DataReader?
1.20 Creating a DataReader
1.21 Reading Data from a DataReader
1.22 Binding a DataReader
1.23 Demonstration4
1.24 Lab - Accessing data with ADO.NET
Lab - Connecting to a Databace
Level 8
Overview of .Net Framework
1.1 What is a Stored Procedure
1.2 Calling Stored Procedures
1.3 Demonstration
1.4 Display Data
1.5 Using Parameters
1.6 Passing Input Parameters
1.7 Output Parameters
1.8 How to Pass Parameters
1.9 Review
1.10 Lab - Calling Stored Procedures
Lab - Displaying Data from a Procedure
Reading and Writing XML Data
2.1 What is XML?
2.2 Why Use XML with Data Sets
2.3 XML Based Methods of DataSet Objects
2.4 Demonstration
2.5 Nested XML Data
2.6 Demonstration2
2.7 Working with XML Data
2.8 Synchronizing a DataSet
2.9 Working with an XML Data Document
2.10 Demonstration3
2.11 Using the XML web Server Control
2.12 Loading and Saving XML Data
2.13 Demonstration 4
2.14 Review
2.15 Lab - Reading XML Data
Lab - Using the XML Web Server Control

Level 9
Creating Web Services
1.1 Overview
1.2 Why Use XML web Services
1.3 Finding and XML web Service
1.4 Calling an XML web Service Using HTTP
1.5 Demonstration 1
1.6 Using Proxy to Call an XML Web Service
1.7 Demonstration 3
1.8 XML Web Service Error Handling
1.9 Demonstration 3
1.10 Creating an XML Web Service
1.11 How to Create and XML Web Service
1.12 XML Web Service Code
1.13 Demonstration
1.14 Lab - Consuming Web Services
1.15 Lab - Exploring an XML Web Service

Managing State
2.1 State Management
2.2 What is State Management
2.3 Types of State Management
2.4 Server Side State Management
2.5 Client Side State Management
2.6 Global. ASAX File
2.7 Application and Session Variables
2.8 Initializing Application Variables
2.9 Demonstration 1
1.10 Variable Duration
2.11 Scalable Storage of Variables
2.12 Saving Variables in a Database
2.13 Cookies and Cookieless Sessions
2.14 Demonstration2
2.15 Retrieving Information from a Cookie
2.16 Using Cookieless Sessions
2.17 Setting up Cookieless Sessions
2.18 Review
2.19 LAB - Storing Application and Session
Lab - Using Cookies to Store Date

Level 10
Configure, Optimize, Deploy
1.1 Securing ASP.NET
1.2 Web Application Security Overview
1.3 Authentication vs. Authorization
1.4 ASP.NET Authentication Methods
1.5 Comparing ASP.NET Authentication Meth
1.6 IIS Authentication Mechanisms
1.7 Demonstration 1
1.8 What is Secure Sockets Layer
1.9 Windows Based Authentication
1.10 How to Enable Windows Authentication
1.11 Enabling Impersonation
1.12 Reading User Information
1.13 Demonstration 2
1.14 Forms Based Authentication
1.15 Overview
1.16 Enable Forms Based Authentication
1.17 Creating a Logon Page
1.18 Demonstration 3
1.19 Passport Authentication Overview
1.20 How Does Passport Work
1.21 Other Passport Resources
1.22 Review
1.23 Lab - Securing a ASP.NET Web Application
Lab - Using Dynamic Properties

Securing a Web Application
2.1 Cache Object Overview
2.2 Cache Object Advantages
2.3 Using a Cache Object
2.4 Removing Cache Object Items
2.5 Demonstration 1
2.6 ASP.NET Output Caching Overview
2.7 Using Page Output Caching
2.8 Demonstration 2
2.9 Fragment Caching
2.10 Configuring
2.11 Configuring Methods
2.12 Demonstration 3
2.13 Data Storage and Recall
2.14 Using Dynamic Properties
2.15 Demonstration 4
2.16 Deploying an ASP.NET Overview
2.17 Web Application Deployment
2.18 Global Assembly Cache
2.19 Updating Web Applications
2.20 Lab - ASP.NET Web Application
Lab - IIS Authentication Mechanisms
Watch the most comprehensive MCAD Certification training program available to help you Master Information Technology. Schedule our instructor led video training at your convenience, never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft Certified Trainers in the industry to help us develop the ultimate training and certification program for you. After many long months and much hard labor we are able to offer you this incredible training course which includes everything you will need to fully prepare for and pass your certification exams.

The superior technology-based course curriculum strictly adheres to all of the Microsoft exam objectives. It is presented to you by leading certification instructors who are concise and engaging in their delivery. You will learn both the theory and practical aspects of the technologies as well as gain insight into the industry with their expert instruction. Each class session is presented in full motion audio/video, with step by step demonstrations, hands on labs and testing modules, to insure that you fully understand the subject matter. You can review each subject as needed to reinforce your knowledge. Exam simulators are included to fully prepare you for the certification exams.

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!

Contact Us:

If you have any question we encourage you to contact us!




Copyright © 1999-2007 RTEK 2000, Inc. The Internet Technology Trainers. All rights reserved. Send your comments and questions to our
. Direct all comments about these pages to our Webmaster. Designed by 800-webdesign.com