SQL Server 7.0 Introduction

This course presents an overview of the features and benefits of SQL Server 7.0, a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0, and examines core components, data warehousing, application development tools, and SQL management tools.

This course provides an excellent foundation for advanced courses on upgrade and installation, system management, database administration, data warehousing, client/server application development, and SQL to IIS active server pages.

Introduction training covers such topics as:

Overview and New Features
Data and Databases
Client/Server and Web Applications
SQL Server Programming
Replication
Administration

Introduction to SQL Server 7.0 is designed for information system professionals who want to utilize the powerful new features of SQL Server 7.0; beginning, interested people who would like to know more about SQL Server 7.0; developers who will create applications using SQL Server; and IS managers who need to understand the capabilities of SQL Server 7.0.

Description
This course presents an overview of the features and benefits of SQL Server 7.0, a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0, and examines core components, data warehousing, application development tools, and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and installation, system management, database administration, data warehousing, client/server application
development, and SQL to IIS active server pages.
Audience
Introduction to SQL Server 7.0 is designed for information system professionals who want to utilize the powerful new features of SQL Server 7.0; beginning, interested people who would like to know more about SQL Server 7.0; developers who will create applications using SQL Server; and IS managers who need to understand the capabilities of SQL Server
Prerequisites
Individuals taking this course should be familiar with basic database concepts, and have some experience using database and client/server operations.
Course Duration
» 5 hours
Topics Include
Overview and New Features
» SQL server 7.0
» System Architecture
» New and Improved Features
» Supporting Programs
Data and Databases
» Databases
» Tables
» Normalizing Data
» Data Manipulation
» SQL Server Tools
Everything Courseware
SQL Server 7.0 Introduction
Client/Server and Web Applications
» Client/Server Architecture
» Interfaces
» Query Libraries
» Web Applications
SQL Server Programming
» Transact-SQL
» DB-Library
» Open Data Services
» Embedded SQL Programming
Replication
» Types of Replication
» Planning
» Implementing Replication
» Publications and subscriptions
» Security Management
» Heterogeneous Replication
Administration
» Administration Automation
» Security
» Optimization
» Installation

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)