Masterclass: Query Performance and Optimization

Live Virtual Class – Super Intensive Remote Training with Labs!
(9:00am – 4:00pm CET Monday to Wednesday)
2175 EUR 2575 EUR (net)
Early-bird offer valid till September 9th!

Register now

Masterclass: Query Performance and Optimization

This is an international Live Virtual Class where you will be able to share the learning experience with a group of IT pros from around the world without leaving your home or office! The class is taught fully remotely in English by CQURE Cybersecurity Experts. In order to ensure the highest quality and unique learning experience, the course is limited to 12 participants by default, or supported by an assistant instructor if the number of delegates exceeds 12. During this course, you will have the opportunity to go through CQURE’s custom lab exercises, interact with our world-renowned Expert and receive a lifelong certification after completing the course!

See the schedule of our all Live Virtual Classes

Upcoming Live Virtual Classes

Live Virtual Class Length Start Date Instructor
PAY & ENROLL 3 days-21h 30.09.2024 Damian Widera

Eligible for group discount? Click here

Loads of Knowledge

During this intense hands-on training, you will master the Query Performance and learn how to improve and optimize it in order to become a master within the SQL Server topics. This course is perfect for anyone that would like to overpower the challenges that are posed by SQL Server performance – the appropriate use of SQL Queries will help the whole environment perform in a better manner and avoid chaos which could have impacted the SQL Server.

During this training you we will go through the key aspects of running optimized queries by firstly going through the breakdown of how the queries execute and what could affect their slow performance. Later-on during the training, we will learn about the common development and design mistakes, how Query optimizer works and other key aspects of Query Performance and Optimization such as, what are the types of the indexes, how data partitioning works and why it is essential, how intelligent query processing works and many more!

The training is though and authored by one of the best Experts in the data field – Microsoft’s Data Platform MVP Damian Widera.

The course is an intense workshop! During these 3 days we recommend a good cup of coffee – this course is really intense and in order not to miss a thing you MUST stay awake!

To get more practice we offer three extra weeks of labs online!

This course is ideal for:

Enterprise administrators, infrastructure architects, security professionals, systems engineers, network administrators, IT professionals, security consultants and other people responsible for implementing network and perimeter security.

To attend this training you should have good hands-on experience in administering Microsoft SQL Server infrastructure. At least 2 years in the field is recommended.

Unique exercises:

All exercises are based on newest SQL Server 2022, Windows 10 with additional Linux and virtual network appliances that covers common scenarios. After the workshop, you will receive PowerPoint slides, tools and lab instructions.

Platform and Technical Requirements:

To participate in the course you need a stable internet connection. For best learning experience we also need you to have a webcam, headphones and a microphone. Open RDP port 3391 for the connection to the lab environment is needed as well. We will setup a secure Zoom classroom for every day of the course – we will send you a safe link to join the conference by e-mail.

Certification:

After finishing the course, you will be granted a CQURE Certificate of Completion. Please note that after completing the course you will also be eligible for CPE points!

COURSE FORMULA

Remote Delivery

We are Experts in remote delivery. In the past year, we have organized over 200 days of trainings and we have tested many solutions. The experience remains the same as in the case of face-to-face trainings – a personalized, lab intense training with a lot of interaction between you and the instructor.

Virtual Labs

You will be granted a lab access for the duration of the training and a complementary access for additional 3 weeks after the training concludes with new challenging exercise instructions. With the extra self-study materials, you will be able to refresh your knowledge, acquire new skills and practically apply the techniques you have just learned.

Lifelong Certification

What is wonderful about our certification is that it is lifetime valid with no renewal fees – the technology changes, but fundamentals and attitude remain mostly the same. Our Virtual Certificates, which entitle you to collect CPE Points, are issued via Accredible.

COURSE SYLLABUS

Module 1

How the query is executed (in-depth)

  1. Understand the query execution plan
  2. Understand the phases of the query execution
  3. How to read the query plans?
  4. What components ofquery plans affect performance?

Module 2

