Email this to a friend   Microsoft ADO .NET Training PN-320323       Cost Qty     $745.00 Product Options Schedule our instructor led classroom trainings 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! Meet Our Instructors: 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). Included with this training program: 10 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components with over 20 hours of instruction by Richard Hundhausen Over 800 pages of courseware on CD-ROM Step-by-step hands-on-labs Sample code on CD-Rom Focused on practical solutions to real-world development problems Comprehensive, understandable, and reusable as reference material. Personal Training Coach and Career Adviser is available via our toll free advisor hotline. Throughout the training and certification process you will have access to a Training Coordinator who will advice you how to best utilize our training material to accomplish your certification goals, and how to successfully apply your new skills for career advancement. Competitive Advantages Career Academy's Technology-based training is a cost effective method that meets the critical demands of computer users. Experience instructor-led courses in a comfortable and convenient environment. You get the feel of classroom delivered through flexible and familiar technology. Training comes to life with our full motion videos, hands-on 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, listen to the explanations then put your skills to work. Our proven methodology provides an unequalled training experience with exceptional results. Career Academy's Learning system includes all of the following unique features:   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, white board 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. Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned. 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.

ADO.NET Course Outlines

Level 1 ADO .NET INTRODUCTION COURSE OUTLINE Module 1: Introduction to ADO.NET Module 2: Connecting to Data Sources Module 3: Executing Commands Module 4: Retrieving Data Module 5: Building DataSets Module 6: Extending DataSets Module 7: Updating Data Sources Module 8: XML Techniques Module 9: Windows Application Development Module 10: Web Application Development Module 11: Web Services Development INTRODUCTION TO ADO.NET OVERVIEW DATA ACCESS ARCHITECTURES Connected Environments Disconnected Environments Potential Data Stores ADO.NET NAMESPACES MOVING FROM ADO TO ADO.NET SCENARIO Connected Scenario ¡V Selecting Data Connected Scenario ¡V Updating Data Disconnected Scenario ¡V Selecting Data Resources SUMMARY  Level 2 OVERVIEW .NET DATA PROVIDERS CONNECTION CLASS Properties Methods Events CONNECTION STRINGS Popular Parameters Parameter Synonyms SQL Server Security Examples MANAGING A CONNECTION Open Close & Dispose Exception Handling Implicitly Open and Close CONNECTION POOLING What is Connection Pooling ConnectionString Settings Performance Monitor SQL Server Profiler RESOURCES  Level 3 OVERVIEW WHAT IS A COMMAND OBJECT? Encapsulates a SQL statement or stored procedure Properties Methods EXECUTESCALAR Returns a single value (object) COUNT, MAX, MIN, AVERAGE EXECUTENONQUERY DDL, DCL, DML Returns # of DML rows affected EXECUTEREADER ¡V RETURNS ROWS EXECUTEXMLREADER SQL Server 2000 only Returns an XmlReader COMMAND PARAMETERS SQL statements and SPs can have input, output, and return parameters Allow these parameters to be set/read Name, Type, Size, Direction Build them Programmatically Build them via Drag and Drop Setting Input Parameters Retrieving Output Parameters Stored Procedures Create with SQL Tools or Visual Studio CommandType Use Command Parameters TRANSACTIONS Set of related tasks that act as a unit Use SQL commands ¡V BEGIN TRANS, COMMIT TRANS, ROLLBACK TRANS Or use Try ¡V Catch and ADO.NET SUMMARY  Level 4 RETRIEVING DATA OVERVIEW DATAREADER REVISITED Read-only, Forward-only stream ExecuteReader method returns Must "prime" the reader first HasRows, FieldCount, IsClosed Item indexer GetXXX methods, IsDbNull System.Data.SqlTypes DATABINDING Cannot bind DataReader to Windows Forms Controls Can bind to Web Form Controls Q307860 GETSCHEMATABLE GetSchemaTable method Binding to a Windows DataGrid RETRIEVING OUTPUT PARAMETERS Parameter must be Output or ReturnValue Direction DataReader must be closed EXECUTING MULTIPLE STATEMENTS Stored Procedure or Batch may return multiple result sets NextResult method SUMMARY  BUILDING DATASETS OVERVIEW DISCONNECTED ENVIRONMENT DATASET OBJECT MODEL DataSet is an in-memory DB Tables collection Relations collection DATAADAPTER Bridge between DataSet and the Data Source Represents a single result set/table Contains 4 Command Objects DataAdapter Object Model FILLING THE DATASET DataAdapter's SelectCommand Execute SQL or a SP DATASET SCHEMA Infer Schema & Constraints FillSchema OPTIMIZING THE FILL Typed DataSets Set EnforceConstraints = False Call BeginLoadData method SUMMARY  Level 5 OVERVIEW BUILDING DATASETS Creating the pieces Column Properties Custom Expressions ADDING CONSTRAINTS Primary Key Foreign Key Constraints ADDING DATARELATIONS SELECTING DATA DATAVIEWS STRONGLY TYPED DATASETS SUMMARY

