fbpx
cybersecurity
education
€ EUR
  • $ USD
  • € EUR
  • #course
  • #livevirtualclass

Query Performance and Optimization

Live Virtual Class - Super Intensive Remote Training with Labs!
September 30, 2024, 9:00 am
Days
Hours
Min.
Sec.

During this 3-day course in 21 hours of super intensive training you will gain crucial cybersecurity knowledge and skills in terms of Qurey Performance and Optimization. Moreover, you will be able to:

    • Get the highest quality and unique learning experience – the class is limited to 10 participants by default.
    • Get the opportunity to interact with our world-renowned Experts.
    • Go through CQURE’s custom lab exercises and practice them after the course.
    • Receive a lifelong certification after completing the course!

 

(9:00am – 4:00pm CEST/CET Monday to Wednesday)

Early-bird offer valid till August 26th!

Original price was: €2575.Current price is: €2175.

/ Lowest price within 30 days: €2175 (net)

Why this course?

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!

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!

Pricing plan

We offer you pricing plan designed and adjusted to your specific needs and budget. Buy now or book your spot and pay later.

Course timeline

  • 1. Before the course

    You will receive a Student Guide with instruction on how to prepare for the training, information regarding all the technical requirements and your own individual login credentials to the virtual environment.

  • 2. During the course

    You will be able to exercise and review all learned content on an ongoing basis.

  • 3. After the course

    You will receive a Certificate of Completion, all the materials which have been created and presented by the trainer as well as an access to our community on the Discord server.

Course benefits

How our lessons look like

  • Loads of Knowledge
  • Implementation workshop
  • Course materials
  • Unique exercises
  • Certification

Loads of Knowledge

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!

Implementation workshop

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.

Course materials

During the course you will be provided with a bunch of materials such as lab exercises, presentations, intriguing articles and useful tools to make your tasks a little bit easier!

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.

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 syllabus

This Live Virtual Class consists of 13 Modules in terms of Query Performance and Optimization. They include essential theory combined with individual practice during the exercises as well as loads of hands-on tools and real-case scenarios.

  • 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 of query 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
    • 3. Introduction to Query Store
    • 4. How to fix a slow query
  • Module 3: TOP10 development and design mistakes

    • 1. How to design 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 always 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

Who is it for?

Audience

Enterprise administrators, developers, data engineers, IT professionals and other people responsible for implementing and maintaining database solutions.

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.

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.

How to persuade your manager that this course is meaningful?

Investing in knowledge is one of the most worthy investment not only for us, but also for our environment. Learning new skills and insights in terms of cybersecurity may benefit with gaining awareness and as a result, may prevent falling a victim to cyber threats in the future.

Protects the Company

You will be the valuable element in regards to company’s safety – knowing about potential threats and ways of avoiding them may be incredibly useful in a daily company life.

Improves Employees skills

Not only your company will gain a specialist in terms of cybersecurity, but also you will unlock the door for expanding your skills horizon even further.

Boosts customer confidence

Completed course with personal certification may be the perfect advantage when it comes to business.

Helps comply with regulations

Knowledge is power—it helps navigate through complex regulatory landscapes. Keeping up-to-date with the latest cybersecurity regulations and standards ensures your company remains compliant, thus avoiding costly penalties and reputational damage.

Saves money in the long run

Who would have want to pay regularly for help in case of emergency data leakage in a company? It’s much better to educate the employees and prevent any cybersecurity risks.

Prepares for emerging threats

After our course, you will be educated in the possible threats and you will identify any suspicious activity online with ease.

Register now and learn from the best!

During this 3-day course in 21 hours super intensive training you will gain crucial cybersecurity knowledge and skills in terms of SOC analytics. Moreover, you will be able to:

  • get the highest quality and unique learning experience
  • get the opportunity to interact with our world-renowned Experts
  • go through CQURE’s custom lab exercises and practice them after the course

Your Experts

This course is delivered by one of the greatest, world-renowned Cybersecurity Experts with practical knowledge from tons of successful projects, many years of real-world experience, great teaching skills and no mercy for misconfigurations or insecure solutions.

Damian

Widera

Data Platform MVP, MCT, Software Engineer, Cybersecurity Expert

Software engineer with over 20 years of professional experience in all aspects of data platform development. In 2022, for the 14th time, he has been awarded Microsoft’s Data Platform MVP. He holds various Microsoft Certifications since 2004.

How can we help you?

Suggested searches

    Search history

      Popular searches:

      Not sure what course to look for?

      Mobile Newsletter Form