Звезды и С - Главная КУРСЫ ОБУЧЕНИЕ ВЕБИНАРЫ Тел: +7 495 363 36 86
e-mail: info@stars-s.ru
Москва, Ленинградский пр-кт, д. 5, стр. 2
План проезда
ВЕРСИЯ ДЛЯ СЛАБОВИДЯЩИХВЕРСИЯ ДЛЯ СЛАБОВИДЯЩИХ

О нас|ASTRA LINUX|KASPERSKY|CITRIX|MICROSOFT|POSTGRES|CISCO|≡ Вендоры|Поиск

Курс M2542: Углубленный изучение разработки доступа к данным с использованием Microsoft Visual Studio 2005

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

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

Даты (день):

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

Цель: Научить тонкостям разработки приложений баз данных на платформе .Net Framework 2.0. Основное внимание в курсе уделяется изучению новых возможностей как самой модели доступа к данным ADO.Net(Framework 2.0), так и новых возможностей по использованию управляемого кода в SQL Server 2005. Данный курс позволит Вам получить углублённое представление о модели доступа к данным ADO.Net (Framework 2.0), и о возможностях языков XML Path Language (XPath) и Extensible Stylesheet Language for Transformations (XSLT) по работе с XML данными. В курсе выполняется больше количество самостоятельных заданий и лабораторных работ, что позволит Вам практически сразу после окончания приступить к реальной разработке программного обеспечения. Курс обеспечивает необходимый уровень практических навыков по разработке приложений баз данных. Вас научат разрешать конфликты при чтении/сохранении данных в базу; читать/сохранять BLOB данные в SQL Server 2005; создавать, используя управляемый код, хранимые процедуры и триггера, пользовательские функции, агрегирующие функции и пользовательские типы данных для SQL Server 2005. Вас научат применять язык XPath при работе с XML данными и применять преобразование XML документов с использование таблиц стилей языка XSLT.

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

Формат обучения, регистрация на курс:

План курса:

Unit 1: Minimizing and Handling Database Operation Conflicts

This unit describes how to minimize data access conflicts, and how to handle these conflicts when they occur. It describes how to implement optimistic concurrency in the ADO.NET disconnected model, and how to implement optimistic concurrency by using the various isolation levels available in SQL Server 2005.

Lessons

Why Do Data Conflicts Arise?. Isolation Levels Available in SQL Server 2005. Guidelines for Using SQL Server 2005 Isolation Levels

Lab 1: Minimizing and Handling Database Operation Conflicts

Exercise 1. Reading Committed Data by Using Locks. Exercise 2. Reading Committed Data by Using Statement-Level Snapshots. Exercise 3. Reading Committed Data by Using Transaction-Level Snapshots. Exercise 4. Handling Data Concurrency by Using ADO.NET

After completing this unit, students will be able to:

Explain why data conflicts arise. Describe the isolation levels that are available in SQL Server 2005. Describe the guidelines for using SQL Server 2005 isolation levels. Read committed data by using locks. Read committed data by using statement-level snapshots. Read committed data by using transaction-level snapshots. Handle data concurrency by using ADO.NET.

Unit 2: Handling Large Objects

This unit describes how to read and write large values efficiently to a SQL Server database. It describes how to read large binary values and large text values by using SequentialAccess for a SqlDataReader. It also describes how to write large binary values and large text values, and how to conserve resources when writing large values.

Lessons

What Are Binary Large Objects and Character Large Objects?. The Process for Reading Large Objects from a Database. The Process for Writing Large Objects to a Database

Lab 2: Handling Large Objects

Exercise 1. Reading Large Values from SQL Server. Exercise 2. Writing Large Values to SQL Server. Exercise 3. Conserving Resources When Writing Large Values to SQL Server

After completing this unit, students will be able to:

Describe binary large objects and character large objects. Explain the process for reading large objects from a database. Explain the process for writing large objects to a database. Read large values from SQL Server. Write large values to SQL Server. Conserve resources when writing large values to SQL Server.

Unit 3: Enhancing Database Performance

This unit describes how to enhance database performance by using new features available in ADO.NET 2.0. The unit describes how to perform asynchronous data operations, create multiple active result sets, perform batch updates, and perform bulk copies.

