This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server™ 2000, and the Microsoft .NET Framework.
This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organization. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio®.
At Course Completion After completing the course, students will be able to:
Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML.
Connect to SQL Server and other data sources.
Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML.
Build a DataSet schema, populate it with data, and modify the data programmatically.
Build a DataSet from an existing data source.
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.
Build a Web service that uses ADO.NET to query and update a data source.
Troubleshoot errors within an ADO.NET application. .
Whether you have been using Microsoft's ADO or have been creating applications that access data sources, this introduction to ADO.NET development will introduce you to how the .NET framework can be used with various data sources. Besides discussing data-centric applications, connecting to data sources, performing database operations, and DataSets, this course discusses the advanced features of database related technologies and their .NET implementation. Finally, it introduces the use of XML with data sources. Following this course, you will be able to build connected applications that make the most efficient use of modern data sources in the Microsoft .NET framework.
Data-Centric Applications and ADO.NET
Connecting to Data Sources
Performing Connected Database Operations
Building DataSets
Reading and Writing XML with ADO.NET
Building DataSets from Existing Data Sources
Building and Consuming a Web Service That Uses ADO.NET
Deployment Options:
- Video Training
- CD-ROM
- E-learning
- ThinkTank Server Solution
Learning / Exam module:
Course Duration: 36 hours
About Our Experts:
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).
