Upon completion of this course, the student will be able to: Identify enhancements to SQL Server 7.0. Use the Create Server Database. Drop a database. Create filegroups. Use database objects. Use Data Transformation Services. Use Bulk Copy Program. Use BULK INSERT. Choose a transfer method

Unit 1: SQL Server and Relational Databases

• SQL Server Integration with Windows NT4.0
• Enhancements to SQL Server 7.0
• Files and Filegroups

Unit 2: Building a SQL Server Database

• Using the Create Database Wizard
• Dropping a Database
• Creating Filegroups
• Using Database Objects

Unit 3: Importing and Exporting Data

• Data Transformation Services (DTS)
• Bulk Copy Program (bcp)
• BULK INSERT
• Choosing a Transfer Method