Send your request
Send your request
Send your request
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.

The number of participants: 8-15 people

Duration: 1 day

Available language: PL / EN

Available course material: PL / EN

Course form
Presentation, lecture, workshop, discussion.

Download materials

Download

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

Uploaded file:

  • danieltroc.pdf

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

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

File upload error

No file was uploaded

Incorrect file size (max 5MB)

Invalid file format

Empty file

Processing...

You might also like

Databases

SQL and PL/SQL optimization

Duration:
2 days
Databases

Oracle and SQL Databases

Duration:
2 days
Databases

MySQL – introduction

Duration:
2 days
Databases

Informatica PowerCenter – Developer basics

Duration:
2 days
Databases

NoSQL – introduction

Duration:
2 days
Databases

Node.js and MongoDB – introduction

Duration:
3 days
DatabasesTesting solutions

SQL for testers

Duration:
3 days
Databases

Oracle SQL - Basics for data analysts

Duration:
2 days
Databases

MS‐SQL – programming

Duration:
2 days
Databases

MS-SQL – queries and indexes plans

Duration:
1 day

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of Agile Business Consortium Limited.
All AgilePM® Courses are offered by Sii, an Affiliate of Quint Wellington Redwood, an Accredited Training Organization of The APM Group Ltd.
Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training OrganizationQuint Wellington Redwood.
SIAM™ is a registered trademark of EXIN Holding B.V.
All prices presented on the website are net prices. 23% VAT should be added.

SUBMIT

Ta treść jest dostępna tylko w jednej wersji językowej.
Nastąpi przekierowanie do strony głównej.

Czy chcesz opuścić tę stronę?

Einige Inhalte sind nicht in deutscher Sprache verfügbar.
Sie werden auf die deutsche Homepage weitergeleitet.

Möchten Sie fortsetzen?