SQL – Intermediate Level

Business Benefits:
  • Improved team competencies in writing SQL queries
  • Introduction to best practices and standards in SQL development
  • Ability to build complex SQL query structures and language-based solutions
  • Development of team skills and increased job satisfaction
Participant Benefits:
  • Understanding of how advanced SQL mechanisms work

  • Ability to write diverse queries for data extraction and management

  • Enhanced practical skills and familiarity with SQL best practices

  • Learning how to apply SQL queries in real-world industry projects

Agenda Overview:
  • Database operations: transactions, indexes, variables, and temporary tables

  • Triggers

  • Views and perspectives: creating and modifying views, security aspects

  • Stored procedures: creating, modifying, and testing stored procedures

  • Database security

  • Dynamic SQL: fundamentals of creating dynamic queries, dynamic SQL security

Our Trainers:
  • Grzegorz Kunaszewski – Senior Developer​
  • Krystian Brożek – Backend and Database Developer
  • Grzegorz Małek – Senior Developer​

Additional information

Duration

2 days (14 hours)

Format

Exercises, Lectures, Presentations

Language

English, Polish

Level

Advanced, Beginner, Intermediate

Tell us about your challenge, and we’ll find the right solution.​

Fill out the contact form

Contact details

TestArmy Group S.A. Petuniowa 9/5 53-238 Wrocław Poland

New Field

New Field