Discover Classes. Earn Rewards.

Performance Tuning and Optimizing SQL Databases is unfortunately unavailable

Thankfully we have 7 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Level I

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

(680) Beginner 18 and older

SQL Level II

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.

(680) Intermediate 18 and older

SQL Level III

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(680) Advanced 18 and older

SQL Server Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

SQL Bootcamp

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

(680) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL Server classes NYC

Performance Tuning and Optimizing SQL Databases

  • All levels
  • 18 and older
  • $2,380
  • 120 S Wood Ave, Iselin, NJ
  • 32 hours over 4 sessions

Start Dates (0)

  • $2,380
  • CTG Iselin @ 120 S Wood Ave 4th Fl, Ste 405, Iselin, NJ 08830
  • 32 hours over 4 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql server training:

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.

Audience Profile
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.

At Course Completion
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

Cancellation acceptable prior to 10 days before class date.

Reviews of Classes at Corporate Training Group (4)

Similar Classes

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. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Corporate Training Group

Corporate Training Group, Inc. is a Microsoft Gold Certified Partner for Learning Solutions and Information Worker Solutions. CTG provides authorized training delivered by Microsoft Certified Instructors (MCT) using Microsoft Certified Courseware. CTG provides technical training and consulting services....

Read more about Corporate Training Group

CourseHorse Approved

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

Corporate Training Group

Corporate Training Group

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