SQL Server 7.0 Installing and Upgrading

This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing, and upgrading to, SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0, and covers logon accounts, the Windows NT User Account, network protocols, management tools and sort orders. The course covers installing and de-installing the SQL Server 7.0 software and OLAP services and how to plan for an upgrade of SQL Server 6.0 or 6.5 to Version 7.0. This course is written to SQL Server 7.0.

Installing and Upgrading training covers such topics as:

Overview of SQL Server 7.0 Installation
Setup Options
Installing SQL Server 7.0
Installing SQL Server Components
Upgrading to SQL Server 7.0

This course is designed for Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series prepares users for the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0.

Description
This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing, and upgrading to, SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0, and covers logon accounts, the Windows NT User Account, network protocols, management tools and sort orders. The course then covers installing and de-installing the SQL Server 7.0 software and OLAP services and how to plan for an upgrade of SQL Server 6.0 or 6.5 to Version 7.0. This course is written to SQL Server 7.0. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 - Designing and Implementing Databases with Microsoft SQL Server 7.0
Audience
Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure
Microsoft SQL Server.
Prerequisites
Students understand computer system fundamentals, and have user knowledge of Windows 95, Microsoft Office, Internet browsing, and HTML, and e-mail systems. Students are expected to have successfully completed the SQL Server 7.0: Introduction course.
Course Duration
» 5 hours
Topics Include
Unit 1: Overview of SQL Server 7.0 Installation
» SQL Setup
» Installation Requirements
» Installation Types
Everything Courseware
SQL Server 7.0 Installing and Upgrading
Unit 2: Setup Options
» Logon Accounts
» Network Protocols
» Character Sets
Unit 3: Installing SQL Server 7.0
» Installing the Standard Edition
» Installing the Desktop Edition
Unit 4: Installing SQL Server Components
» Installing OLAP Services
» Installing Microsoft English Query
» Performing an Unattended Installation
» Uninstalling SQL Server 7.0
Unit 5: Upgrading to SQL Server 7.0
» Planning for the Upgrade
» Performing an Upgrade
» Troubleshooting an Upgrade

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)