|
Module 1: SQL Server Overview
Lessons
- What Is SQL Server
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server
After completing this module, students 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.
Top
Module 2: Planning to Install SQL Server
Lessons
- Hardware Installation Considerations
- SQL Server 2000 Editions
- Software Installation Considerations
- Methods of Installing SQL Server
- Verifying the Installation
- Configuring SQL Server Enterprise Manager
- Troubleshooting
After completing this module, students 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.
Top
Module 3: Managing Database Files
Lessons
- 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
After completing this module, students 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.
Top
Module 4: Managing Security
Lessons
- 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
After completing this module, students 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.
Top
Module 5: Performing Administrative Tasks
Lessons
- Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance TasksCreating AlertsTroubleshooting SQL Server AutomationAutomating Multiserver Jobs
The following labs are covered in this module:
- Configuring SQL Server
- Creating Jobs and Operators
- Creating Alerts
After completing this module, students 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.
Top
Module 6: Backing Up Databases
Lessons
- 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
After completing this module, students 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.
Top
Module 7: Restoring Databases.
Lessons
- SQL Server Recovery Process
- Preparing to Restore a Database
- Restoring Backups
- Restoring Databases from Different Backup Types
- Restoring Damaged System Databases
After completing this module, students 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.
Top
Module 8: Monitoring SQL Server for Performance
Lessons
- Why to Monitor SQL Server
- Performance Monitoring and Tuning
- Tools for Monitoring SQL Server
- Common Monitoring and Tuning Tasks
After completing this module, students 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.
Top
Module 9: Transferring Data
Lessons
- Introduction to Transferring Data
- Tools for Importing and Exporting Data in SQL Server
- Introduction to DTS
- Transforming Data with DTS
After completing this module, students will be able to
- Describe the rationale for, and the process of, importing, exporting, and transforming data.
- Describe the tools for importing and exporting data in SQL Server 2000.
- Transform data by using Data Transformation Services (DTS).
- Create and edit a DTS package by using the DTS Import and DTS Export Wizards.
Top
Module 10: Maintaining High Availability
Lessons
- Introduction to Availability
- Increasing Availability Using Failover Clustering
- Standby Servers and Log Shipping
After completing this module, students will be able to
- Determine availability requirements and strategies for a Microsoft Windows Server System™ environment.
- Use SQL Server failover clustering.
- Configure a standby server and use log shipping to maintain its integrity.
Top
Module 11: Introducing Replication
Lessons
- Introduction to Distributed Data
- Introduction to SQL Server Replication
- SQL Server Replication Agents
- SQL Server Replication Types
- Physical Replication Models
After completing this module, students will be able to
- Describe the various methods to distribute data in SQL Server 2000.
- Explain the publisher-subscriber metaphor, including articles, publications, and subscriptions.
- Describe SQL Server replication agents.
- Explain the SQL Server replication types.
- Describe the physical replication models.
Top |
