Performance Tuning and Optimizing SQL Databases (3 days)

Acuity Training London
4.5
2 reviews
  • At the end of the course I had so much new to apply in my job. I very much enjoyed the ay at training.
    ← | →
  • After joining this course I could feel the rise in my knowledge and overall personality. Our trainer Tina Williams was very dedicated to her students and would give time to their problems.
    ← | →

Course

In London

Price on request

The best Performance courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    3 Days

This instructor-led course is intended for students who manage and maintain Microsoft® SQL Server® databases with the knowledge and skills needed to performance tune and optimise their databases.

Facilities

Location

Start date

London
See map
99 Bishopsgate, EC2M 3XD

Start date

Different dates availableEnrolment now closed

About this course

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
Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and
Describe architectural concepts of the Optimizer and how to identify and fix query plan
Describe architectural concepts, troubleshooting scenarios and best practices related to Plan
Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended
Explain data collection strategy and techniques to analyze collected
Understand techniques to identify and diagnose bottlenecks to improve overall performance

This course is intended for database professionals who needs to fulfil a database role with the view of optimising performance of the databases or whose role has expanded to include database technologies.

This course requires that you meet the following prerequisites:

Working knowledge of Transact-SQL (ability to write Transact-SQL queries)
Working knowledge of database administration and maintenance.
Core Windows Server skills.
Writing Queries Using Microsoft® SQL Server® 2012/2014 Transact-SQL.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5
  • At the end of the course I had so much new to apply in my job. I very much enjoyed the ay at training.
    ← | →
  • After joining this course I could feel the rise in my knowledge and overall personality. Our trainer Tina Williams was very dedicated to her students and would give time to their problems.
    ← | →
100%
4.9
excellent

Course rating

Recommended

Centre rating

Trusted Customer

5.0
11/02/2018
What I would highlight: At the end of the course I had so much new to apply in my job. I very much enjoyed the ay at training.
What could be improved: Nothing
Would you recommend this course?: Yes

Trusted Customer

4.0
12/01/2018
What I would highlight: After joining this course I could feel the rise in my knowledge and overall personality. Our trainer Tina Williams was very dedicated to her students and would give time to their problems.
What could be improved: Nothing
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Statistics
  • Database training
  • Database
  • Server
  • Monitoring
  • Management
  • Performance Management
  • Systems Architecture
  • Systems Engineering Management
  • System Operation
  • Systems Administration
  • Windows
  • Database Management
  • SQL
  • SQLite
  • Systems Engineering
  • Team Training
  • Programming
  • SQL Database
  • SQL Server
  • Management training
  • Sql training
  • SQLOS
  • SQL Server Scheduling
  • I/O

Course programme

Module 1: SQL Server Architecture, Scheduling, and Waits
  • Module Overview
  • Lesson 1: SQL Server Components and SQLOS
  • Lesson 2: Windows Scheduling vs. SQL Server Scheduling
  • Lesson 3: Waits and Queues
  • Lab: SQL Server Architecture, Scheduling, and Waits
Module 2: SQL Server I/O
  • Module Overview
  • Lesson 1: Core Concepts of I/O
  • Lesson 2: Storage Solutions
  • Lesson 3: I/O Setup and Testing
  • Lab: Testing Storage Performance
Module 3: Database Structures
  • Module Overview
  • Lesson 1: Database Structure Internals
  • Lesson 2: Data File Internals
  • Lesson 3: tempdb Internals
  • Lab: Database Structures
Module 4: SQL Server Memory
  • Module Overview
  • Lesson 1: Windows Memory
  • Lesson 2: SQL Server Memory
  • Lesson 3: In-Memory OLTP
  • Lab: SQL Server Memory
Module 5: SQL Server Concurrency
  • Module Overview
  • Lesson 1: Concurrency and Transactions
  • Lesson 2: Locking Internals
  • Lab: Concurrency and Transactions
Module 6: Statistics and Index Internals
  • Module Overview
  • Lesson 1: Statistics Internals and Cardinality Estimation
  • Lesson 2: Index Internals
  • Lesson 3: Columnstore Indexes
  • Lab: Statistics and Index Internals

Module 7: Query Execution and Query Plan Analysis
  • Module Overview
  • Lesson 1: Query Execution and Query Optimizer Internals
  • Lesson 2: Query Execution Plans
  • Lesson 3: Analyzing Query Execution Plans
  • Lab: Query Execution and Query Plan Analysis
Module 8: Plan Caching and Recompilation
  • Module Overview
  • Lesson 1: Plan Cache Internals
  • Lesson 2: Troubleshooting with the Plan Cache
  • Lesson 3: Query Store
  • Lab: Plan Caching and Recompilation
Module 9: Extended Events
  • Module Overview
  • Lesson 1: Extended Events Core Concepts
  • Lesson 2: Working with Extended Events
  • Lab: Extended Events
Module 10: Monitoring, Tracing, and Baselines
  • Module Overview
  • Lesson 1: Monitoring and Tracing
  • Lesson 2: Baselining and Benchmarking
  • Lab: Monitoring, Tracing, and Baselining

See related categories

Performance Tuning and Optimizing SQL Databases (3 days)

Price on request

The best Performance courses

See all

See all