This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database. At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability. |
Prerequisite(s) or equivalent knowledge: |
2779 Implementing a Microsoft SQL Server 2005 Database
50027 Querying and Processing SQL Server Data with SQL Statements |
| |
| Outline: | |
| Lesson 1: Installing and Configuring SQL Server 2005 |
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation. | |
| Lesson 2: Managing Databases and Files |
Planning databases.
Creating databases.
Managing databases. |
| Lesson 3: Disaster Recovery |
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery. |
| Lesson 4: Managing Security |
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server |
| Lesson 5: Monitoring SQL Server |
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications. | |
| Lesson 6: Transferring Data |
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Features of SQL Server Integration Services |
| Lesson 7: Automating Administrative Tasks |
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security |
| Lesson 8: Implementing Replication |
Overview of Replication.
Implementing Replication
Configuring Replication in Some Common Scenarios |
| Lesson 9: Maintaining High Availability |
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Implementing Peer-to-Peer Replication |
Add to favorites
Email this page
On-Site Training
Seminar
