Login to Course Campus | Call Us: 1-877-797-2799  

 

Microsoft Course Listings

Microsoft SQL Server 2008 R2 Implementation and Maintenance

Overview
Skills Taught
Audience
 Prerequisites
Outline
Duration: 6 classes
Skill Level: Intermediate
Certifications: MCTS: SQL Server 2008 R2
Delivery Type: Expert Live; Expert Encore

 

Description
Implementing and Maintaining Microsoft SQL Server 2008 R2 teaches professionals to accomplish technical tasks such as installing, configuring, maintaining, and optimizing SQL Server instances. Securing data using transparent data encryption, managing data resource usage with the resource governor and standardizing data with policies are a few of relatively new features that are covered in this class. Master data services, utility control points and deploying data-tier application packages are new to SQL Server 2008 R2 and are also taught in this class.


Skills Taught
Upon completion of the Microsoft SQL Server 2008 R2 Implementation and Maintenance, the student will be able to:

  • Install, configure and maintain SQL Server instances
  • Secure and maintain data
  • Import, export and compress data
  • Monitor, troubleshoot and optimize databases
  • Implement highly available data solutions

Audience
This course is recommended for individuals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles.

Prerequisites
Candidates for the exam should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Students who are not taking the exam but are interested in learning about SQL Server 2008 should have previous experience in database environments. These environments can be driven by any vendor’s database solution.

Outline
Module 1: Installing and Configuring SQL Server 2008
  • Plan the System
  • Install SQL Server 2008 R2
  • Configure SQL Server Instances
  • System Database
  • Configure Additional Components
Module 2: Maintaining SQL Server Databases
  • Database Files and Filegroups
  • Create and Modify Databases
  • Database Data
  • Schemas in SQL Server 2008 R2
Module 3: Data Recovery in SQL Server 2008 R2
  • Plan for a Recovery
  • Restore Data
  • Database Snapshots
Module 4: Security
  • Server-Level Security
  • Linked Servers
  • Password Policies
  • Database-Level Security
  • Permissions
  • Data Encryption
  • Auditing
Module 5: Maintaining SQL Server Instances
  • Automating Tasks
  • Policy-Based Management
Module 6: Data Management Tasks
  • Transferring Data
  • Table Indexes
  • Data Collation
  • Data-Tier Applications and Master Data Services
Module 7: Monitoring Performance, Troubleshooting and Optimizing SQL Server
  • Monitoring Activity and Performance
Module 8: SQL Server 2008 R2 Replication
  • Replication
Module 9: Maintaining High Availability
  • High Availability

Free Demo!

Want to attend a live class demonstration or get a quote for your training needs? Speak with a learning specialist today!

Name

Email

Phone Number

Company

I am interested in:

Questions or Comments