Discover Classes. Earn 10% Rewards.

Performance Tuning and Optimizing SQL Databases is unfortunately unavailable

Performance Tuning and Optimizing SQL Databases

  • All levels
  • 18 and older
  • $2,380
  • Earn 23,800 reward points
  • 220 Athens Way, Nashville, TN
  • 32 hours over 4 sessions
Performance Tuning and Optimizing SQL Databases
Sold Out

Start Dates (0)

  • $2,380
  • 32 hours over 4 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql class:

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Prerequisites


In addition to their professional experience, students who attend this training should already have the following technical knowledge: Basic knowledge of the Microsoft Windows operating system and its core functionality; Working knowledge of database administration and maintenance; Working knowledge of Transact-SQL.

Target Audience

The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

After completing this course, students will be able to:
  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.

Refund Policy

If it becomes necessary to reschedule or cancel a registered class, students must provide advance notice in writing to the Educational Consultant five business days prior to the start of the class. For rescheduling purposes, this action will allow the student to select an alternate class without penalty.

  • If a student withdraws from the institution on or before the first class day, or fails to begin a class, the refund shall equal the sum of all amounts paid or to be paid by or on behalf of the student for the program, less an administrative fee of $100.00.
  • If after a class has begun and before the expiration of 10% of their program for which he or she was charged, a student withdraws, drops out, or otherwise fails to attend classes, the refund shall equal 75% of all amounts paid or to be paid by or on behalf of the student for the program, less a $100 administrative fee per course.
  • If after expiration of 10% of the program for which he or she was charged, and before expiration of 25% of the period, a student withdraws, drops out or otherwise fails to attend classes, the refund shall equal 25% of all amounts paid or to be paid on behalf of the student for the program, less administrative fee of $100 per course. If after expiration of 25% of the program for which he or she was charged, a student withdraws, drops out or otherwise fails to attend classes, the student may be deemed obligated for 100% of the tuition, fees and other charges assessed by the institution.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 23800 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Nashville

With a convenient location in Nashville, New Horizons provides classes on a variety of technical and business applications. We offer an extensive selection of vendor-authorized training classes for top technology providers like Adobe, Cisco, Citrix, Microsoft, and VMware.

New Horizons of Nashville understands...

Read more about New Horizons Nashville

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Nashville educator.

New Horizons Nashville

New Horizons Nashville

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...