Administering a Microsoft
SQL Server 2000 Database
At the end of the course the delegate will be able to complete the following:
SQL Server Overview Determine when and how to use filegroups to
optimise a database.
COMPUTER TRAINING What Is SQL Server Optimise a database by using filegroups with
SQL Server Integration hardware-based RAID.
The key to a better future SQL Server Databases Estimate the amount of space that a database
SQL Server Security requires.
Working with SQL Server
Lab: SQL Server Overview
SQL SERVER Describe SQL Server 2000 and its supported
Implementing an Authentication Mode
Assigning Logins to Users and Roles
operating system platforms. Assigning Permissions to Users and Roles
Course No. 2072 Describe SQL Server architecture. Managing Security Within SQL Server
Describe SQL Server databases. Managing Application Security
Describe SQL Server security.
5 Days Describe SQL Server querying, implementation,
Managing SQL Server Security in the
administration, and data warehousing Lab: Managing Security
activities, as well as client application design Lab: Managing Permissions
options. Lab: Managing Application Security
This course provides students with the
Planning to Install SQL Server Skills:
knowledge and skills required to install,
Hardware Installation Considerations
Implement Windows Authentication Mode
configure, administer, and troubleshoot the and Mixed Authentication Mode.
client-server database management system SQL Server 2000 Editions Assign login accounts to database user
of Microsoft SQL Server 2000. Software Installation Considerations accounts and roles.
Methods of Installing SQL Server Assign permissions to user accounts and roles.
Pre-requisites: Verifying the Installation Manage security within SQL Server.
Before attending this course, students Configuring SQL Server Enterprise Manager Manage security with views and stored
should have the following pre-requisites: Troubleshooting procedures.
Experience using the Microsoft Windows Lab: Installing SQL Server Create and use application roles to manage
2000 operating system or attendance on
Skills: application security.
courses 2151, Microsoft Windows 2000
Network and Operating System Essentials
Determine hardware requirements for SQL Manage SQL Server security in the enterprise
and 2152, Implementing Microsoft Server 2000 and the SQL Server management environment.
Windows 2000 Professional and Server. tools.
An understanding of basic relational Describe the various SQL Server Editions. Performing Administrative
Describe the different types of licensing.
database concepts or attendance on
1609, Designing Data Services and Data Determine software installation options that Tasks
Models. are appropriate for your environment. Configuration Tasks
Knowledge of basic Transact-SQL syntax Describe various methods of installing an Routine SQL Server Administrative Tasks
or attendance on 2071, Querying instance SQL Server and install it by using SQL Automating Routine Maintenance Tasks
Microsoft SQL Server 2000 with Transact- Server Setup. Creating Alerts
SQL. Verify the installation of SQL Server. Troubleshooting SQL Server Automation
Familiarity with the role of the database Configure SQL Server Enterprise Manager. Automating Multiserver Jobs
administrator. Troubleshoot the installation. Lab: Configuring SQL Server
Lab: Creating Jobs and Operators
Purpose: Managing Database Files Lab: Creating Alerts
At the end of the course, students will be Introduction to Data Structures Skills:
able to describe SQL Server architecture, Creating Databases Perform common SQL Server configuration
plan for a SQL Server installation, manage Managing Databases tasks.
files and databases, including determining
Placing Database Files and Logs Describe how to upgrade SQL Server
resource requirements, choose a login
security method, configure, plan and
Optimising the Database by Using Hardware- version 6.5 and SQL Server 7.0 to SQL
based RAID Server 2000.
implement database permissions, and
Optimising the Database by Using Filegroups Describe routine database administration
describe how to secure SQL Server in an
Optimising the Database by Using Filegroups tasks.
enterprise network, perform and automate
administrative tasks and create custom with Hardware-based RAID Automate routine maintenance tasks by
administrative tools, implement a backup Capacity Planning creating and scheduling jobs.
strategy, restore databases, monitor and Performance Considerations Create alerts and operators.
optimise SQL Server performance, migrate Lab: Managing Database Files Troubleshoot automated jobs, alerts, or
data into databases, describe how to Skills: notifications.
replicate data, maintain the high-availability Describe how SQL Server stores data and Automate administrative jobs in a multiserver
of SQL Server. handles transactions. environment.
Create a database, including specifying options
during and after database creation.
Grow, shrink, or delete a database.
Determine the placement of database files and
transaction logs for performance and fault
Optimise a database by using hardware-based
Backing Up Databases Maintaining High Availability
Preventing Data Loss Introduction to Availability
Setting and Changing a Database Recovery Increasing Availability Using Failover Clustering
Model Standby Servers and Log Shipping
SQL Server Backup Lab: Automating the Maintenance of a Standby
When to Back Up Databases Server
Performing Backups Skills:
Types of Backup Methods Determine availability requirements and
Planning a Backup Strategy strategies for a Microsoft Windows Server
Performance Considerations System environment.
Backing Up Databases Use SQL Server failover clustering.
Skills: Configure a standby server and use log shipping
Create backup files and backup sets. to maintain its integrity.
Back up user and system databases by using
Transact-SQL and SQL Server Enterprise Introducing Replication
Manager. Introduction to Distributed Data
Back up databases that are created on multiple Introduction to SQL Server Replication
files and filegroups. SQL Server Replication Agents F1 COMPUTER
Apply the appropriate backup options to each of SQL Server Replication Types
the different SQL Server 2000 backup methods. Physical Replication Models TRAINING SERVICES
Use the BACKUP LOG statement to back up and Lab: Implementing Replication
clear transaction logs.
Design an appropriate backup strategy.
Describe the various methods to distribute data THE KEY TO A
Restoring Databases in SQL Server 2000. BETTER FUTURE
Explain the publisher-subscriber metaphor,
SQL Server Recovery Process including articles, publications, and
Preparing to Restore a Database subscriptions.
Restoring Backups Describe SQL Server replication agents.
for further information…
Restoring Databases from Different Backup Explain the SQL Server replication types.
Restoring Damaged System Databases
Describe the physical replication models. call us on
Lab: Restoring Databases
Skills: 0800 169 1890
Describe the SQL Server recovery process.
Verify backups and perform specific tasks that
enable the restore process.
Use the RESTORE statement to get information
about a backup file before you restore a SYSTEMS LTD
database, file, or transaction log. 3 Kelso Place
Restore backups from different backup types and Upper Bristol Road
use the appropriate options.
Restore damaged system databases. BATH BA1 3AU
Monitoring SQL Server for Fax: 01225 444728
Why Monitor SQL Server firstname.lastname@example.org
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks www.f1comp.co.uk
Lab: Monitoring SQL Server
Describe the reasons why monitoring SQL
Server 2000 is important. LONDON BATH OR ONSITE
Develop a performance monitoring and tuning
Describe the tools available for monitoring SQL
Perform common monitoring and tuning tasks by
using counters and appropriate tools.
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL
Introduction to DTS
Transforming Data with DTS
Lab: Transferring Data For the latest available price,
Skills: please see the course page on
Describe the rationale for, and the process of, www.f1comp.co.uk,
importing, exporting, and transforming data.
Describe the tools for importing and exporting
or call 01225 336096.
data in SQL Server 2000.
Transform data by using Data Transformation
Services (DTS). Maximum of 6 people on each
Create and edit a DTS package by using the DTS course at F1’s training facilities
Import and DTS Export Wizards.
in London and Bath