Level 6 OVERVIEW BUILDING DATASETS Create the DataSet, DataTable, and DataColumn Column Properties Custom Expressions ADDING CONSTRAINTS Unique constraints at the column or table level Specifying a Primary Key Foreign Key Constraints Enforce Referential Integrity UpdateRule and DeleteRule ADDING DATARELATIONS Support navigation, not Referential Integrity (RI) DataGrid or custom "drilldown" SELECTING DATA DataTables have a Select method Specify optional Sort and RowState filter DATAVIEWS Support navigation, not Referential Integrity (RI) DataGrid or custom "drilldown" STRONGLY TYPED DATASETS SUMMARY  Level 7 OVERVIEW WRITING AND READING XML DATA Writing XML Data GetXml and WriteXml DataRelation Nested Property Reading XML Data READING AND WRITING XML SCHEMA Writing XML Schema Reading XML Schema MAPPING RELATIONAL TO SCHEMA Tables map to ComplexTypes Nested Tables map to nested ComplexTypes UniqueConstraints map to Key/Unique constraints ForeignKeyConstraints map to KeyRef Elements XMLDATADOCUMENT System.Xml namespace Cast to/from DataSet SERIALIZATION DataSet can be serialized Web Services SUMMARY  Level 8 OVERVIEW LEVERAGING DRAG AND DROP Server Explorer ToolBox CONNECTION EVENTS StateChange Event InfoMessage Event DATA BINDING Simple Complex DATAGRID CONTROL Hierarchical, Sortable Lived updates to DataSet Properties Auto-Format RESOURCES SUMMARY   Level 9 OVERVIEW STATE MANAGEMENT Web Applications are Stateless Where to store the State INTEGRATED SECURITY User is no longer the client Use SQL Profiler to monitor Use Enterprise Manager to manage DATABINDING Web Server Controls DataReader as a DataSource Properties DataBind Method DATAGRID DataSource, DataMember Binding Columns DATAVIEW REVISITED Show relevant information Output Cache OutputCache directive Caching Application Data Resources SUMMARY  Level 10 USING ADO.NET IN XML WEB SERVICES DEVELOPMENT OVERVIEW XML WEB SERVICES ARCHITECTURE Discrete Application Logic Internal or external Platform neutral Interoperability W3C protocols CONSTRUCTING AN XML WEB SERVICE ASP.NET Architecture Class and Methods with Attributes No Interface CHOICES FOR RETURNING DATA Data type must be XML serializable String XmlDocument DataSet CONSUMING AN XML WEB SERVICE Various client application types Web Reference Proxy Class DataSet RESOURCES SUMMARY  PROGRAMMING WITH ADO.NET REVIEW REVIEW Introduction to ADO.NET Connecting to Data Sources Executing Commands Retrieving Data Building DataSets Extending DataSets Updating Data Sources XML Techniques Using ADO.NET in Windows Application Development Using ADO.NET in Web Application Development Using ADO.NET in Web Services Development