Beskrivelse 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.
Forudsætninger
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
Næste kursusdatoer
Spørg for datoer
Flere informationer
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.
- 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
-
Overview of Data-centric Applications
-
ADO .NET Architecture
-
Connecting to SQL Server and Other Data Sources
-
Accessing Data in a Connected Environment
-
Accessing Data in a Disconnected Environment
-
Modifying and Manipulating Data in a Disconnected Environment
-
Managing Transactions
-
Building a Distributed Application that Accesses Data
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