Opleiding: PostgreSQL Querying: Advanced Techniques

Breid je SQL-vaardigheden uit met geavanceerde PostgreSQL-technieken voor praktische datavraagstukken.

Verdiep je SQL-kennis en leer complexere querypatronen in PostgreSQL die in de praktijk worden gebruikt. Je vergelijkt meerdere oplossingsstrategieën en kiest per situatie de beste aanpak. Je leert table expressions, set operators, window functions en JSON-querytechnieken toe te passen.
- 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.
-…