Identify slow queries

  1. What are the options of performance monitoring?
  2. The use of SQL Server Profiler and Extended Events

Module 3

TOP10 development and design mistakes

  1. How to desing the database properly?
  2. What to avoid when writing queries?
  3. How to fix the typical development problems?

Module 4

How server configuration affects performance

  1. Review the SQL Server configuration settings
  2. Set up the server configuration to avoid performance problems
  3. How to define policies to find bad configurations?

Module 5

Query optimizer – how it works

  1. Introduction to the query optimizer
  2. How to help query optimizer by writing better queries?
  3. What affects query optimizer in a negative way and how to avoid such situations?

Module 6

Types of indexes

  1. What are the types of the indexes?
  2. Indexes internals
  3. How to design the indexes to maximize query performance?
  4. How to maintain indexes?

Module 7

Tuning joins

  1. Types of joins
  2. How joins are represented in the query plans?
  3. How to write good query conditions and what to avoid?

Module 8

Data partitioning

  1. Introduction to data partitioning
  2. Design a partitioned table
  3. How to write code that benefits from partitioning?
  4. Maintain a partitioned table

Module 9

Materialized views

  1. Introduction to materialized views
  2. How to create and maintain a materialized view?
  3. Design considerations for creating a materialized view
  4. Performance considerations when using materialized views

Module 10

Parallel query execution

  1. How parallel query execution works?
  2. How to design a query to use parallelism efficiently?
  3. Why parallel query execution is not a good choice?
  4. Pros and cons of parallel query execution

Module 11

Hints to query optimizer

  1. Why do we use hints that affects query execution?
  2. Types of the hints
  3. Performance considerations of using the hints

Module 12

Plan Caching

  1. What is a plan cache?
  2. How to read the plan cache?
  3. How to maintain the plan cache?

Module 13

Intelligent Query Processing

  1. Introduction to the IQP – Intelligent Query Processing platform in the SQL Server
  2. What are the components of the IQP?
  3. What can be fixed by using IQP – with no code changes?
Register now

Click here to browse the modules:

YOUR TEACHER

Damian Widera

Data Platform MVP, Software Engineer, Cybersecurity Expert

Software engineer with over 20 years of professional experience in all aspects of data platform development. He has participated in a number of projects in international environments and possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects.
Damian currently focuses on building solutions based on Microsoft Azure environment including complex database driven systems, machine learning, big data processing, tuning and optimization. As an experienced trainer, speaker and columnist, he is always eager to take part in new engagements.
In 2022, for the 14th time, he has been awarded Microsoft’s Data Platform MVP. In addition, he holds various Microsoft Certifications since 2004: Microsoft Certified Trainer, Solution Developer and Application Developer for .NET, Database Administrator, as well as Microsoft Certified Solutions Expert in Data Platform.

WHO IS IT FOR?

Audience

The course is perfect for enterprise administrators, developers, data engineers, IT professionals and other people responsible for implementing and maintaining database solutions.

Recommendations

We recommend good hands-on experience in administering Microsoft SQL Server infrastructure with least 2 years in the field.

Exercises

All exercises are based on newest SQL Server 2022, Windows 10 with additional Linux and virtual network appliances that covers common scenarios.

Our students say…

“All of their classes are based on their real world experience with the products, not just the typical Official Curriculum style classes that teach you things for an exam, but that you never use. You’ll find that all of the material you’ll lrarn in the class will be used, at some point, in your security career.”

Jack Perry

Security Principal Consultant - Presido

“Totally professional, total great stuff, in-depth knowledge and a perfect Learning Atmosphere! I like it! Thanks so much for sharing your experience and knowledge!”

Martin Weber

CTO - IT.INNOVATION.4U

“I have attended CQURE’s training as someone who is not a security professional, but just an enthusiast, and I feel like I learned a A LOT. The whole training was loaded with information and nice demos of the latest technologies. On top of that — having an opportunity to ask and talk to professionals was priceless.”

Marek Chmel

SQL SERVER DBA - AT&T

×