Programming ADO.NET

Introduction

This course will teach developers to build data-centric applications andWeb services with

Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework.

Pre-Requisites

The course assumes that students have the following skills:

• Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
• Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
• Exposure to XML documents, style sheets, and schemas
• Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
• Experience building user interfaces, including Web applications or Microsoft Windows applications

Outcomes

After completing this 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 XML DataDocuments.
• Build aWeb service that uses ADO.NET to query and update a data source.
• Troubleshoot errors within an ADO.NET application. 

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.