This course is created to provide you with the ideal amount of internal knowledge as well as a variety of real-world tuning and optimization methods.
Course Price : $2295 Per Participant
This course is created to provide you with the ideal amount of internal knowledge as well as a variety of real-world tuning and optimization methods.
The course provides in-depth instruction on the architecture of SQL Server, techniques for indexing and analytics, how to optimize transaction log activities, how to configure tempdb and data files, how to deal with transactions and isolation levels, and how to deal with locking and blocking.
The course also covers how to benchmark SQL Server performance, set baselines, analyze workload, identify performance issues, and resolve them.
A description of in-memory tables and stored procedures is presented, as well as an introduction to this fascinating new technology.
Courses
Years of Experience
Global Learners
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
Lab 1: Course Overview
After completing this module, students will be able to:
In this module, we will examine the new Cardinality Estimator, explore memory-optimized tables, and explain how SQL both stores and locates data.
Lessons
Lab 1: SQL 2014 Architecture
After completing this module, students will be able to:
The SQL Server Database Engine is split into two major components, which are the storage engine and the relational engine. The relational engine is also called the query processor which is a more descriptive term for what it actually does. In this module, we explore how the engines works, and cover concepts that will help you to understand their behavior.
Lessons
Lab 1: The Database Engine
After completing this module, students will be able to:
SQL provides a number of robust monitoring tools and in this module we explore the tools available and explain what they are designed to do.
Lessons
Lab 1: SQL Performance Tools
After completing this module, students will be able to:
SQL Server query optimization remains a very important part of today’s database applications. In this module we examine the tuning process, options for troubleshooting, execution plans, Performance Monitor, and much more.
Lessons
Lab 1: Query Optimizing and Operators
After completing this module, students will be able to:
The entire concept of indexing is speedy retrieval. In this module we explain everything you need to know about creating, utilizing, managing, and monitoring indexes.
Lessons
Lab 1: Understanding Indexes
After completing this module, students will be able to:
Statistics are considered one of the most important aspects of SQL Server Performance Tuning. In this module we examine statistics and how to utilize them.
Lessons
Lab 1: Understanding Statistics
After completing this module, students will be able to:
The most important new feature in SQL Server 2014 is the new In-Memory OLTP engine. In this module we will cover the architecture, restrictions, and other exciting features.
Lessons
Lab 1: In-Memory Database
After completing this module, students will be able to:
The SQL Server 2014 Profiler is essentially the same as the SQL Server 2012 Profiler. This is not surprising because many new features that were added in SQL Server 2005 and SQL Server 2008 addressed gaps identified in previous versions. In this module, we cover both SQL Profiler and SQL Trace.
Lessons
Lab 1: SQL Profiler and SQL Trace
After completing this module, students will be able to:
In this module, we will examine query issues, how to identify them, and how to resolve them. We’ll also cover query hints, plan guides, and explore plan freezing.
Lessons
Lab 1: Query Issues and Hints
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved