Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

SQL Server









Preferred method of contact?

SQL Server 2012: Administration Skills Upgrade

COURSE TYPE

Hands-On

Course Number

2105

Duration

3 Days

Enroll

About This Course: SQL Server 2012 includes an extensive array of capabilities for SQL Server administrators. Those migrating from SQL Server 2008 or SQL Server 2005 must upgrade their skills in order to leverage the enhanced feature set. This skills upgrade course provides the knowledge required to effectively take advantage of the new features in SQL Server 2012.

You Will Learn How To

  • Leverage the new SQL Server 2012 administrative features
  • Build database high-availability solutions with AlwaysOn groups
  • Implement user-defined server roles to delegate responsibilities
  • Resolve performance problems by examining waits
  • Configure a contained database to achieve deployment flexibility

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.

Oct 26 - 28 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 16 - 18 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 23 - 25 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 25 - 27 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 31 - Jun 2 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 27 - 29 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

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

Tuition

Standard

$2650

Government

$2355

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.

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."

Prev
Next

Questions

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.

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

Prev
Next