PostgreSQL Querying: Advanced Techniques

Info Support B.V.

Extend your SQL skills with advanced PostgreSQL techniques for real-world data problems.

Price

from €1,450

Level

Bachelor

Kind

Training

Subject

Automation and IT, Internet and media

More information and registration at Info Support B.V.

Description

Go beyond SQL basics and learn advanced PostgreSQL querying patterns. You will compare multiple solution strategies and pick the best approach for each situation, applying table expressions, set operators, window functions, and JSON querying techniques along the way. - Construct views, derived tables, common table expressions, and set-returning functions to structure complex queries. [Apply] - Use UNION, EXCEPT, and INTERSECT to combine and compare result sets. [Apply] - Implement window functions with OVER, PARTITION BY, and frame clauses for ranking, offset, and aggregate calculations. [Apply] - Manipulate JSON, JSONB, and array data using PostgreSQL's native operators and functions. [Apply] - Interpret PL/pgSQL blocks, variables, control flow, and function or procedure calls. [Understand] - Refresher - Table Expressions - Set Operators - Window Ranking, Offset and Aggregate Functions - JSON and Arrays - Reading PL/pgSQL Refresher of the common pitfalls of basic SQL querying, ensuring everyone is on the same page before diving into advanced topics. Next to this, the module serves as an introduction to the database used in class. - Standard elements of…