2389 - Programming with Microsoft ADO.NET Training
Untitled Document
Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft.NET Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to fully prepare for and pass your 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!
This course is a requirement for the following Exam(s) :
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 Framework
Our reputation speaks for itself! See what others are saying... Testimonials
Package Includes:
10 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
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)
Focused on practical solutions to real-world development problems
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.
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.
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
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.
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.
Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
Career Academy Computer-Based Training is a cost effective method that meets the critical demands of computer users. Experience our expert-led computer training courses in a comfortable and convenient environment. You get the feel of a computer training school delivered through flexible and familiar technology.
Training comes to life with our full motion video, challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. See the steps, hear the explanations then put your skills to work. Our proven methodology provides an unequalled training experience with exceptional results.
Components:
Instructor-led video lectures Like training one-on-one with an expert with full motion video allows you to see the steps, listen to the explanations, and perform the hands-on lab exercises. Video instruction provides one of the most flexible and comfortable training experiences. The users are able to work at their own pace, in their choice of area - including training room or home. Our training is media-rich, interactive and engaging. We incorporate live video instructions, screen shots, PowerPoint presentations, whiteboard, and lab simulations to give our customers an engaging learning experience. Our teaching methodology capitalizes on the skills and knowledge of industry experts, providing real-world insight from recognized and Certified IT professionals. It's like having an expert in your living room, patiently explaining until you thoroughly understand all the concepts.
Printable Courseware Combining Instructor Keynotes, training outlines and training PowerPoint slides, Our Printable study guide with reference support to help you focus on areas of need and chart your progress.
Exclusive Learning Zone offers interactive learning support across the Internet which sustains students using self-paced learning materials. This is achieved through online real-time access to tutors, interactive chat sessions with other students, bulletin boards and continuous assessment and feedback. 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 questions 24x7, 365 days a year. This means access to a live subject matter expert no matter where you are - day or night.
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.
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
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
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
