2072 - Administering a Microsoft SQL Server 2000 Database
Prerequisites: Before attending this course, students must have: Experience using the Microsoft Windows 2000 operating system to:
Connect clients running Windows 2000 to networks and the Internet
Configure the Windows 2000 environment
Create and manage user accounts
Manage access to resources by using groups
Configure and Manage disks and partitions, including disk striping and mirroring
Manage data by using NTFS
Implement Windows 2000 security
Optimise performance in Windows 2000
For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:
Course 2151, Microsoft Windows 2000 network and Operating System Essentials
Course 2152, Implementing Microsoft Windows 2000 Professional and Server
An understanding of basic relational database concepts, including:
Logical and physical database design
Data integrity concepts
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
Course 1609, Designing Data Services and Data Models
Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE and DELETE statements)
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
Course 2071, Querying Microsoft SQL Server 2000
Familiarity with the role of the database administrator
The course materials, lectures are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.
Chapter 1: SQL Server Overview
What is SQL Server
SQL Server Integration
SQL Server Database
SQL Server Security
Working with SQL Server
Chapter 2: Planning to Install SQL Server
Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting
Chapter 3: Managing Database Files
Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimising the Database Using Filegroups
Optimising the Database Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations
Chapter 4: Managing Security
Implementing an Authentication Mode
Assigning Logins to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Managing Application Security
Managing SQL Server Security in the Enterprise
Chapter 5: Performing Administrative Tasks
Configuration Tasks Routine SQL
Server Administrative Tasks
Automating Routine Maintenance
Tasks Creating Alerts
Troubleshooting SQL Server
Automation Automating
Multiserver Jobs
Chapter 6: Backing Up Databases
Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods
Planning a Backup Strategy
Performance Considerations
Chapter 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Chapter 8: Monitoring SQL Server for Performance
Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks
Chapter 9: Transferring Data
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Copyright (c) 2005 New Horizons - All Rights Reserved. Procomp Computer Services CC trading as New Horizons Computer Learning Centre. Registration No. 2002/029621/23
Add to Favourites 
Location
