Webové stránky používají k poskytování služeb, personalizaci reklam a analýze návštěvnosti soubory cookie. Informace, jak tyto stránky používáte, jsou sdíleny se společností Google. Používáním souhlasíte s použitím souborů cookie. Více informací.

Rozumím

Course code: SQLIU

SQL for intermediate users

SQL is an essential language for everyone working with data. In this course we go beyond the basics and provide an overview of some advanced functionality, like using regular expressions for analyzing text data (pattern matching, log analysis) and optimizing queries. We will use the popular PostgreSQL database.

Course overview

  • Regular Expressions.
  • Stored Procedures and Triggers.
  • Execution plan analysis.
  • Performance Tuning and Query Optimization.

Prerequisites

Basic familiarity with SQL syntax (ideally PostgreSQL).

Course price

€300 (excl. VAT)
€363 (incl. VAT)

Available terms

Date Guaranteed Location Language Duration
17. October 2022 - Prague Czech 2 days Register

Virtual Course

Date Language Duration
14. February 2022 Czech 2 days Register
21. February 2022 English 2 days Register
13. June 2022 Czech 2 days Register
20. June 2022 English 2 days Register
15. August 2022 English 2 days Register
22. August 2022 Czech 2 days Register
17. October 2022 Czech 2 days Register
31. October 2022 English 2 days Register
12. December 2022 Czech 2 days Register
19. December 2022 English 2 days Register

Alternative terms

Suggested dates do not suit you? Contact us for an alternative date.

Contact us