Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...
InstructorAdnan Waheed
Free
The curriculum provides a broad technical scope, including advanced querying with CTEs and Window Functions, as well as server-side programming using PL/pgSQL and triggers.
Instruction includes specific coverage of JSONB objects, array functions, and user-defined data types.
Editorial course preview
This view highlights a concrete, legible example from the course presentation.
This curriculum overview details advanced database concepts including recursive common table expressions, server programming, and performance optimizations.
Some learners report that complex parts are explained briefly and that essential administration tasks, such as database restoration or Python integration, are missing.
The learning path includes highly repetitive tasks for basic operations like creating databases and tables, which may slow progress.
One signal suggests technical terms like 'schema' are introduced without sufficient conceptual analogies, and one report notes a syntax error in CONCAT_WS usage.
The curriculum aligns well with the stated goal of teaching beginners through to advanced functionality.