MS-SQL – queries and indexes plans

Course objectives

The workshops aim to provide knowledge on how to use performance capacity offered by SQL Server.

Benefits

Understanding how to improve query performance in SQL Server,
Getting to know good practices of writing SQL code,
Finding out about plans for executing the instructions
Understanding the basics of indexes and statistics in MS SQL,
Improving application performance by using appropriate T-SQL constructs

Training scope

Introduction to improving performance and processing queries
Good practices for writing queries
Plan for the implementation of instructions
Basics of indexes in MS SQL
Basics of statistics
Solving common performance problems

Audience

All individuals involved in the development, administration and maintenance of databases using MS-SQL query language in their work.

Course objectives

The workshops aim to provide knowledge on how to use performance capacity offered by SQL Server.

Benefits

Understanding how to improve query performance in SQL Server,
Getting to know good practices of writing SQL code,
Finding out about plans for executing the instructions
Understanding the basics of indexes and statistics in MS SQL,
Improving application performance by using appropriate T-SQL constructs

Training scope

Introduction to improving performance and processing queries
Good practices for writing queries
Plan for the implementation of instructions
Basics of indexes in MS SQL
Basics of statistics
Solving common performance problems

Audience

All individuals involved in the development, administration and maintenance of databases using MS-SQL query language in their work.

Course form

Presentation, lecture, workshop, discussion.

Download materials

Download

First name*

Surname*

E-mail*

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address.

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

File upload error

No file was uploaded

Incorrect file size (max 5MB)

Invalid file format

Empty file

Processing...

Download materials

Download

Contact our experts with questions about any of our trainings

Natalia & Agata

Training Practice Team

Contact our experts

Natalia & Agata

First name*

Surname*

E-mail*

Phone number

Company name

Job position

Your message*

Your file

Uploaded file:

danieltroc.pdf

Allowed extensions: DOC, DOCX, PDF (max 5MB)

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address. I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for recruitment purposes.

Thank you for filling out the form

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message couldn’t be delivered

Please refresh the page and try again