Premier Home Page

Home | Training | Solutions |Contact Us

t: +44(0)20 7729 1811

 
About Us | IT Training | Financial Training | Management Training |Delegate Information
 
 
 

Welcome to Premier

Your people are your most precious asset. Whether you are an existing Premier client, or a new customer looking to experience our services for the first time, welcome

 


ADMINISTERING A MICROSOFT SQL SERVER 2000 DATABASE
DURATION – 5 DAYS

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000.


Module 1: SQL Server Overview

Take a closer look: Download Sample Module 1 (Portable Document Format, 990 KB).
The following topics are covered in this module:
- What Is SQL Server
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server

At the end of this module, you will be able to:
- Describe SQL Server 2000 and its supported operating system platforms.
- Describe SQL Server architecture.
- Describe SQL Server databases.
- Describe SQL Server security.
- Describe SQL Server querying, implementation, administration, and data warehousing activities, as well as client application design options.

Module 2: Planning to Install SQL Server
The following topics are covered in this module:
- Hardware Installation Considerations
- SQL Server 2000 Editions
- Software Installation Considerations
- Methods of Installing SQL Server
- Verifying the Installation
- Configuring SQL Server Enterprise Manager
- Troubleshooting

At the end of this module, you will be able to:
- Determine hardware requirements for SQL Server 2000 and the SQL Server management tools.
- Describe the various SQL Server Editions.
- Describe the different types of licensing.
- Determine software installation options that are appropriate for your environment.
- Describe various methods of installing an instance SQL Server and install it by using SQL Server Setup.
- Verify the installation of SQL Server.
- Configure SQL Server Enterprise Manager.
- Troubleshoot the installation.


Module 3: Managing Database Files
The following topics are covered in this module:
- 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

At the end of this module, you will be able to:
- Describe how SQL Server stores data and handles transactions.
- 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 tolerance.
- Optimize a database by using hardware-based RAID.
- Determine when and how to use filegroups to optimize a database.
- Optimize a database by using filegroups with hardware-based RAID.
- Estimate the amount of space that a database requires.

Module 4: Managing Security
Take a closer look: Download Sample Module 4 (Portable Document Format, 1.08 MB).
The following topics are covered in this module:
- 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


At the end of this module, you will be able to:
- Implement Windows Authentication Mode and Mixed Authentication Mode.
- Assign login accounts to database user accounts and roles.
- Assign permissions to user accounts and roles.
- Manage security within SQL Server.
- Manage security with views and stored procedures.
- Create and use application roles to manage application security.
- Manage SQL Server security in the enterprise environment.

 

Module 5: Performing Administrative Tasks
The following topics are covered in this module:
Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance TasksCreating AlertsTroubleshooting SQL Server AutomationAutomating Multiserver Jobs

At the end of this module, you will be able to:
- Perform common SQL Server configuration tasks.
- Describe how to upgrade SQL Server version 6.5 and SQL Server 7.0 to SQL Server 2000.
- Describe routine database administration tasks.
- Automate routine maintenance tasks by creating and scheduling jobs.
- Create alerts and operators.
- Troubleshoot automated jobs, alerts, or notifications.
- Automate administrative jobs in a multiserver environment.

Module 6: Backing Up Databases
The following topics are covered in this module:
- 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

At the end of this module, you will be able to:
- Create backup files and backup sets.
- Back up user and system databases by using Transact-SQL and SQL Server Enterprise Manager.
- Back up databases that are created on multiple files and filegroups.
- Apply the appropriate backup options to each of the different SQL Server 2000 backup methods.
- Use the BACKUP LOG statement to back up and clear transaction logs.
- Design an appropriate backup strategy.


Module 7: Restoring Databases
The following topics are covered in this module:
- SQL Server Recovery Process
- Preparing to Restore a Database
- Restoring Backups
- Restoring Databases from Different Backup Types
- Restoring Damaged System Databases

At the end of this module, you will be able to:
- 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 database, file, or transaction log.
- Restore backups from different backup types and use the appropriate options.
- Restore damaged system databases.


Module 8: Monitoring SQL Server for Performance
The following topics are covered in this module:
- Why to Monitor SQL Server
- Performance Monitoring and Tuning
- Tools for Monitoring SQL Server
- Common Monitoring and Tuning Tasks

At the end of this module, you will be able to:
- Describe the reasons why monitoring SQL Server 2000 is important.
- Develop a performance monitoring and tuning methodology.
- Describe the tools available for monitoring SQL Server.
- Perform common monitoring and tuning tasks by using counters and appropriate tools.


Module 9: Transferring Data
The following topics are covered in this module:
- Introduction to Transferring Data
- Tools for Importing


Microsoft Gold Partner

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk