LOGO For Immediate Assistance Call 855-211-9361

Open Enrollment

SQL Server 2008 for Administration

Price: $2,995.00

Call for availability 855-211-9361

This instructor-led course provides you with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. You will learn to use SQL Server 2008 R2 product features and tools to install and configure a database, manage database files, and create and tune indexes.

Course Overview

What You'll Learn

  • Plan, install, and configure SQL Server 2008 R2
  • Manage database files
  • Back up and restore databases
  • Manage security
  • Implement SQL Server 2008 R2 audits
  • Configure and assign permissions
  • Monitor data by using dynamic management views
  • Manage SQL Server 2008 R2 agent and jobs
  • Execute multi-server queries and configure a central management server
  • Deploy a data-tier-application
  • Troubleshoot common issues

Course Outline

  • Introduction to SQL Server 2008 R2 and Its Toolset

    • SQL Server Platform
    • Working with SQL Server Tools
    • Configuring SQL Server Services
  • 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
  • Installing and Configuring SQL Server 2008 R2

    • Preparing to Install SQL Server 2008 R2
    • Installing SQL Server 2008 R2
    • Upgrading and Automating Installation
  • Working with Databases

    • Overview of SQL Server Databases
    • Working with Files and Filegroups
    • Moving Database Files
  • SQL Server 2008 R2 Recovery Models

    • Backup Strategies
    • SQL Server Transaction Logging
    • Planning a SQL Server Backup Strategy
  • Backup of SQL Server 2008 R2 Databases

    • Backing Up Databases and Transaction Logs
    • Managing Database Backups
    • Working with Backup Options
  • Restoring SQL Server 2008 R2 Databases

    • The Restore Process
    • Restoring Databases
    • Working with Point-In-Time Recovery
    • Restoring System Databases and Individual Files
  • Importing and Exporting Data

    • Transferring Data to/from SQL Server 2008 R2
    • Importing and Exporting Table Data
    • Inserting Data in Bulk
  • Authenticating and Authorizing Users

    • Authenticating Connections to SQL Server
    • Authorizing Logins to Access Databases
    • Authorization Across Servers
  • Assigning Server and Database Roles

    • Working with Server Roles
    • Working with Fixed Database Roles
    • Creating User-Defined Database Roles
  • Authorizing Users to Access Resources

    • Authorizing User Access to Objects
    • Authorizing Users to Execute Code
    • Configuring Permissions at the Schema Level
  • Auditing SQL Server Environments

    • Options for Auditing Data Access in SQL Server
    • Implementing SQL Server Audit
    • Managing SQL Server Audit
  • Automating SQL Server 2008 R2 Management

    • Automating SQL Server Management
    • Working with SQL Server Agent
    • Managing SQL Server Agent Jobs
  • Configuring Security for SQL Server Agent

    • SQL Server Agent Security
    • Configuring Credentials
    • Configuring Proxy Accounts
  • Monitoring SQL Server 2008 R2 with Alerts and Notifications

    • Configuration of Database Mail
    • Monitoring SQL Server Errors
    • Configuring Operators, Alerts, and Notifications
  • Performing Ongoing Database Maintenance

    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance
  • 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
  • Monitoring SQL Server 2008 R2

    • Monitoring Activity
    • Capturing and Managing Performance Data
    • Analyzing Collected Performance Data
  • Managing Multiple Servers

    • Working with Multiple Servers
    • Virtualizing SQL Server
    • Deploying and Upgrading Data-Tier-Applications
  • Troubleshooting Common SQL Server 2008 R2 Administrative Issues

    • SQL Server Troubleshooting Methodology
    • Resolving Service-Related Issues
    • Resolving Concurrency Issues
    • Resolving Login and Connectivity Issues