Introduction
This five day course focuses on installing, configuring and maintaining a SQL
server 2008 database. It starts with the typical administrative topics:
installation, backup and restore, setting up security, monitoring, automating
tasks, data transfer and high availability. We also focus on topics which are
borderline between administration and development, such as index design and
maintenance and setting up statistics. We also discuss new 2008 features, such
as the resource governor, the new auditing, and the policy based management.
Learning Goals
Nearly any business application is based on a relational database to store
and deliver data. In this course, we see how to administer a database server with SQL Server
2008. But databases have become more than ‘just a bunch of tables’. In this
course, we also look at advanced database features, such as asynchronous
database communications and database monitoring and troubleshooting.
Target audience
This course is intended for IT Professionals wanting to become skilled on SQL
Server 2008 product features and technologies for maintaining a database. Prior knowledge of SQL server 2008 is not required.
Course Outline
Module 1: Installing and Configuring SQL Server 2008
Preparing to Install SQL Server, Installing SQL Server, Managing a SQL Server
Installation
Module 2: Managing Databases and Files
Planning Databases, Creating Databases, Managing Databases
Module 3: Disaster Recovery
Planning a Backup Strategy, Backing Up User Databases, Restoring User
Databases, Recovering Data from Database Snapshots, System Databases and
Disaster Recovery
Module 4: Managing Security
Overview of SQL Server Security, Securing the Server Scope, Securing the
Database Scope, Managing Keys and Certificates in SQL Server
Module 5: Monitoring SQL Server
Viewing Current Activity, Using System Monitor, Using SQL Server Profiler,
Using DDL Triggers, Using Event Notifications
Module 6: Transferring Data
Overview of Data Transfer, Introduction to SQL Server Integration Services,
Using SQL Server Integration Services
Module 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005, Configuring SQL Server
Agent, Creating Jobs and Operators, Creating Alerts, Managing Multiple Servers,
Managing SQL Server Agent Security
Module 8: Maintaining High Availability
Introduction to High Availability, Implementing Server Clustering,
Implementing Database Mirroring, Implementing Log Shipping
Module 9: Introduction to Replication
What Is Replication, Types of Replication, Server Roles in Replication, What
Are Articles, Publications, and Subscriptions, Server to Server Replication
Scenarios, Server to Client Replication Scenarios
Module 10: Managing and Automating Databases and Servers
Planning an Automated System for Database Maintenance, Planning an Automated
System for Server Maintenance, Documenting Administration and Automation
Information
Module 11: Managing SQL Server Supporting Services
Managing SSIS packages, Replication and Reporting Services
Module 12: Building a Monitoring Solution for SQL Server Performance Issues
Narrowing Down a Performance Issue to an Environment Area, Guidelines for
Using SQL Server Profiler and System Monitor, Guidelines for Auditing and
Comparing Test Results
Module 13: Troubleshooting Database and Database Server Performance Issues
Narrowing Down a Performance Issue to a Database Object, How SQL Server Profiler
Can Help Narrow a Search to a Specific Issue
Module 14: Policy based management (2008)
Defining Policies, CoModule 14: Policy based management
Defining Policies, Conditions and Facets, Monitoring policy based management,
Behind the scene: jobs, event notifications and DDL triggersp>Finetuned auditing, the Data Collector, Resource Governor, Transparent Database
Encryption
|