SQL for intermediate users

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