SQL for intermediate users

Základní info

Popis kurzu

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.


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.

Určeno pro

Data analysts, technical managers, developers.

Obsah kurzu


  • Regular Expressions.

  • Stored Procedures and Triggers.

  • Execution plan analysis.

  • Performance Tuning and Query Optimization.

Předpoklady

Basic familiarity with SQL syntax (ideally PostgreSQL).

Studijní materiály

V angličtině

SQL for intermediate users

Vybraný termín:

13.6.2022  Online

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je sedm a pět ? Součet zapište číslicemi.