The SQL Server Administration Course
Duration: 5 days full time from 8am to 4pm
Venue: Cape Town
 

Outline of the SQL Course for exam 70-228 

This course explains the processes used in backing up and restoring databases and database files within an instance of SQL Server 2000 using the SQL Server Enterprise Manager and the SQL Query Analyzer. Additional topics include troubleshooting transactions and options for checking data integrity using the SQL Server Enterprise Manager or the SQL Query Analyzer for command-line actions.


Objectives:

After completing this course, students will be able to:

Recognize the differences among the three primary database backup types
Plan database backup scheduling based on backup type and recovery model selection
Determine when each of the three recovery methods should be used
Identify the types of integrity found in database implementations
Use SQL Server 2000 and Windows 2000 tools to troubleshoot transactions and perform integrity checks
Perform system monitoring using the SQL Profiler, Enterprise Manager, and Transact-SQL command-line actions

Outline:
 

SQL Server Overview
 

• What Is SQL Server
• SQL Server Integration
• SQL Server Databases
• SQL Server Security
• Working with SQL Server
 

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
 

Managing Database Files
 

• Introduction to Data Structures
• Creating Databases
• Managing Databases
• Placing Database Files and Logs
• Optimizing the Database Using Hardware-based RAID
• Optimizing the Database Using Filegroups
• Optimizing the Database Using Filegroups with Hardware-based RAID
• Capacity Planning
• Performance Considerations
 

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
 

Performing Administrative Tasks
 

• Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance TasksCreating AlertsTroubleshooting SQL Server AutomationAutomating Multiserver Jobs
 

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
 

Restoring Databases
• SQL Server Recovery Process
• Preparing to Restore a Database
• Restoring Backups
• Restoring Databases from Different Backup Types
• Restoring Damaged System Databases
 

Monitoring SQL Server for Performance

• Why to Monitor SQL Server
• Performance Monitoring and Tuning
• Tools for Monitoring SQL Server
• Common Monitoring and Tuning Tasks
 

Transferring Data

• Introduction to Transferring Data
• Tools for Importing and Exporting Data in SQL Server
• Introduction to DTS
• Transforming Data with DTS
 

Maintaining High Availability

• Introduction to Availability
• Increasing Availability Using Failover Clustering
• Standby Servers and Log Shipping
 

Introducing Replication

• Introduction to Distributed Data
• Introduction to SQL Server Replication
• SQL Server Replication Agents
• SQL Server Replication Types
• Physical Replication Models

Applicability:
This course is for anyone preparing for the Microsoft SQL 2000 Administration 70-228 certification exam or for anyone who wants to learn more about databases.

Prerequisites:
Experience with Windows NT/2000/XP and/or Unix OS.