NewEra Technology Facebook
6231 Maintaining a Microsoft SQL Server 2008 R2 Database - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 6231 Maintaining a Microsoft SQL Server 2008 R2 Database - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 5
Course Price (CAD): 2750
Description:
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database.
The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
Prerequisites:
N/A
Outline:
Lesson 1 - Introduction to SQL Server 2008 R2 and its Toolset
◦Introduction to SQL Server Platform
◦Working with SQL Server Tools
◦Configuring SQL Server Services
◦Lab : Introduction to SQL Server 2008 R2 and its Toolset

Lesson 2 - Preparing Systems for SQL Server 2008 R2
◦Overview of SQL Server 2008 R2 Architecture
◦Planning Server Resource Requirements
◦Pre-installation Testing for SQL Server 2008 R2
◦Lab : Preparing Systems for SQL Server 2008 R2

Lesson 3 - Installing and Configuring SQL Server 2008 R2
◦Preparing to Install SQL Server 2008 R2
◦Installing SQL Server 2008 R2
◦Upgrading and Automating Installation
◦Lab : Installing and Configuring SQL Server 2008 R2

Lesson 4 - Working with Databases
◦Overview of SQL Server Databases
◦Working with Files and Filegroups
◦Moving Database Files
◦Lab : Working with Databases

Lesson 5 - Understanding SQL Server 2008 R2 Recovery Models
◦Backup Strategies
◦Understanding SQL Server Transaction Logging
◦Planning a SQL Server Backup Strategy
◦Lab : Understanding SQL Server 2008 R2 Recovery Models

Lesson 6 - Backup of SQL Server 2008 R2 Databases
◦Backing up Databases and Transaction Logs
◦Managing Database Backups
◦Working with Backup Options
◦Lab : Backup of SQL Server 2008 R2 Databases

Lesson 7 - Restoring SQL Server 2008 R2 Databases
◦Understanding the Restore Process
◦Restoring Databases
◦Working with Point-in-time Recovery
◦Restoring System Databases and Individual Files
◦Lab : Restoring SQL Server 2008 R2 Databases

Lesson 8 - Importing and Exporting Data
◦Transferring Data To/From SQL Server 2008 R2
◦Importing & Exporting Table Data
◦Inserting Data in Bulk
◦Lab : Importing and Exporting Data

Lesson 9 - Authenticating and Authorizing Users
◦Authenticating Connections to SQL Server
◦Authorizing Logins to Access Databases
◦Authorization Across Servers
◦Lab : Authenticating and Authorizing Users

Lesson 10 - Assigning Server and Database Roles
◦Working with Server Roles
◦Working with Fixed Database Roles
◦Creating User-defined Database Roles
◦Lab : Assigning Server and Database Roles

Lesson 11 - Authorizing Users to Access Resources
◦Authorizing User Access to Objects
◦Authorizing Users to Execute Code
◦Configuring Permissions at the Schema Level
◦Lab : Authorizing Users to Access Resources

Lesson 12 - Auditing SQL Server Environments
◦Options for Auditing Data Access in SQL Server
◦Implementing SQL Server Audit
◦Managing SQL Server Audit
◦Lab : Auditing SQL Server Environments

Lesson 13 - Automating SQL Server 2008 R2 Management
◦Automating SQL Server Management
◦Working with SQL Server Agent
◦Managing SQL Server Agent Jobs
◦Lab : Automating SQL Server 2008 R2 Management

Lesson 14 - Configuring Security for SQL Server Agent
◦Understanding SQL Server Agent Security
◦Configuring Credentials
◦Configuring Proxy Accounts
◦Lab : Configuring Security for SQL Server Agent

Lesson 15 - Monitoring SQL Server 2008 R2 with Alerts and Notifications
◦Configuration of Database Mail
◦Monitoring SQL Server Errors
◦Configuring Operators, Alerts and Notifications
◦Lab : Monitoring SQL Agent Jobs with Alerts and Notifications

Lesson 16 - Performing Ongoing Database Maintenance
◦Ensuring Database Integrity
◦Maintaining Indexes
◦Automating Routine Database Maintenance
◦Lab : Ongoing Database Maintenance

Lesson 17 - Tracing Access to SQL Server 2008 R2
◦Capturing Activity using SQL Server Profiler
◦Improving Performance with the Database Engine Tuning Advisor
◦Working with Tracing Options
◦Lab : Tracing Access to SQL Server 2008 R2

Lesson 18 - Monitoring SQL Server 2008 R2
◦Monitoring Activity
◦Capturing and Managing Performance Data
◦Analyzing Collected Performance Data
◦Lab : Monitoring SQL Server 2008 R2

Lesson 19 - Managing Multiple Servers
◦Working with Multiple Servers
◦Virtualizing SQL Server
◦Deploying and Upgrading Data-Tier Applications
◦Lab : Managing Multiple Servers

Lesson 20 - Troubleshooting Common SQL Server 2008 R2 Administrative Issues
◦SQL Server Troubleshooting Methodology
◦Resolving Service-related Issues
◦Resolving Concurrency Issues
◦Resolving Login and Connectivity Issues
◦Lab : Troubleshooting Common Issues
Guaranteed to run courses