FROM THE PUBLISHER

General Information Course Duration:

40 hours 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 Topics Covered Architecture and Features Fundamentals of Database Design Normalization and Physical Database Design Basic Transact ￯﾿ﾽ SQL Creating Databases Data Integrity and Loading Techniques Indexes and Views Advanced Transact ￯﾿ﾽ SQL Stored Procedures and Triggers Transactions and Distributed Data Monitoring and Optimizing

Minimum Requirements to run SmartForce products: 486/33 processor or higher 8MB of RAM VGA display (256 colors recommended) 10-20MB of hard disk space DOS version 3.1 or higher Windows version 3.1/Windows 95 Supported Network Operating Systems: Novell NetWare 3.1x/4.1x Windows NT 3.51/4.0 OS/2 LAN Manager Banyan Vines Course Aim

To prepare students for Microsoft exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. Learning Objectives

After taking this course, the user should be able to: Design and implement a Microsoft SQL Server client/server database management system version 7.0

Implement a database solution with Microsoft SQL Server 7.0 and upgrade MS SQL Server from versions 6.0 and 6.5 to 7.0

Use the architecture and feature changes from version 6.5 to version 7.0