Maintaining a Microsoft SQL Server 2008 Database Schedule
We can also perform this training at your location or at one of the cities listed below:
Maintaining a Microsoft SQL Server 2008 Database Overview
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
Maintaining a Microsoft SQL Server 2008 Database Course Prerequisites
- 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.
Maintaining a Microsoft SQL Server 2008 Database Course Outline
Installing and Configuring SQL Server
o Preparing to Install SQL Server
o Installing SQL Server
o Configuring a SQL Server Installation
Managing Databases and Files
o Planning Databases
o Creating Databases
o Using Policy-Based Managment
Disaster Recovery
o Planning a Backup Strategy
o Backing Up User Databases
o Restoring User Databases
o Performing Online Restore Operations
o Recovering Data from Database Snapshots
o System Databases and Disaster Recovery
Managing Security
o Overview of SQL Server Security
o Protecting the Server Scope
o Protecting the Database Scope
o Protecting the Server Scope
o Auditing Security
Transferring Data
o Overview of Data Transfer
o Introduction to SQL Server integrating Services
Automating Administrative Tasks
o Automating Administrative Tasks in SQL Server
o Using SQL Server Agent
o Creating Maintenance Plans
o Implementing Alerts
o Managing Multiple Servers
o Managing SQL Server Agent Security
Implementing Replication
o Overview of Replication
o Managing Publications and Subscriptions
o Configuring Replication in Some Common Scenarios
Maintaining High Availability
o Introduction to HIgh Availability
o Implementing Log Shipping
o Implementing Database Mirroring
o Implementing Server Clustering
o Using Distributed High Availability Solutions
Monitoring SQL Server
o Viewing Current Activitiy
o Using SQL Server Profiler
o Monitoring with DDL Triggers
o Using Event Notifications
Troubleshooting and Performance Tuning
o Troubleshooting SQL Server
o Performance Tuning in SQL Server
o Using Resource Governor
o Using Data Collector