Administering Microsoft SQL Server 2012 Databases

Course ID

16020

Course Description

Ace your preparation for the skills measured by Exam 70-462 with this course. Maximize your performance on the exam by mastering the skills and experience measured by these objectives:
  • Install and configure SQL Server
  • Maintain instances and databases
  • Optimize and troubleshoot SQL Server
  • Manage data
  • Implement security
  • Implement high availability

Prerequisites

None

Audience

This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Course Content

    Planning and Installing SQL Server 2012
  • Before You Begin
  • Planning Your Installation
  • Installing SQL Server and Related Services
  • Case Scenarios
  • Suggested Practices
  • Answers

    Configuring and Managing SQL Server Instances
  • Configuring SQL Server Instances
  • Managing SQL Server Instances
  • Case Scenarios
  • Suggested Practices
  • Answers

    Configuring SQL Server 2012 Components
  • Configuring Additional SQL Server Components
  • Managing and Configuring Databases
  • Case Scenarios
  • Suggested Practices
  • Answers

    Migrating, Importing, and Exporting
  • Migrating to SQL Server 2012
  • Exporting and Importing Data
  • Case Scenarios
  • Suggested Practices
  • Answers

    SQL Server Logins, Roles, and Users
  • Managing Logins and Server Roles
  • Managing Users and Database Roles
  • Case Scenarios
  • Suggested Practices
  • Answers

    Securing SQL Server 2012
  • Managing Database Permissions
  • Troubleshooting SQL Server Security
  • Auditing SQL Server Instances
  • Case Scenarios
  • Suggested Practices
  • Answers

    Mirroring and Replication
  • Before You Begin
  • Mirroring Databases
  • Database Replication
  • Case Scenarios
  • Suggested Practices
  • Answers

    Clustering and AlwaysOn
  • Clustering SQL Server 2012
  • AlwaysOn Availability Groups
  • Case Scenarios
  • Suggested Practices
  • Answers

    Troubleshooting SQL Server 2012
  • Working with Performance Monitor
  • Working with SQL Server Profiler
  • Monitoring SQL Server
  • Using the Data Collector Tool
  • Identifying Bottlenecks
  • Case Scenarios
  • Suggested Practices
  • Answers

    Indexes and Concurrency
  • Implementing and Maintaining Indexes
  • Identifying and Resolving Concurrency Problems
  • Case Scenarios
  • Suggested Practices
  • Answers

    SQL Server Agent, Backup, and Restore
  • Managing SQL Server Agent
  • Configuring and Maintaining a Backup Strategy
  • Restoring SQL Server Databases
  • Case Scenarios
  • Suggested Practices
  • Answers

    Code Case Studies
  • Case Study 1
  • Case Study 2
  • Case Study 3
  • Case Study 4
  • Answers

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 5 days
Price - $3095.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.