Microsoft SQL Server 7.0: Transactions and Distributed Data

Overview/Description
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

Target Audience
IT professionals including database administrators, application developers, independent software vendors, system integrators, and Internet consultants who want to plan, deploy, configure, and administer 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Transactions and Distributed Data

  • To describe how to manage transactions
  • To explain the various types of SQL Server lock and their uses
  • To describe how to set up and manage a distributed environment
  • To describe how to query and modify distributed data


    • Course Number: SQ7046E