Upon completion of this course, the student will be able to : List the SQl Server 7.0 design goals and define how they are implemented Describe the core components of SQL Server 7.0 Identify data warehousing components and describe how they provide solutions for SQL Server Choose the right Application Development Tools for various development situations Define the major functions of the Microsoft Management Console

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

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