Course 832: Five days; Instructor-led
Introduction
This course provides students with the knowledge and
skills required to install, configure, administer, and
troubleshoot Microsoft SQL Server™ client/server
database management system version 7.0.
At Course Completion
At the end of the course, students will be able
to:
- Describe SQL Server architecture.
- Plan for a SQL Server installation.
- Install SQL Server.
- Configure SQL Server; manage files and databases.
- Choose a login security method.
- Configure login security.
- Plan and implement database permissions.
- Back up databases.
- Restore databases.
- Automate administrative tasks using SQL Server
Agent.
- Import, export and transform data.
- Monitor and maintain SQL Server performance.
- Replicate data from one SQL Server to another.
Microsoft Certified Professional Exams
This course will help the student prepare for the
following Microsoft Certified Professional exam:
Prerequisites
- Course 922, Supporting
Microsoft Windows NT 4.0 Core Technologies, or
equivalent knowledge
- An understanding of basic relational database
concepts
- Knowledge of basic Transact-SQL syntax (SELECT,
UPDATE, and INSERT statements)
- Familiarity with the role of the database
administrator
Course Materials
The course workbook and lab book are yours to keep.
You will be provided with the following software for
use in the classroom:
- Microsoft Windows NT Server network operating
system version 4.0.
- Microsoft SQL Server version 7.0
Course Outline
Day 1
Module 1: SQL Server Overview
Topics:
What is Microsoft SQL Server
SQL Server
architecture
SQL Server security
SQL Server
databases
Working with SQL Server
Lab:
SQL Server overview
Skills:
Students will be able to:
- Describe SQL Server version 7.0 and its supported
operating system platforms.
- Describe SQL Server architecture.
- Describe SQL Server security.
- Describe SQL Server databases.
- Describe SQL Server application design options, as
well as implementation and administration activities.
Module 2: Installing and Configuring SQL Server
Topics:
Minimum hardware and software requirements
SQL
Server installation options
Running the SQL Server
setup program
Verifying the installation
Preparing
to use SQL Server
Troubleshooting
Lab:
Installing and configuring SQL Server
Skills:
Students will be able to:
- Determine minimum hardware and software
requirements for SQL Server 7.0 and the SQL Server
management tools.
- Determine the SQL Server installation options
appropriate for your system.
- Install SQL Server and SQL Server management tools
by using the SQL Server Setup.
- Verify the installation of SQL Server.
- Configure SQL Server.
- Troubleshoot the installation and configuration.
Day 2
Module 3: Managing Security
Topics:
Implementing an authentication mode
Assigning
login accounts to users and roles
Assigning
permissions to users and roles
Planning
security
Managing application security
Lab:
Managing security
Managing permissions
Managing
application security
Skills:
Students will be able to:
- Implement Microsoft Windows NT Authentication Mode
and Mixed Authentication Mode.
- Assign login accounts to database user accounts
and roles.
- Assign permissions to user accounts and roles.
- Plan a security system.
- Manage security with views and stored procedures.
- Create and use application roles to manage
application security.
Module 4: Managing Database Files
Topics:
Introduction to databases
Creating
databases
Modifying databases
Managing databases
on multiple disks
Capacity planning
Lab:
Managing database files
Skills:
Students will be able to:
- Evaluate database storage considerations.
- Create and drop a database.
- Grow or shrink a database.
- Describe options that can be set for a database.
- Describe strategies for managing databases on
multiple disks.
- Create filegroups.
- Estimate the amount of space that your database
will require.
Day 3
Module 5: Backing Up Databases
Topics:
Preventing data loss
SQL Server backup
When to
back up databases
Performing backups
Types of
backup methods
Planning a backup strategy
Lab:
Backing up databases
Skills:
Students will be able to:
- Create backup files and backup sets.
- Back up user and system databases using
Transact-SQL and SQL Server Enterprise Manager.
- Back up databases created on multiple files and
filegroups.
- Apply the appropriate backup options to each of
the different SQL Server 7.0 backup methods.
- Use the BACKUP LOG statement to back up and clear
transaction logs.
- Design an appropriate backup strategy.
Module 6: Restoring Databases
Topics:
SQL Server recovery process
Preparing to restore a
database
Restoring backups
Restoring databases
from different backup types
Using a standby SQL
Server
Restoring damaged system databases
Lab:
Restoring databases
Skills:
Students will be able to:
- Use the RESTORE statement to get information about
a backup file before restoring a database, file, or
transaction log.
- Restore backups from different backup types, and
use the appropriate options.
- Set up a standby SQL Server 7.0, and restore a
production server.
- Restore damaged system databases.
Day 4
Module 7: Automating Administrative Tasks
Topics:
Reasons to automate
Introduction to SQL Server
automation
Automating routine maintenance
tasks
Creating alerts
Troubleshooting SQL Server
automation
Automating multiserver jobs
Publishing
database data on the Web
Labs:
Creating jobs and operators
Creating
alerts
Publishing SQL Server data on the Web
Skills:
Students will be able to:
- Create and schedule jobs.
- Create alerts to respond to SQL Server 7.0 errors.
- Create operators to be notified when a job
completes or when an alert is fired.
- Create SQL Server performance condition alerts to
notify a system or database administrator of potential
problems before they occur.
- Troubleshoot potential problems when jobs or
alerts do not execute as anticipated.
- Automate administrative jobs within a multiserver
environment.
- Create a Web page using the Web Assistant Wizard.
Module 8: Transferring Data
Topics:
Introduction to importing and exporting data
Tools
for importing and exporting data in SQL
Server
Introduction to data transformation services
(DTS)
Transferring data with DTS
Lab:
Importing and exporting data
Skills:
Students will be able to:
- Describe the rationale for and process of
importing, exporting, and transforming data.
- Describe the tools for importing and exporting
data in SQL Server 7.0.
- Transform data using DTS.
- Create and edit a DTS Package using the DTS Import
and Export wizards.
Module 9: Monitoring and Maintaining SQL Server
Topics:
Why monitor SQL Server
Tools for monitoring SQL
Server
Creating a maintenance plan for SQL Server
Lab:
Monitoring SQL Server
Skills:
Students will be able to:
- Explain why monitoring SQL Server is important.
- Describe factors that affect SQL Server
performance.
- Monitor hardware performance using Windows NT
Performance Monitor.
- Use Transact-SQL tools to monitor performance.
- Monitor SQL Server 7.0 activity with SQL Server
Profiler.
- View the last 100 actions in SQL Server Profiler.
- Examine specific query performance in SQL Server
Query Analyzer.
- Develop a database maintenance plan.
Day 5
Module 10: Introducing Replication
Topics:
Introduction to distributed data
Introduction to
SQL Server replication
SQL Server replication
agents
SQL Server replication types
Physical
replication methods
Skills:
Students will be able to:
- List the various methods to distribute data.
- Describe the characteristics of SQL Server 7.0
replication.
- Explain the publisher-subscriber metaphor,
including articles, publications, and subscriptions.
- Explain filtering data for replication.
- Describe SQL Server replication agents.
- Explain the SQL Server replication types.
- Describe the physical replication models.
Module 11: Planning and Setting Up Replication
Topics:
Planning replication
Configuring network security
access
Preparing the
servers
Publishing
Subscribing
Lab:
Implementing replication
Skills:
Students will be able to:
- Address issues in planning a replication scenario.
- Identify the tasks that must be performed to
configure SQL Server for replication.
- Set up and configure a distribution server.
- Set up publication and subscription servers.
- Create publications.
- Configure synchronization.
- Set up subscriptions.
Module 12: Managing Replication
Topics:
Monitoring and troubleshooting
replication
Replicating in heterogeneous
environments
Publishing on the Internet
Lab:
Maintaining and troubleshooting replication
Skills:
Students will be able to:
- Monitor and troubleshoot replication using SQL
Server 7.0 tools, system stored procedures, and system
tables.
- Generate a replication script.
- Describe how to replicate to and from
heterogeneous databases.
- Publish on the Internet.
| 
.gif){kind=spacer}
