|
|
| Programming
with MS ADO .NET |
|
|
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®.
Typically, these individuals will have the following
skills: Experience with a .NET language such as
Microsoft Visual Basic® .NET, Microsoft Visual C#™,
or Microsoft Visual C++®; an understanding of
object-oriented concepts and terminology; experience
developing distributed applications; and experience
developing Web-based applications hosted on Internet
Information Server. |
|
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 Data Documents.
Build a Web service that uses ADO.NET to query and
update a data source. Troubleshoot errors within an
ADO.NET application. |
|
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. |
|
|
 |