Lessons

ADO.NET Enhancements in the .NET Framework 2.0. SQL Server Provider Statistics

Lab 3: Enhancing Database Performance

Exercise 1. Accessing Multiple Result Sets Concurrently. Exercise 2. Performing Asynchronous Data Access Operations. Exercise 3. Performing a Batch Update. Exercise 4. Performing a Bulk Data Copy

After completing this unit, students will be able to:

Describe the ADO.NET enhancements in Microsoft .NET Framework 2.0. Describe the support for run-time statistics in the .NET Framework Data Provider for SQL Server. Access multiple result sets concurrently. Perform asynchronous data access operations. Perform a batch update. Perform a bulk data copy.

Unit 4: Creating Managed Code Objects for SQL Server 2005

This unit describes how to create database objects for SQL Server 2005 in a .NET Framework programming language. It describes how to create stored procedures, triggers, user-defined functions, aggregates, and user-defined types in managed code. Additionally, it describes how to deploy an assembly that contains managed objects into SQL Server 2005, and how to declare database objects to reference the managed objects.

Lessons

The Benefits of Creating Managed Code Objects. Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005. Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005

Lab 4: Creating Managed Code Objects for SQL Server 2005

Exercise 1. Creating Managed Stored Procedures and Triggers. Exercise 2. Creating Managed User-Defined Functions. Exercise 3. Creating a Managed Aggregate. Exercise 4. Creating a Managed User-Defined Type. Exercise 5. Importing Existing Assemblies into SQL Server 2005 (if time permits)

After completing this unit, students will be able to:

Describe the benefits of creating managed code objects for SQL Server 2005. Explain the process for importing an existing assembly into SQL Server 2005. Explain the process for implementing managed code objects in SQL Server 2005. Create managed stored procedures and triggers. Create managed user-defined functions. Create a managed aggregate. Create a managed user-defined type.

Unit 5: Querying XML by Using XPath

This unit describes how to use XPath in a .NET Framework application. It describes how to create an XPathNavigator object on an XML document, and how to locate content and evaluate expressions by using the XPathNavigator object. Additionally, it describes how to edit XML data by using the XPathNavigator object.

Lessons

The XPath Data Model. The Process for Selecting and Editing XML Data by Using XPathNavigator. The Process for Evaluating XPath Expressions by Using XPathNavigator

Lab 5: Querying XML by Using XPath

Exercise 1. Selecting XML Data by Using XPathNavigator. Exercise 2. Evaluating XPath Expressions by Using XPath Navigator. Exercise 3. Creating and Using Compiled XPath Expressions. Exercise 4. Editing XML Data by Using XPathNavigator

After completing this unit, students will be able to:

Describe the XPath data model. Explain the process for selecting and editing XML data by using XPathNavigator. Explain the process for evaluating XPath expressions by using XPathNavigator. Select XML data by using XPathNavigator. Evaluate XPath expressions by using XPathNavigator. Create and use compiled XPath expressions. Edit XML data by using XPathNavigator.

Unit 6: Transforming XML by Using XSLT Style Sheets

This unit describes how to transform XML documents in a .NET Framework application. It introduces how to load an XSLT style sheet in an application, and how to execute the style sheet to transform an XML document. The unit also describes how to pass parameters into a style sheet, and how to create and use extension objects.

Lessons

What Is XSLT?. The Process for Executing an XSLT Style Sheet. What Are Extension Objects?

Lab 6: Transforming XML by Using XSLT Style Sheets

Exercise 1. Transforming an XML Document by Using an XSLT Style Sheet. Exercise 2. Resolving External Resources During XSLT Processing. Exercise 3. Passing Parameters into an XSLT Style Sheet. Exercise 4: Creating and Using Extension Objects

After completing this unit, students will be able to:

Describe the purpose of XSLT. Explain the process for executing an XSLT style sheet. Describe the purpose of extension objects. Transform an XML document by using an XSLT style sheet. Resolve external resources during XSLT processing. Pass parameters into an XSLT style sheet. Create and use extension objects.


  О нас|ASTRA LINUX|KASPERSKY|CITRIX|MICROSOFT|POSTGRES|CISCO|≡ Вендоры|Поиск

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

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

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