Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Views and the Capstone: PostgreSQL: Uncharted

Courses PostgreSQLViews and the Capstone

Views and the Capstone

Publish reusable query surfaces, read unfamiliar SQL, and deliver a complete month-in-review report.

PostgreSQL
Unit 12 of 12
7 lessons
68 min
200 XP

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

Sign in to start

Lessons

7 total

1Save a Query as a ViewCreate and query a reusable view backed by a SELECT statement.CodeConcept10 min20 XPOpen
2Views on ViewsLayer a summary view over a reusable cleaning view.CodeConcept11 min20 XPOpen
3When Views HelpIdentify the maintainability benefits of a well-designed view.InteractiveConcept7 min20 XPOpen
4Read a Stranger's QueryTrace a nested query from its inner result to its final row.InteractiveConcept8 min20 XPOpen
5Query CraftOrder the moves that reshape a dense report into readable CTE stages.InteractiveConcept8 min20 XPOpen
6Capstone WarmupSolve two report tasks that combine joins, aggregates, and ranking.CodePractice12 min20 XPOpen
7The Cafe: Month in ReviewCreate a reusable monthly report view that stays aligned with the live cafe schema.CodeCapstone12 min80 XPOpen

Window Functions