X
ODT

SQL Server Performance Tuning On-Demand Training

Starting At: $395.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

SQL Server Performance Tuning
$395
Per User Per Year
Unlimited Elite Pack
$995
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

SQL Server performance is as much an art form as it is a science. Often, a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning course is designed to provide SQL DBAs with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.

What Will You Learn?

  • SQL Server Index Tuning and Query Tuning best practices
  • To use tools such as Profiler, Extended Events and SQLIO
  • To create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns

Prerequisites


The course assumes attendees have a strong understanding of SQL Server fundamentals. For example, knowing and using the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

System Requirements


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7, Windows 8, or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio

  • AdventureWorks2012 or AdventureWorks2014 databases installed on the instance

  • AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance

Curriculum For This Course

Image

Mitchell Pearson

BI Consultant and Trainer

As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.



Related Courses

Course Info
8 Comprehensive Modules
11 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
4h 38m
Download Syllabus
Enrollment Price:
$395/Year

Share this course with your friends