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 form

Presentation, lecture, workshop, discussion.

Contact our expert with questions

about any of our trainings

Agnieszka Rzeczkowska

Training Practice Manager

CONTACT OUR EXPERT

Agnieszka Rzeczkowska

First name *

Surname *

Company name

E-mail *

Your Message

Phone number

or drag and drop your file here

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

I hereby consent to the processing of my personal data by Sii sp. z o.o. for sending marketing information to the indicated 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 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

Processing...

Databases

SQL and PL/SQL optimization

Duration:: 2 days

Learn more

Databases

Oracle and SQL Databases

Duration:: 2 days

Learn more

Databases

MySQL – introduction

Duration:: 2 days

Learn more

Databases

Informatica PowerCenter – Developer basics

Duration:: 2 days

Learn more

Databases

NoSQL – introduction

Duration:: 2 days

Learn more

Databases

Node.js and MongoDB – introduction

Duration:: 3 days

Learn more

DatabasesTesting solutions

SQL for testers

Duration:: 3 days

Learn more

Databases

Oracle SQL - Basics for data analysts

Duration:: 2 days

Learn more

Databases

MS‐SQL – programming

Duration:: 2 days

Learn more

Databases

MS-SQL – queries and indexes plans

Duration:: 1 day

Learn more

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.
All prices presented on the website are net prices. 23% VAT should be added.

Years