MS2072 - Administering a Microsoft SQL Server 2000 Database
| Categories |
Security Training, MCDBA Training, MCSE Training, Microsoft Certification Training, MCSA Training, SQL Training, Database Training, Microsoft SQL Server Training |
| Duration |
5 days (35 hours) |
| Pre-requisites |
DMD - Database Modeling and Design, MS2071 - Querying Microsoft SQL Server 2000 with Transact-SQL, MS2151 - Microsoft Windows 2000 Network and Operating System Essentials or MS2152 - Implementing Microsoft Windows 2000 Professional and Server, or equivalent knowledge and skills and experience configuring a Microsoft Windows® 2000 operating system and administering a SQL database
|
|
|
|
| Courseware |
MS2072-MS (300 pages) |
| Price |
$1975 |
| Notes |
This course covers topics students need to know to prepare for the following Microsoft exams:
Exam 70-228: System Administration for Microsoft SQL Server 2000 (MCDBA core; MCSE, MCSE 2003, MCSA and MCSA 2003 elective)
Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000
Enterprise Edition
|
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.
At the end of the course, students will be able to describe SQL Server architecture; plan for a SQL Server
installation, and then install an instance of SQL Server; manage files and databases, including determining
resource requirements; choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network; perform and automate administrative tasks and create custom administrative tools; back up databases and implement a backup strategy; restore databases; monitor and optimize SQL Server performance; transfer and migrate data into databases; maintain the high availability of SQL Server and describe how to replicate data from one SQL Server to another.
"Recommend to anyone needing to understand SQL databases and how they are setup. [The instructor] did a good job of covering all the material.." -- Eduardo Rene M. from San Diego, CA
Module 1: SQL Server Overview
What Is SQL Server
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Lab: SQL Server Overview
Module 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
Lab: Installing SQL Server
Module 3: 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
Lab: Managing Database Files
Module 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
Labs:
Managing Security
Managing Permissions
Managing Application Security
Module 5: Performing Administrative Tasks
Configuration Tasks
Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks
Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs
Labs:
Configuring SQL Server
Creating Jobs and Operators
Creating Alerts
Module 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
Lab: Backing Up Databases
Module 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Lab: Restoring Databases
Module 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
Lab: Monitoring SQL Server
Module 9: Transferring Data
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS
Lab: Transferring Data
Module 10: Maintaining High Availability
Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping
Lab: Automating the Maintenance of a Standby Server
Module 11: Introducing Replication
Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models
Lab: Implementing Replication