Administering a Microsoft SQL Server 2008 Database
Course: SS8ADM
Duration: 5 Days
Level: I
Course Summary
This 5-day course covers in detail how to administer Microsoft
SQL Server 2008 databases.
« Hide The Details
Topics Covered In This Course
Introduction
Installing and Configuring Microsoft SQL Server 2008
- Preparing for Installation
- Installing SQL Server 2008
- Configuring a SQL Server 2008 Installation
- Lab: Installing SQL Server 2008
- Lab: Configuring A SQL Server 2008 Installation
Managing SQL Server 2008 Databases and Files
- Planning a Database
- Creating a Database
- Managing Databases
- Creating a Policy
- Lab: Creating a Database
- Lab: Managing Filegroups
- Lab: Creating a Policy
SQL Server 2008 Security
- Security Concepts and Overview
- Hardening the Server Scope
- Hardening the Database Scope
- Using Keys and Certificates
- Lab: Creating Database Logins
- Lab: Creating and Managing Database Users
- Lab: Using Certificates
Monitoring Microsoft SQL Server 2008
- Viewing Current Database Activity
- Using System Monitor
- Using the SQL Server Profiler
- Using Data Definition Language Triggers
- Using Event Notifications
- Lab: Monitoring SQL Server Performance
- Lab: Eliminating Database Locks
- Lab: Tracing SQL Server Activity
- Lab: Implementing Data Definition Language Triggers
SQL Server Integration Services
- Overview of Microsoft SQL Server 2008 Data Transfer
- Overview of SQL Server Integration Services
- Using SQL Server Integration Services
- Lab: Creating an SQL Server Integration Services Package
- Lab: Deploying an SQL Server Integration Services Package
- Lab: Extracting Data
- Lab: Performing Lookups
- Lab: Sorting and Splitting Data
Managing Database Security
- Security Overview
- Protecting the Server Scope
- Protecting the Database Scope
- Auditing Security
- Lab: Creating Logins and Assigning Server Scope Permissions
- Lab: Creating and Managing Users
- Lab: Using Certificates
- Lab: Implementing SQL Server Audit
Disaster Recovery Options
- Overview of Backup Strategies
- Backing up Databases
- Restoring Databases
- Using Database Snapshots
- Recovering the System Database
- Lab: Implementing Backups
- Lab: Restoring and Recovering Databases
- Lab: Conducting Partial Backups and Restores
- Lab: Restoring the Master Database
Microsoft SQL Server 2008 Replication
- Database Replication Options
- Implementing Database Replication
- Configuring Database Replication
- Lab: Creating a Publication
- Lab: Creating a Subscription
- Lab: Implementing HTTP Merge Replication
Administering High-Availability Solutions
- Overview of High Availability Strategies
- Understanding Server Clustering
- Database Mirroring
- Log Shipping
- Peer-to-Peer Database Replication
- Lab: Configuring Database Mirroring
- Lab: Implementing a High-Availability Solution
Creating and Using Database Views
- Understanding Views
- Creating Views
- Optimizing Database Performance with Views
- Lab: Creating Views
- Lab: Creating Indexed Views
- Lab: Creating Partitioned Views
Creating Database Indices
- Planning Database Indices
- Creating Indices
- Improving Indices
- Creating XML Indices
- Lab: Creating Database Indices
- Lab: Optimizing Database Indices
- Lab: Creating XML Indices
Automating Tasks
- Automation in Microsoft SQL Server 2008
- Using the SQL Server Agent
- Creating Maintenance Plans
- Defining Jobs and Operators
- Defining Alerts
- Managing Multiple SQL Server 2008 Servers
- Managing SQL Server Agent Security
- Lab: Configuring SQL Server Agent
- Lab: Creating Operators and Jobs
- Lab: Creating Alerts
What You Can Expect
- Learn to Install and Configure Microsoft SQL Server 2008
- Manage Microsoft SQL Server 2008 Database Files
- Understand and Use Various Methods for Backing-up Microsoft
SQL Server 2008 Databases
- Implement and Manage Database Security
- Using SSMS
- Monitor Microsoft SQL Server Using Available SSMS
- Demonstrate Importing and Exporting Data to and from Microsoft
SQL Server 2008
- Automate Microsoft SQL Server 2008 Tasks
- Demonstrate and Implement Data Replication Between Microsoft
SQL Server 2008 Instances
- Learn About, Implement, and Maintain High Availability Solutions
Who Should Take This Course
Technology professionals interested in learning the features
and capabilities of Microsoft's SQL Server 2008 product
in order to implement databases.
Training Style
Instructor-led lecture coupled with relevant individual
activities.
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
SSADM |
SQL Server 2012 Administration |
5 Days |
I |
Details |
SSADMF |
Microsoft SQL Server 2008 System Administration Fundamentals |
3 Days |
I |
Details |
PSSQLS |
Maintaining SQL Server using PowerShell |
3 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
