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

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

Специальные предложения
Software Assurance - Бесплатные курсы обучения по ваучерам
CITRIX
MICROSOFT
Авторские курсы Microsoft
Microsoft Windows Server 2012 R2 / 2016
Microsoft Windows 10 / 8.1
Облачные технологии: Microsoft Windows Azure, Private Cloud, Office 365
Microsoft Exchange Server 2013 / 2016
Microsoft System Center
Microsoft Lync Server 2013 / Skype for business 2015
Microsoft SQL Server 2014 / 2016
Microsoft SharePoint 2013 / 2016
Microsoft Visual Studio 2013 / 2016
Microsoft Forefront
Microsoft BizTalk Server
Microsoft On-Demand
Microsoft Dynamics
Обучение корпоративных пользователей
Более ранние версии программных продуктов Microsoft
Треки - до 2012г. (MCITP, MCTS, MCP)
Microsoft Windows Server 2008
Microsoft Windows Server 2003
Security on Microsoft Windows
Windows 7
Microsoft Windows XP
Microsoft Exchange Server 2010
Microsoft Exchange Server 2007
Microsoft SQL Server 2008
Microsoft SQL Server 2005
Microsoft SharePoint 2007, Project 2007
Microsoft Office Communications Server 2007
Microsoft Office PerformancePoint Server 2007
System Center
Microsoft SharePoint 2010
Авторские курсы A. Кибкало
Microsoft SharePoint 2013
Microsoft SQL Server 2012
Microsoft Visual Studio 2010
Microsoft SharePoint 2010
Microsoft SQL Server 2008
Microsoft Visual Studio 2008
Microsoft SQL Server 2005
Microsoft Visual Studio 2005
Microsoft SQL Server 2000
MS Visual C++ Development
MS Visual Basic Development
MS Solutions Framework
MS Internet/Intranet Application Development
Microsoft SharePoint Portal Server 2007, Project 2007
Microsoft BizTalk Server 2009
Расписание курсов Microsoft в графическом формате
VMware
Cisco
ITIL
Linux
Вечернее обучение
Условия обучения

Курс M2541: Основы разработки доступа к данным с использованием Microsoft Visual Studio 2005

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

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

Даты (день):

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

Курс готовит к тестам: 70-505, 70-526, 70-528

Цель: Научить разработке приложений баз данных на платформе .Net Framework 2.0. Основное внимание в курсе уделяется изучению приёмов программирования модели доступа к данным ADO.Net. Данный курс позволит Вам получить широкое представление о возможностях среды разработки Microsoft Visual Studio 2005, и о модели доступа к данным ADO.Net, как платформы создания приложений активно взаимодействующих с базами данных и выполняющих анализ информации. В курсе выполняется больше количество самостоятельных заданий и лабораторных работ, что позволит Вам практически сразу после окончания приступить к реальной разработке программного обеспечения. После изучения данного курса Вы будете уметь использовать уникальные возможности Microsoft Visual Studio 2005 и модели доступа к данным ADO.Net (Framework 2.0) для разработки приложений баз данных. Курс обеспечивает необходимый уровень практических навыков по разработке приложений баз данных. Вас научат задавать и шифровать строку подключения к базам данных, выполнять всевозможные команды в реляционной базе данных, применять механизм транзакций, использовать инструменты и утилиты Visual Studio 2005 для работы с базой. Вас научат работать с XML данными и XML схемами, применять на практике объектную модель документа DOM для разбора и модификации XML данных.

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

  • Успешное окончание курса: 2555 Разработка Windows-приложений для Microsoft .NET на Visual С# либо 2565 Разработка Windows-приложений для Microsoft .NET на Visual Basic .NET
  • Успешное окончание курса: 2124 Программирование на языке С# либо 2559 Введение в программирование для Microsoft .NET на Visual Basic .NET

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

Результат:

План курса:

Unit 1: Connecting to Databases and Reading Data

This unit introduces the fundamental skills required to connect to a database and read data from the database. It describes how to use ADO.NET data providers to connect to various different kinds of databases, and how to execute a query that returns a scalar value from the database. It also describes how to use connection pooling to achieve scalability, and how to handle connection events and exceptions.

Lessons

What Is ADO.NET?. The Process for Connecting to a Database and Reading Data. What Is Connection Pooling?

Lab 1: Connecting to Databases and Reading Data

Exercise 1. Connecting to a Database. Exercise 2. Saving a Connection String Securely in an Application Configuration File. Exercise 3. Retrieving Data from a Database. Exercise 4. Handling Connection Events and Exceptions. Exercise 5. Configuring and Using Connection Pooling (if time permits)

After completing this unit, students will be able to:

Describe the key features of ADO.NET. Explain the process for connecting to a database and reading data from a database. Describe the benefits of connection pooling. Connect to a database. Save a connection string securely in an application configuration file. Retrieve data from a database. Handle connection events and exceptions.

Unit 2: Querying and Updating Databases by Using Commands

This unit describes how to create and run commands that return a scalar value, return a result set, update data in the database, or update the schema of the database. It also describes how to create and run parameterized commands.

Lessons

ADO.NET Commands. The Process for Passing Parameters into Commands

Lab 2: Querying and Updating Databases by Using Commands

Exercise 1. Creating and Running Query Commands. Exercise 2. Creating and Running Parameterized Commands. Exercise 3. Creating and Running Update Commands. Exercise 4. Using Globalized Formats for Storing and Accessing Data (if time permits)

After completing this unit, students will be able to:

List the different types of ADO.NET commands. Explain the process for creating and executing parameterized commands. Create and run query commands. Create and run parameterized commands. Create and run update commands.

