Microsoft SQL Server 2000 Database Administration Curriculum CBT Training CDs

Rating:
Summary: Microsoft SQL Server 2000 Database Administration Curriculum
Review: Course Overview
This curriculum presents learners with instruction of how to install, manage, monitor, and troubleshoot SQL Server 2000.

This curriculum consists of five courses:
Course 73475 Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000
Course 73476 Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases
Course 73477 Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery
Course 73478 Microsoft SQL Server 2000 Database Administration Part 4: Managing Data
Course 73479 Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000

Learn To
See individual course descriptions for specific course objectives and scope.

Audience
Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Learners are expected to have an understanding of basic relational database concepts, and should be familiar with basic transact-SQL syntax. This curriculum prepares learners for Microsoft Exam 70-228.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
CEU credits: 3.50 CEUs

Language Options
US English

Total Learning Time
30 to 40 hours




Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000
Course Overview
This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000.

Learn To

Identify the features and functions of SQL Server.
Identify the components involved in the client-server communication process.
Identify the steps in the client-server communication process.
Identify the minimum hardware requirements for SQL Server 2000.
Identify the typical hardware optimization issues for Microsoft SQL Server 2000.
Select an appropriate edition of SQL Server 2000.
Identify the different types of SQL Server 2000 installations.
Install a default instance of SQL Server 2000.
Sequence the stages of an unattended installation.
Identify the types of SQL Server databases.
Identify the database objects related to SQL Server.
Identify the features of the SQL Server 2000 object-naming standard.

Audience
Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: SQL Server 2000 Overview 1 - 2 hours

Identify the features and functions of SQL Server.
Identify the components involved in the client-server communication process.
Identify the steps in the client-server communication process.
Identify the features and functions of SQL Server services.
Identify the activities associated with administering a SQL Server database.
Identify the steps associated with implementing a SQL Server database.
Identify the types of application architecture.

Unit 2: Planning the Installation 1 - 2 hours

Identify the minimum hardware requirements for SQL Server 2000.
Identify the typical hardware optimization issues for Microsoft SQL Server 2000.
Select an appropriate edition of SQL Server 2000.
Identify guidelines for selecting SQL Server 2000 service logon accounts.
Identify the features of instances of a SQL Server.
Identify guidelines for selecting an authentication mode.
Select appropriate server collations and sort rules.
Identify the characteristics of network libraries.
Configure an appropriate network library.

Unit 3: Installation Process 2 hours

Identify the different types of SQL Server 2000 installations.
Install a default instance of SQL Server 2000.
Sequence the stages of an unattended installation.
Identify the characteristics of a remote installation.
Identify the features of SQL Server 2000 components after installation.
Identify different methods of managing SQL Server 2000 services.
Connect to a SQL Server 2000.
Verify the installed version of SQL Server.
Identify the features of registering SQL Server.
Configure registration information in SQL Server Enterprise Manager.
Create shared registration information.
Identify how SQL Server 2000 communicates installation problems.
Identify guidelines for troubleshooting SQL Server 2000 installation problems.
Review the SQL Server error logs.
Identify considerations for upgrading from SQL Server 7.0 to SQL Server 2000.
Perform an upgrade from SQL Server 6.5 by using the Upgrade Wizard.

Unit 4: Database Creation 2 hours

Identify the types of SQL Server databases.
Identify the database objects related to SQL Server.
Identify the features of the SQL Server 2000 object-naming standard.
Identify the effects of the database creation process.
Identify the available options during database creation.
Create a database by using the Create Database Wizard.
Create a database by using SQL Server Enterprise Manager.
Create a database by using Transact-SQL statements.