Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Readable Queries with CTEs: PostgreSQL: Uncharted

Courses PostgreSQLReadable Queries with CTEs

Readable Queries with CTEs

Name intermediate results, chain report stages, generate series, and traverse hierarchies.

PostgreSQL
Unit 10 of 12
9 lessons
88 min
200 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

9 total

1WITH a NameReplace a derived table with a named common table expression.CodeConcept8 min20 XPOpen
2Chaining CTEsBuild a report with one CTE feeding a second CTE.CodeConcept9 min20 XPOpen
3CTE or Subquery?Recognize when a named query stage improves readability.InteractiveConcept7 min20 XPOpen
4A Report in StepsBuild a readable daily report as three focused CTE stages.CodeProject12 min20 XPOpen
5Recursion: the IdeaTrace how an anchor row and recursive rule build a finite result.InteractiveConcept8 min20 XPOpen
6Recursive CountingGenerate bounded number and date series with recursive CTEs.CodeConcept10 min20 XPOpen
7Walking the Org ChartTraverse a manager hierarchy and track each staff member's depth.CodeConcept11 min20 XPOpen
8CTE WorkoutGenerate a calendar and find dates with no related match rows.CodePractice11 min20 XPOpen
9CTEs Mastery CheckCombine recursive generation and chained named stages in a gap-free daily report.CodeMastery check12 min40 XPOpen

Queries Inside Queries Window Functions