SQL Server Training

Preferred method of contact?

SQL Server 2012: Administration Skills Upgrade



Course Number



3 Days

View Schedule

This course is ideal for database administrators who are migrating from SQL Server 2008 or 2005 to 2012. With this training, you gain the knowledge and skills to take advantage of the new administrative features and tools of SQL Server 2012 — including how to build availability solutions, develop FileTable solutions, manage contained databases, resolve performance bottlenecks, and apply columnstore indexes.

You Will Learn How To

  • Configure a contained database to achieve deployment flexibility
  • Build database high-availability solutions with AlwaysOn groups
  • Implement user-defined server roles to delegate responsibilities
  • Resolve performance problems by examining waits

Important Course Information


  • Practical DBA experience with SQL Server

Course Outline

  • Introducing the New Database Engine Features

Installing SQL Server

  • Assigning service accounts
  • Choosing installation options
  • Acquiring the AdventureWorks sample database

Exploring Licensing

  • Core vs. Server and CAL licenses
  • Maximizing virtualization opportunities
  • Upgrading to SQL Server 2012

Planning an upgrade

  • Installing the Upgrade Advisor
  • Analyzing pre-2012 databases

Migrating a legacy SQL Server database

  • Comparing an in-place upgrade with migration
  • Transferring a database to 2012
  • Implementing AlwaysOn Availability

Demystifying AlwaysOn availability groups

  • Combining clustering, mirroring and replication
  • Choosing an architecture

Configuring an availability group

  • Setting up the SQL Server group for high availability and disaster recovery
  • Monitoring with the Availability Group Dashboard

Offloading resource-intensive tasks to secondary servers

  • Taking full and transaction log backups
  • Running report queries
  • Securing SQL Server 2012

Taking advantage of user-defined server roles

  • Segregating roles and responsibilities
  • Constructing a user-defined server role

Applying new audit capabilities

  • Server-level audits
  • Auditing database events
  • Filtering audit events
  • Managing Contained Databases

Comparing contained and noncontained databases

  • Considering the advantages of contained databases
  • Handling temporary tables with a contained database
  • Avoiding collation conflicts

Developing and creating a contained database

  • Granting user access
  • Converting an old database to a contained database
  • Breaking Performance Bottlenecks in SQL Server 2012

Querying important dynamic management objects

  • sys.syscacheobjects
  • sys.dm_os_waiting_tasks
  • sys.dm_exec_query_stats
  • sys.dm_os_wait_stats
  • sys.dm_os_volume_stats
  • sys.dm_os_performance_counters

Exploring the plan cache

  • Viewing cache contents
  • Building a Database Engine Tuning Advisor (DTA) Workload

Monitoring waits and queues to improve performance

  • Contrasting waits and queues
  • Analyzing significant wait types
  • Correlating waits and queues

Simulating concurrent users

  • Investigating SQL Server Distributed Replay
  • Preprocessing the workload
  • Executing on multiple threads

Employing extended events for performance tuning

  • Modules
  • Packages
  • Events
  • Predicates
  • Constructing packages
  • Resolving blocking problems with Extended Events
  • Applying Columnstore Indexes to Decision Support Queries

Dissecting columnstore indexes

  • Comparing traditional and columnstore indexes
  • Determining when to apply a columnstore index

Improving query performance

  • Designing the index
  • Measuring the impact of the index
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Jan 25 - 27 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Mar 22 - 24 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Jul 26 - 28 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Sep 20 - 22 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here






Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."



Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 17 Credits from NASBA

This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“I have been a DBA administrator for many years and took this course to upgrade my knowledge to SQL Server 2012. Both the course and instructor totally met my expectations.”

- D. Rapier, IT Specialist/Lead Program Analyst
Social Security Administration