Accelerated: Maintaining and Implementing a Microsoft SQL Server 2008 Database Schedule
We can also perform this training at your location or at one of the cities listed below:
Accelerated: Maintaining and Implementing a Microsoft SQL Server 2008 Database Overview
This five-day instructor-led course provides students with the knowledge and skills to implement and maintain a SQL Server 2008 Database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implement and maintain a SQL Server 2008 database.
Accelerated: Maintaining and Implementing a Microsoft SQL Server 2008 Database Course Prerequisites
Before attending this course, the student must have a basic knowledge of Microsoft Windows operating and its core functionality, a working knowledge of Transact-SQL, a working knowledge of relational databases, and some experience with database design.
Accelerated: Maintaining and Implementing 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 Management
Creating Databases and Database Files
o Creating Databases
o Creating File Groups
o Creating Schemas
o Creating Database Snapshots
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
Creating and Tuning Indexes
o Planning Indexes
o Creating Indexes
o Optimizing Indexes
Implementing Data Integrity by Using Constraints and Triggers
o Data Integrity Overview
o Implementing Contraints
o Implementing Triggers
Implementing Views
o Introduction to Views
o Creating and Managing Views
o Optimizing Performance by Using Views
Implementing Stored Procedures
o Implementing Stored Procedures
o Creating Parameterized Stored Procedures
o Working with Execution Plans
o Handling Errors
Implementing Functions
o Creating and Using Functions
o Working with Functions
o Controlling Execution Context
Managing Transactions and Locks
o Overview of Transactions and Locks
o Managing Transactions
o Understanding SQL Server Locking Architecture
o Managing Locks
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 Activity
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