PostgreSQL Querying: Advanced Techniques

Info Support B.V.

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

Prijs

vanaf € 1.450

Niveau

Bachelor

Soort

Training

Thema

Automatisering en ICT, Internet en media

Meer informatie en aanmelden bij Info Support B.V.

Beschrijving

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. -…