Audience

IT professionals including database administrators, application developers, independent software vendors, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable the student to understand the concept of a transaction and how to set up linked servers, access distributed data, and create distributed transactions

Learning Objectives

Outline the concept of a transaction. Point out how to create and manage transactions. determine the best locking option to use. assess the locking level being used. define the concept of distributed data. understand the use of linked servers. Explain the use of distributed transactions.

Topics Covered

Managing transactions - Transactions - Transaction management - Hands-on: Using transactions Locking - Database locks - Lock types - Locking options - Displaying locking information The distributed environment - Setting up distributed environments - Linked server management - Hands-on: Setting up a linked server Distributed data - Querying data from linked servers - Dynamic distributed queries - Distributed transactions - Hands-on: Querying distributed data

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.