ADO.NET

An 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.

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, five-day course is designed to provide programmers an introduction to database programming, focusing on database design working with Oracle as your primary data store.

This course teaches the essential elements of ADO.NET so that programmers are 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. The course uses Oracle as the database and includes coverage of the Oracle Data Provider for .NET (ODP.NET). The close relationship between ADO.NET and XML is covered in detail. There is a practical discussion of data binding and its use in both Windows Forms and Web Forms (ASP.NET) applications. Students will gain a familiarity with creating a Data Access Layer, as it applies to traditional three-tier application architecture, and will learn how to use it in their code.

An intensive course that teaches the essential elements of ADO.NET; 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.

In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts, and more.

In this advanced course, you will become familiar with strongly typed DataSets and learn their advantages and see how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. You will understand migrating and interoperability issues with ADO, as well as handling errors. Learn valuable techniques for building both Web and Windows applications.

In this course, you will learn how to retrieve and manipulate data using Microsoft’s new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data using Select, Find, and DataViews.

In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts, and more.