SkillSoft - Catalog

Home > Catalog > Catalog - Detail

Microsoft SQL Server 2000 Installation and Administration Expert Encore

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

Overview/Description
This course takes a real-world approach to providing students the knowledge and practice required to successfully administer Microsoft SQL Server 2000. Essential database administration skills like managing, distributing and securing data, effectively implementing fault tolerance to achieve high availability via replication and redundancy are explored. Additionally, our expert instructors provide best practices for monitoring, optimization and tuning then emphasize advanced troubleshooting methods to best enable DBAs to isolate and proactively eliminate database and SQL Server-related network problems. SQL Server 2000 is a key component of Microsoft's .NET infrastructure and students will obtain the requisite skill sets to effectively administer a database being leveraged by .NET-enabled applications.

Target Audience
Candidates for this course operate in small to very large computing environments that use Microsoft SQL Server 2000. Prospective students should be familiar with relational databases and how they are implemented. They should also be in a role or support role that requires they maintain a SQL Server database.

Prerequisites
To fully benefit from this course, students should have knowledge and experience using the Microsoft Windows 2000 operating system to:

Configure the Windows 2000 environment
Create and manage user accounts
Manage access to resources using groups
Configure and manage disks and partitions, including disk striping and mirroring
Manage data using NTFS
Implement Windows 2000 security
Optimize performance in Windows 2000

Students should also have knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements.)

Certification
MCDBA SQL Server 2000, MCSE 2003

Exams
70-228

Included Labs

Using SQL Query Analyzer
Querying System Tables Directly
Stored Procedures and System Functions
Querying Using Information Schemas
Installing SQL Server 2000
Performing an Unattended Installation
Starting SQL Server Services
Using OSQL to Send Queries
Generating a T-SQL Script
Creating a Database
Config. Automatic Filegrowth Settings
Creating a Dedicated User Account
Creating a Login Directly
Viewing Security Access Information
Creating Application Roles
Testing Permission Conflicts
Using Roles to Secure Databases
Granting Object Permissions
Creating and Testing Roles
Setting Up a Linked Server
Creating Operators
Create Jobs with SQL Server Enterp. Mgr
Creating a Performance Alert
Perform Backups Using T-SQL
Creating Backup Devices
Backing Up with Enterprise Manager
Restoring a Database
Restoring to a Specified Time
Attaching a Database
Monitoring System Resources
Using the DTS Import/Export Wizard
Modify Tables with Import/Export Wizard
Importing Data Using BCP
Creating a Standby Server
Configuring a Distributor
Transactional Publication
Creating a Push Subscription
Replication with Enterprise Manager

Outline
Microsoft SQL Server 2000 Installation and Administration

Chapter 1: SQL Server Introduction

SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Using SQL Query Analyzer
Querying System Tables Directly
Stored Procedures and System Functions
Querying Using Information Schemas

Chapter 2: SQL Server Installation

Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Installing SQL Server 2000
Performing an Unattended Installation
Starting SQL Server Services
Using OSQL to Send Queries
Generating a T-SQL Script

Chapter 3: Database Management

3-7 Creating Databases
3-13 Managing Databases
Optimizing a Database Using Filegroups
Capacity Planning
Creating a Database
Config. Automatic Filegrowth Settings

Chapter 4: SQL Server Security

Assigning Login Accounts to Users and Roles
Assigning Login Accounts to Roles
Assigning Permissions to Users and Roles
Managing Application Security
Managing SQL Server Security in the Enterprise
Creating a Dedicated User Account
Creating a Login Directly
Viewing Security Access Information
Creating Application Roles
Testing Permission Conflicts
Using Roles to Secure Databases
Granting Object Permissions
Creating and Testing Roles

Chapter 5: Automating Administrative Tasks

Automating Routine Maintenance Tasks
Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs
Setting Up a Linked Server
Creating Operators
Create Jobs with SQL Server Enterp. Mgr
Creating a Performance Alert

Chapter 6: Database Backups

Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Backing Up to a Tape Device
Types of Backup Methods
Performing a Transaction Log Backup
Performing a Database File or Filegroup Backup
Planning a Backup Strategy
Perform Backups Using T-SQL
Creating Backup Devices
Backing Up with Enterprise Manager

Chapter 7: Database Restores

Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Restoring a Database
Restoring to a Specified Time
Attaching a Database

Chapter 8: SQL Server Optimization

Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks
Monitoring System Resources

Chapter 9: Data Manipulation and Sharing

Introduction to DTS
Transforming Data with DTS
Using the DTS Import/Export Wizard
Modify Tables with Import/Export Wizard
Importing Data Using BCP

Chapter 10: Implementing Data Redundancy

Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping
Creating a Standby Server

Chapter 11: Data Replication

Introduction to SQL Server Replication
SQL Server Replication Types
Physical Replication Models
Configuring a Distributor
Transactional Publication
Creating a Push Subscription
Replication with Enterprise Manager

Expected Duration (hours)
30.0

Lesson Objectives

Microsoft SQL Server 2000 Installation and Administration Expert Encore

Describe SQL Server architecture

Plan for a SQL Server installation, and then install an instance of Microsoft SQL Server

Manage files and databases, including determining resource requirements

Choose a login security method, configure login security, plan and implement database permissions, and describe how to secure SQL Server in an enterprise network

Perform and automate administrative tasks and create custom administrative tools

Back up databases and implement a backup strategy

Restore databases and implement a restore strategy

Monitor and optimize SQL Server performance

Transfer and migrate data into databases

Maintain high availability of SQL Server

Describe how to distribute data from one SQL Server to another using replication

Course Number:
LLMS0021