Lab Manual for Raftree's 70-228 MCSE Guide to MS SQL Server 2000 Administration

by York-Levine, Karen

• ISBN13: 9780619120597
• ISBN10: 0619120592
• Edition: Lab
• Format: Paperback
• Copyright: 2001-12-07
• Publisher: Cengage Learning

Summary

This lab manual provides you with the hands-on instruction you'll need to prepare for the MCSE certification exam and succeed as a Microsoft network engineer or administrator. Designed for classroom-led or self-paced study, the labs offer a unique, practical approach to learning that is a key component to the MCSE exams.

Table of Contents

An Introduction to Microsoft SQL Server 2000	1	(12)
Search the Internet for Microsoft SQL Server-related Research Materials	2	(2)
Install Books Online	4	(3)
Search Books Online for the Hardware and Software Requirements for SQL Server 2000	7	(2)
Determine if your Current Hardware is SQL Server 2000 Compatible	9	(4)
Installing and Upgrading SQL Server 2000	13	(30)
Creating a User Account	14	(2)
Installing Microsoft SQL Server 2000	16	(6)
Viewing System Changes Made by SQL Server 2000 Installation	22	(5)
Installing a Second Instance of Microsoft SQL Server 2000	27	(3)
Viewing System Changes Made by Installation of a Second Instance of SQL Server 2000	30	(3)
Uninstalling a Second Instance of SQL Server 2000	33	(2)
Creating an Unattended Installation File	35	(3)
Rebuilding the Registry	38	(5)
Administering and Configuring SQL Server 2000	43	(20)
Viewing the Properties of SQL Server Using Enterprise Manager	44	(2)
Using the SQL Query Analyzer	46	(4)
Using the Sp_configure System Stored Procedure to Alter Configuration Settings	50	(3)
Creating a Linked Server Using Enterprise Manager	53	(4)
Using the Osql Utility	57	(2)
Using the Sqldiag Utility	59	(4)
SQL Server 2000 Database Architecture	63	(16)
Exploring System and User Tables using SQL Query Analyzer	64	(3)
Exploring System and User-Defined Data Types Using SQL Enterprise Manager	67	(4)
Exploring Defaults and Constraints	71	(3)
Exploring Indexes	74	(5)
Creating SQL Server 2000 Databases	79	(28)
Exploring the System Databases	80	(2)
Creating a Database	82	(5)
Expanding and Shrinking a Database	87	(5)
Changing Database Options; Renaming and Deleting Databases	92	(6)
Creating Tables in a Database	98	(3)
Creating a Foreign Key Relationship	101	(6)
Optimizing and Troubleshooting Databases	107	(14)
Recreating Indexes to Change the Fill Factor	108	(3)
Using an Execution Plan to Create Statistics	111	(4)
Recompiling Stored Procedures	115	(2)
Using SQL Profiler to Monitor Stored Procedures	117	(4)
Performing Disaster Recovery Operations	121	(26)
Setting the Recovery Model for Databases	122	(3)
Creating Backup Devices	125	(3)
Performing Windows 2000 and Database Backups	128	(6)
Recovering the System State and Restoring Databases	134	(5)
Performing Integrity Checks on a Database Using DBCC Commands	139	(2)
Creating a Database Maintenance Plan	141	(6)
Security in SQL Server 2000	147	(28)
Creating SQL Server 2000 Logins	148	(7)
Creating Database Users	155	(4)
Creating User-Defined Database Roles	159	(4)
Setting Statement and Object Permissions	163	(5)
Testing Logins, Users, Roles, and Permissions	168	(7)
Extracting and Transforming Data with SQL Server 2000	175	(16)
Loading Data With BULK INSERT	176	(3)
Using the Data Transformation Services	179	(4)
Setting up Merge Replication	183	(4)
Supporting XML in Microsoft SQL Server 2000	187	(4)
Automating and Monitoring SQL Server 2000	191
Configuring SQL Server Agent	192
Creating Operators	195
Creating Jobs	198
Creating Alerts	203