Informationen über Kurs 73475 - Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000 - Online
-
Ziele
- 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.
-
Anforderungen
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.
-
Titel
Kurs 73475 - Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000
-
Inhalt
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.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: SQL Server 2000 Overview 1 - 2 hours
- 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.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
