Programming with ADO .NET

This three-day instructor led course provides delegates with the technical skills required to build data-centric, applications and Web Services with ADO .NET, SQL Server 2000 and the Microsoft .NET Framework.

Doelgroep:

This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for their organisation. It is designed for developers who have component and web-application development skills and have previously built solutions using Visual Studio.

Resultaat:

• 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 & 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
• 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 & 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

Inhoud

Overview of Data-centric Applications ADO .NET Architecture Connecting to SQL Server and Other Data Sources Accessing Data in a Connected Environment Modifying and Manipulating Data in a Connected Environment Building and Manipulating Schemas for a Local Data Cache Accessing Data in a Disconnected Environment Modifying and Manipulating Data in a Disconnected Environment Accessing Data in a Disconnected Environment Modifying and Manipulating Data in a Disconnected Environment Managing Transactions Building a Distributed Application that Accesses Data

Vooropleiding

Delegates are required to meet the following prerequisites:

• Understanding of Database Basics: Table, Row, Column, Primary Keys, Foreign Keys, Constraints, Views)
• Concepts including SELECT, INS, UPD, DEL from tables.
• Exposure to XML documents, stylesheets, and schema
• Visual Basic .NET, Visual Basic for Applications, or previous version of Visual Basic
• Describe distributed application architecture Building UI - Web applications or Windows applications

This course, along with the courses listed below are recommended for the following exams:-

• M2310, M2373 & M2389 :- 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• M2565, M2373 & M2389 :- 70-306: Developing and Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• M2310, M2124 & M2389 :- 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET & Microsoft Visual Studio .NET
• M2555, M2124 & M2389 :- Exam 70-316: Developing and Implementing Windows based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Vervolg