2780 Maintaining a Microsoft SQL Server 2005 Database Duration: Instructor-led Classroom Learning - 5.00 Day(s) Online Live - 10.00 Sessions Mentored Learning - Flexible Overview: 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 2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Prerequisite Comments:
Basic knowledge of the Microsoft Windows operating system and its core functionality Working knowledge of Transact-SQL Working knowledge of relational databases Some experience with database design
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