Microsoft SQL Server 7.0: Data Integrity and Loading Techniques

Overview/Description
To explain how to create and maintain data integrity and to import and export SQL Server data from different sources

Target Audience
IT professionals including database administrators, application developers, independent software vendors, system integrators, 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Data Integrity and Loading Techniques

  • To describe how to enforce data integrity using constraints
  • To describe how to maintain data integrity by enabling and disabling constraints and by using defaults and rules
  • To describe data transfer in SQL Server 7.0
  • To explain how to use Data Transformation Services


    • Course Number: SQ7043E