Jeff Cook - MCT, MCSD, MCAD, MCP, A+ and MCDBA
He has been a Microsoft Certified Trainer for 6 years and has been in the training industry for 9 years. Also, he has developed mid-level and Enterprise level applications allowing him to implement a large amount of "real world" experience into his training.
Jeff has been a prinicipal instructor for numerous training organizations since June 1998 with over 1,400 days of teaching experience and an average student survey score of 9.62 on a 10 point scale.
- 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...
- 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.
- 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.
- Microsoft Authorized Practice Exams
CareerAcademy.com includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
- 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
Gain hands-on knowledge through watching the instructor actually perform the lab in a video-based demonstration. Following the conclusion, students can mimic the previously performed actions and apply them in the "real world".
- 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.
Module 1 - Connecting to Databases and Reading Data
ADO.Net
Connect and Read Data
Creating a Connection
Demo - Creating and Using Connections/Commands
Connection Events
Connection Exceptions
Connection Pooling
Pool Settings
Demo - Connection Pooling
Module 1 Review
Module 2 - Querying and Updating Databases
ADO.Net Commands
Command Properties
Command Methods
Demo - Create Commands
Bind Data to Control
Demo - Binding Commands to Controls
Pass Parameters to Command
Parameter Properties
Demo - Execute a Command with Parameters
Server Explorer
Demo - Using Server Explorer
Module 2 Review
Module 3 - Transactional Operations
What is a Transaction?
Transaction Support
Transaction Characteristics
Managing Local Transactions
Local Transaction Example
Demo - Local Transaction
Managing Distributed Transactions
Create Transaction
Demo - Use Distributed Transaction
Isolation
Isolation Levels
Isolation Matrix
Demo - Show Effects of Isolation Levels
Lab Demonstration 1
Module 3 Review
Module 4 - Disconnected Operations
ADO.NET Disconnected Model
Create DataSet Model
Demo - Create a Dataset
Special Columns
Constraints and Relations
Demo - Add Special (Nondata) Columns
DataSet Relations
Demo - Create Dataset Relation
Demo - Use Relation to Access Child Records
Data Adapter
Loading and Saving Data in a DataSet
Data Adapter Properties
Demo - Create and Use Data Adapter
Data Views
Data View Properties
Demo - Create and Use Data view
Module 4 Review
Module 5 - Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Disconnected Datasets
Untyped vs. Typed Datasets
Tables in Typed Dataset
Demo - Creating a Dataset and Datatable
Retrieve Data from a DataTable
DataTable Methods
DataTable Properties
Demo - Work with Datatable's
Table Adapters
Demo - Create Table adapter
Lab Demonstration 2
Module 5 Review
Module 6 - XML Operations on Disconnected Data
XML and ADO.Net
Work with XML and DataSets
Demo - Load a Dataset from XML
Demo - Write XML from Dataset
Diff Gram
Demo - Show Results of Diff gram
Module 6 Review
Module 7 - Reading and Writing XML Data
Serially Reading XML Data
Create XML Reader
Sample XML Reader
Demo - Create and Use XML reader
Serially Writing XML Data
Create XML Writer
Sample XML writer
Demo - Create and Use XML writer
Module 7 Review
Module 8 - Processing XML Data by Using DOM
What Is DOM?
Load an XML Document
Demo - Create and Load XML Dom Object
What Are DOM Trees?
Dom Tree
XML Nodes in a DOM Tree
XML Collection Classes
Demo - Use XML Dom Object by Navigating Nodes
Lab Demonstration 3
Module 8 Review
