Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Data Integrity and Loading Techniques

Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, 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 explain how to create and maintain data integrity and to import and export SQL Server data from different sources

Learning Objectives

Discuss data integrity. Choose between different data integrity enforcement methods. Implement data integrity using constraints, rules, and defaults. Choose between the different SQL Server data loading methods. Load data into a SQL Server database.

Topics Covered

Data integrity - Enforcing integrity - PRIMARY and FOREIGN KEY constraints - Other constraints - Hands-on: Defining constraints Maintaining data integrity - Enabling and disabling constraints - Defaults and rules - Hands-on: Implementing integrity Transferring data - Data transfer - The BULK INSERT statement - The Bulk Copy Program - Hands-on: Importing data using BCP Data Transformation Services - Overview - DTS tools - Hands-on: Transferring data with DTS