Online Ado Data eLearning - Training Resources

Visual Basic 6 0 Database Access Part I This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing  more...

Visual Basic 6 0 Database Access Part II This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.  more...

Visual Basic 6 0 ActiveX COM Part II ...rol and covers how to test a data-bound control using the ADO Data control. It also describes how to add Internet functionality to Visual Basic applications, how to use the WebBrowser control to create browser-capable applications and how to create Active documents that can be displayed in Web browser windows. This course also describes how to develop Web-based applic This course is designed  more...

Advanced Language Features of Microsoft VB NET To explain the new object-oriented features of Visual Basic .NET, data access with ADO.NET, and strategies for migration Application developers with experience using previous versions of Microsoft Visual Basic who wish to start working with Microsoft Visual Basic .NET  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design C# programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Building ADO NET DataSets To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns C# programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Advanced ADO NET Programming To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET C# programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Managing Disconnected Data To demonstrate how to relate tables and DataSets, bind DataSets to a DataGrid, and to modify, view, and select disconnected data C# programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Building ADO NET DataSets To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Advanced ADO NET Programming To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths  more...

Microsoft Visual InterDev 6.0: Accessing Remote Data This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services  more...

Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 3 This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity.  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from  more...

Integrating Databases with ASP 3 0 This course is the third course in a series of three in the ASP curriculum. The course provides a description of database integration with Active Server Pages. It also enables students to publish and secure ASP applications. Programmers wishing to learn about Active Server Pages.  more...

SQL Server 7.0 Web Integration This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web  more...

MS VB .NET: Distributed Applications Part 3: Data Access The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET.  more...

Introduction to ASP.NET Part 2: ADO.NET, Partitioning, and Tracing The is the second course in a three part series that provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of  more...

MS VB .NET: Web Development Part 3: Data Access in Visual Studio and ADO.NET Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access.  more...

Microsoft Access 2000 Designing and Implementing Database Applications Part 4 - Debugging Applicatio This is the fourth course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to manage data in tables by using ActiveX Data Objects (ADO) recordsets and SQL; identify code to create and manage stored procedures and triggers; and  more...

Building XML-Based Web Applications Part 2: Validation and Dynamic Data Retrieval This is the second course in a five part series that presents an introduction to the treatment of validation technologies within XML. DTDs are covered presenting detail on DTD elements and attributes and entities. XML Schemas are then introduced emphasizing the advantages of schemas over DTDs and then covering data types and namespaces within XML Schemas. The course then covers the treatment of  more...

Introduction to ASP.NET Part 2: ADO.NET, Partitioning, and Tracing The is the second course in a three part series that provides the learner with instruction on using ADO.NET to access data on separating code from content and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of  more...

MS VB .NET: Web Development Part 3: Data Access in Visual Studio and ADO.NET Assuming that the learner is now familiar with the basics of Web forms and controls this course introduces ADO .NET and guides the learner through database connections and data access.  more...

MS VB .NET: Distributed Applications Part 3: Data Access The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET.  more...

XML Programming Using Java This four-day course builds skills in Java s XML processing APIs chiefly parsing using SAX and DOM and transformations using XSLT, all using the Java API for XML Processing, or JAXP. It also covers the newer Java API for XML Binding, or JAXB, which standardizes serialization according to XML Schema. The course is intended for students with a working knowledge of XML and possibly DTDs or XML Schema  more...

XML Programming Using Visual Basic and NET This comprehensive and practical four-day course builds skills in .NET s XML processing APIs chiefly parsing using XmlReader and the Document Object Model (DOM), writing XML streams using XmlWriter, and transformations using XPath and XSLT, all using the .NET Framework XML classes and the Visual Basic language. It also covers XML serialization according to XML Schema and the tight coupling between  more...

XML Schema This course gives the student who knows the fundamentals of XML a detailed introduction to the XML Schema standard for defining document type information. The first module introduces the new XML Schema recommendation. Students review the shortcomings of the DTD for expressing type information, and learn how to use XML Schema to create strict document models. Schema data types and structures are  more...

XML Programming Using C and NET This comprehensive and practical four-day course builds skills in .NET s XML processing APIs chiefly parsing using XmlReader and the Document Object Model (DOM), writing XML streams using XmlWriter, and transformations using XPath and XSLT, all using the .NET Framework XML classes and the C# language. It also covers XML serialization according to XML Schema and the tight coupling between XML and  more...

Windows Forms Using Visual Basic This course provides a practical, hands-on introduction to GUI development using Windows Forms and Visual Basic 2005. This five-day version of the course introduces database programming in Windows and includes extensive coverage of powerful new Windows Forms features in.NET 2.0, such as new controls, new data binding, and ClickOnce deployment for creating smart client applications. A shorter  more...

Oracle Applications Using ADO NET and C Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This comprehensive course  more...

Windows Forms Using C This course provides a practical, hands-on introduction to GUI development using Windows Forms and C#. This five-day version of the course introduces database programming in Windows and includes extensive coverage of powerful new Windows Forms features in.NET 2.0, such as new controls, new data binding, and ClickOnce deployment for creating smart client applications. A shorter four-day version of  more...

Developing Applications using Visual Basic 2008 VB2008 Visual Studio 2008 adds a large set of new functionality for the Visual Studio developer. From new language features, including LINQ (Language Integrated Query), to new client-side data support, Visual Studio 2008 and the .NET Framework 3.5 make it easier than ever to create robust, enterprise-level applications. In this course, you will begin with the basics, becoming familiar with Windows Forms  more...

ADO NET for Windows Applications Using C This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.  more...

ADO NET for Web Applications Using C This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications for the Web. The course includes a major case study demonstrating the use of ADO.NET and ASP.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and  more...

ADO NET Using C This intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The course  more...

ADO NET Using VB NET This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The  more...

ASP NET Using Visual Basic 2008 VB2008 In this course, you'll learn how to use Visual Studio 2008 and Visual Basic 2008 to build ASP.NET 3.5 Web pages. You'll gain an understanding of the architecture behind ASP.NET and how to use the various ASP.NET server controls. You'll learn to create consistent web sites using Master Pages, add membership features, configure and deploy ASP.NET applications, to authenticate users and limit their  more...

ASP NET Using Visual Basic This five-day course provides a comprehensive and practical hands-on introduction to developing Web applications using ASP.NET 2.0 and Visual Basic. It also introduces Web services. ASP.NET is introduced as a new Web programming platform that overcomes a number of limitations of ASP. Its architecture is outlined, including the role of compilation, the Page class and code-behind. Web Forms are  more...

ASP NET Using C 2008 In this course, you'll learn how to use Visual Studio 2008 and Visual C# 2008 to build ASP.NET 3.5 Web pages. You'll gain an understanding of the architecture behind ASP.NET and how to use the various ASP.NET server controls. You'll learn to create consistent web sites using Master Pages, add membership features, configure and deploy ASP.NET applications, to authenticate users and limit their  more...

ASP NET Using C This five-day course provides a comprehensive and practical hands-on introduction to developing Web applications using ASP.NET 2.0 and C#. It also introduces Web services. ASP.NET is introduced as a new Web programming platform that overcomes a number of limitations of ASP. Its architecture is outlined, including the role of compilation, the Page class and code-behind. Web Forms are introduced,  more...