Звезды и С - Главная Звезды и С - Citrix Звезды и С - Microsoft Звезды и С - О нас

Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск

Курс M2389: Программирование ADO.NET

Цена для физических лиц, р.: 7950
Цена для юридических лиц, р.: 9950

Продолжительность курса (дней): 2

Даты (день):

Даты (вечер):

Курс готовит к тестам: 70-305, 70-306, 70-315, 70-316

Цель: Курс предназначен для разработчиков профессиональных платформ, которые способны проектировать и строить центры данных и распределённые приложения для своих организаций. Он предназначен для программистов, которые имеют навыки разработки Web приложений и собственные решения использующие среду Microsoft Visual Studio®. Обычно слушатели имеют следующие навыки: опыт работы с .NET языками такими как Microsoft Visual Basic® .NET, Microsoft Visual C#™, или Microsoft Visual C++®; понимание объектно-ориентированной концепции и технологии; опыт разработки распределённых приложений; и опыт разработки Web-based приложений на базе Internet Information Server.

Необходимая подготовка:

  • 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

Предварительный тест:

Результат:

План курса:

Module 1: Data-Centric Applications and ADO.NET

The following topics are covered in this module:

Design of Data-Centric Applications . ADO.NET Architecture . ADO.NET and XML .

After completing this module, students will be able to:

Give examples of storage options. Diagram the architecture of data-centric applications. Choose a connected, disconnected, or mixed environment based on application requirements. Use the System.Data namespaces in applications. Diagram the ADO.NET object model. Analyze typical business scenarios. Explain how to use ADO.NET with XML.

Lab 1.1: Data-Centric Applications and ADO.NET

Module 2: Connecting to Data Sources

The following topics are covered in this module:

Choosing a .NET Data Provider . Defining a Connection . Managing a Connection . Handling Coonection Exceptions . Connection Pooling .

After completing this module, students will be able to:

Choose a .NET data provider. Connect to SQL Server. Connect to OLE DB data sources. Manage a connection. Handle common connection exceptions. Implement and control connection pooling.

Lab 2.1: Connecting to Data Sources

Module 3: Performing Connected Database Operations

The following topics are covered in this module:

Working in a Connected Environment . Building Command Objects . Executing Commands That Return a Single Value . Executing Commands That Return Rows . Executing Commands That Do Not Return Rows . Using Transactions .

After completing this module, students will be able to:

Build a command object. Execute a command that returns a single value. Execute a command that returns a set of rows, and process the result. Execute a command that defines database structure and permissions by using the data definition language (DDL) and data control language (DCL). Execute a command that modifies data. Use transactions.

Lab 3.1: Performing Connected Database Operations

Module 4: Building DataSets

The following topics are covered in this module:

Working in a Disconnected Environment . Building DataSets and DataTables . Binding and Saving a DataSet . Defining Data Relationships . Modifying Data in a DataTable . Sorting and Filtering .

After completing this module, students will be able to:

Describe the disconnected environment. Build a DataSet and a DataTable. Bind a DataSet to a DataGrid. Open and save a DataSet. Define a data relationship. Modify data in a DataTable. Find and select rows in a DataTable. Sort and filter a DataTable by using a DataView.

Lab 4.1: Building, Binding, Opening, and Saving DataSets

Lab 4.2: Manipulating DataSets

Module 5: Reading and Writing XML with ADO.NET

The following topics are covered in this module:

Creating XSD Schemas . Loading Schemas and Data into DataSets . Writing XML from a DataSet .

After completing this module, students will be able to:

Generate an XSD schema from a DataSet by using graphical tools. Save a DataSet structure to an XSD schema file. Create and populate a DataSet from an XSD schema and XML data. Save DataSet data as XML. Write and load changes by using a DiffGram.

Lab 5.1: Working with XML Data in ADO.NET

Module 6: Building DataSets from Existing Data Sources

The following topics are covered in this module:

Configuring a DataAdapter to Retrieve Information . Populating a DataSet Using a DataAdapter . Configuring a DataAdapter to Update the Underlying Data Source . Persisting Changes to a Data Source . How to Handle Conflicts .

After completing this module, students will be able to:

Configure a DataAdapter to retrieve information. Populate a DataSet by using a DataAdapter. Configure a DataAdapter to modify information. Persist data changes to a data source. Manage data conflicts.

Lab 6.1: Retrieving Data into a Disconnected Application

Lab 6.2: Retrieving and Updating Customers and Orders Data

Module 7: Building and Consuming a Web Service That Uses ADO.NET

The following topic is covered in this module:

Building and Consuming a Web Service That Returns Data .

After completing this module, students will be able to:

Build a Web service. Consume a Web service in a client application. Troubleshoot errors in an ADO.NET application.

Lab 7.1: Troubleshooting an ADO.NET Application



  Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск

   Тел: +74953633686 email: info@stars-s.ru

   125040, Москва, Ленинградский проспект, д. 5, стр. 2, под. 5, офис "Звезды и С"

  © Учебный центр "Звезды и С", 1991-2019, Оферта