Unit 3: Performing Transactional Operations

This unit describes how to manage transactions in a .NET application at the middle tier. It describes how to write ADO.NET code to start, commit, and rollback local transactions. It also describes how to specify an appropriate isolation level for a transaction, and how to enlist in distributed transactions.

Lessons

What Is a Transaction?. The Process for Managing Local Transactions. The Process for Managing Distributed Transactions. Isolation Levels

Lab 3: Performing Transactional Operations

Exercise 1. Performing Data Updates within a Transaction. Exercise 2. Choosing an Appropriate Isolation Level for a Transaction. Exercise 3. Enlisting in a Distributed Transaction. Exercise 4. Managing Transactions in the Data Tier (if time permits)

After completing this unit, students will be able to:

Describe the concept of transactional operations. Explain the process for managing a local transaction. Explain the process for managing a distributed transaction. Describe the effect of setting the isolation level for a transaction. Perform data updates within a transaction. Choose an appropriate isolation level for a transaction. Enlist in a distributed transaction.

Unit 4: Performing Disconnected Operations Programmatically

This unit describes how to create and use DataSets programmatically. It describes how to create DataSet, DataTable, and DataColumn objects, how to populate a DataSet manually, and how to load and save data by using a DataAdapter. It also describes how to create in-memory views on data by using a DataView.

Lessons

What Is the ADO.NET Disconnected Model?. The Process for Loading and Saving Data in a DataSet. What Are DataViews?

Lab 4: Performing Disconnected Operations Programmatically

Exercise 1. Creating a DataSet Programmatically. Exercise 2. Populating and Saving a DataSet. Exercise 3. Adding, Modifying, and Deleting Data in a DataSet. Exercise 4. Merging DataSets. Exercise 5. Creating and Using DataViews (if time permits)

After completing this unit, students will be able to:

Describe the ADO.NET disconnected data model. Explain the process for loading and saving data in a DataSet. Describe how to use DataViews to provide a view on data. Create a DataSet programmatically. Populate and save a DataSet. Add, modify, and delete data in a DataSet. Merge DataSets.

Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

This unit describes how to create typed DataSets, DataAdapters, and TableAdapters by using the TableAdapter Configuration Wizard and the Data Source Configuration Wizard in Visual Studio 2005. It also describes how to write type-safe code to access data in a typed DataSet.

Lessons

Comparing Untyped DataSets with Typed DataSets. What Are Table Adapters?. Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards

Lab 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Exercise 1. Creating a Typed DataSet by Using the DataSet Designer. Exercise 2. Loading, Displaying, and Saving Data in a Typed DataSet. Exercise 3. Adding Code to a Typed DataSet. Exercise 4. Creating a Typed DataSet by Using the Data Source Configuration Wizard. Exercise 5. Adding Queries to a Table Adapter (if time permits)

After completing this unit, students will be able to:

Explain the differences between untyped DataSets and typed DataSets. Explain how table adapters work in conjunction with data tables in a typed DataSet. Describe the process for creating a typed DataSet by using Visual Studio 2005 Wizards. Create a typed DataSet by using the DataSet Designer. Load, display, and save data in a typed DataSet. Add code to a typed DataSet. Create a typed DataSet by using the Data Source Configuration Wizard.

Unit 6: Performing XML Operations on Disconnected Data

This unit describes how to read and write DataSets in XML format. It describes how to read and write data only, schema only, or a combination of the two. It also describes how to read and write a DataSet as a DiffGram, so that modifications to the data can be retained when the DataSet is serialized to XML format.

Lessons

XML Representations of DataSets. What Are DiffGrams?

Lab 6: Performing XML Operations on Disconnected Data

Exercise 1. Saving a DataSet as XML Data. Exercise 2. Loading a DataSet from XML. Exercise 3. Saving and Loading DataSet Schema Information

After completing this unit, students will be able to:

Describe scenarios in which you can represent a DataSet as XML data. Explain how a DiffGram retains information about modifications to a DataSet. Save a DataSet as XML data. Load a DataSet from XML. Save and load DataSet schema information.

Unit 7: Reading and Writing XML Data

This unit describes how to use the XmlReader and XmlWriter classes to serially read and write XML data. It describes how to read elements, attributes, and text content in an XML document, and perform validation against an XML schema. It also describes how to create an XML document and write elements, attributes, namespace declarations, and text content.

Lessons

The Process for Serially Reading XML Data. The Process for Serially Writing XML Data

Lab 7: Reading and Writing XML Data

Exercise 1. Writing XML Data by Using XmlWriter. Exercise 2. Reading XML Data by Using XmlReader

After completing this unit, students will be able to:

Describe the process for serially reading XML data. Describe the process for serially writing XML data. Write XML data by using XmlWriter. Read XML data by using XmlReader.

Unit 8: Processing XML Data by Using DOM

This unit describes how to process XML data in memory by using the Document Object Model (DOM). It describes how to load an XML document into a DOM tree, and validate the XML document against an XML schema. It also describes how to read existing XML content, modify XML content, and save the DOM tree to an XML document.

Lessons

What Is DOM?. What Are DOM Trees?. Types of XML Nodes in a DOM Tree

Lab 8: Processing XML Data by Using DOM

Exercise 1. Reading XML Data by Using DOM. Exercise 2. Writing XML Data by Using DOM

After completing this unit, students will be able to:

Explain what DOM is and describe how to process XML data in memory by using DOM. Explain what a DOM tree is and describe how to represent XML documents as a DOM tree. List the types of nodes in a DOM tree. Read XML data by using DOM. Modify XML data by using DOM.


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

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

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

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