Home Development and training Intermediate T-SQL workshops

Intermediate T-SQL workshops

A complete and elaborate training program – it provides skills to become an SQL developer. Join us today!

I. Goals
This workshop covers the most important aspects of T-SQL syntax and prepares you to independent work with Microsoft SQL Server.

II. Acquired skills

Participants gain theoretical and practical knowledge regarding programming in T-SQL in Microsoft SQL Server including:

szkolenia_zaawansowany_sql
  • Advanced T-SQL queries
  • Function windows in SQL queries
  • Common table expressions
  • Pagination queries, working with cursors and variables
  • Transactions and dealing with bugs
  • Combining queries’ results – UNION, EXCEPT, INTERSECT
  • Creating summaries
  • Query optimization

Participants develop their T-SQL programming skills that may help them in any projects and companies that develop software.

The training ends with a certificate of participation in Intermediate T-SQL workshop.

III. Target group

The training Intermediate T-SQL is great for those that have already programmed in SQL but want to broaden their knowledge e.g.:

  • Junior SQL Developers
  • Developers that work with other programming languages but use SQL queries on every day basis
  • Analysts that use T-SQL to download data

IV. Pros

Why do we recommend this training?

  • Great price to number of training hours ratio in comparison to other trainings offered on the market
  • A complete and elaborate training program – it provides skills to become an SQL developer
  • Practical exercises (case studies) that involve using various programming tools/software
  • A well-qualified teaching stuff that includes people who work as SQL developers and are able to share their practical knowledge and experience
  • Possibility of being employed by Sii after the training
  • Sii is a partner that is trustworthy and widely recognized on the market

V. Schedule

Intermediate SQL-T workshops
Day 1 
Introduction – revising SQL basics
Advanced SQL queries – sub-queries, CROSS APPLY
Working with function windows in queries
Common table expressions – CTE
Pagination queries, working with cursors and variables
Transactions and dealing with bugs
Day 2 
Combining queries’ results – UNION, EXCEPT, INTERSECT
Creating summaries
Triggers
Query optimization
Work with additional tools of MS SQL Server – SQL Server Profiler, Database Engine Tuning Advisor

VI. Organizational issues

  1. Duration: 16h = 2 days
  2. Time:(Saturday – Sunday)
  3. Pricing: 1299 PLN gross (12 people group)
  4. Organizer provides catering during the training
  5. The workshop ends with a certificate of participation
  6. Please, send your application and questions at : szkolenia-lublin@pl.sii.eu

*the organizer restricts the right to change the program and organization

recommend-people

Recommend a friend to Sii

Recommend a friend to work in Sii…

…if we hire him / her…

…You can get up to 4000 PLN!

Our Job Ads

Find out who are we looking for

Contact us

Close
Sorry, Your message has not been sent. Please fill out all required fields correctly and try again. Thank you!

I hereby grant consent for the processing of my personal data contained in this form by Sii sp. z o.o., with its registered office at Al. Niepodległości 69, 02-626 Warsaw (“Sii”), for the following purposes:

At any time, you may withdraw your consent for 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

Apply now

Close
Sorry, Your message has not been sent. Please fill out all required fields correctly and try again. Thank you!

I hereby grant consent for the processing of my personal data contained in this form by Sii sp. z o.o., with its registered office at Al. Niepodległości 69, 02-626 Warsaw (“Sii”), for the following purposes:

At any time, you may withdraw your consent for 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