T-SQL – advanced programming

Course objectives

The workshop aims to provide knowledge about the principles of proper implementation and use of T-SQL code.

Benefits

Workshop participants will learn the principles of efficient use of the following T-SQL constructs:
- Temporary tables
- Scalar functions
- Views
- Tabular functions
- Triggers
- Window functions

Training scope

Tabular expressions and views
Tabular variables and temporary tables
Window functions
Scalar and tabular functions
Stored procedures
Case study part 1 – In how many ways can you write the selected functionality?
Case study part 2 – Which T-SQL construct should be chosen?

Audience

Database developers with a minimum of 2 years of experience.

Course objectives

The workshop aims to provide knowledge about the principles of proper implementation and use of T-SQL code.

Benefits

Workshop participants will learn the principles of efficient use of the following T-SQL constructs:
- Temporary tables
- Scalar functions
- Views
- Tabular functions
- Triggers
- Window functions

Training scope

Tabular expressions and views
Tabular variables and temporary tables
Window functions
Scalar and tabular functions
Stored procedures
Case study part 1 – In how many ways can you write the selected functionality?
Case study part 2 – Which T-SQL construct should be chosen?

Audience

Database developers with a minimum of 2 years of experience.

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

Agata Czerniszewska
Natalia Ozimkowska

Training Practice Team

Contact our experts

Agata Czerniszewska
Natalia Ozimkowska

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