Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Your First Queries: PostgreSQL: Uncharted

Courses PostgreSQLYour First Queries

Your First Queries

Filter cafe and library rows, combine conditions, sort results, and shape exactly what a report needs.

PostgreSQL
Unit 2 of 12
11 lessons
94 min
240 XP

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

Sign in to start

Lessons

11 total

1Filtering with WHEREFilter the cafe menu to rows whose availability condition is true.CodeConcept7 min20 XPOpen
2Comparing ValuesCombine numeric and text comparisons in a precise row filter.CodeConcept8 min20 XPOpen
3Combining ConditionsControl AND, OR, and NOT precedence with explicit parentheses.CodeConcept9 min20 XPOpen
4Shortcuts: BETWEEN, IN, LIKEFilter ranges, sets, and case-insensitive text patterns with SQL shortcuts.CodeConcept9 min20 XPOpen
5Sorting ResultsSort query results by one key and then by two keys.CodeConcept10 min20 XPOpen
6Just the TopTrim an ordered result with LIMIT and move through it with OFFSET.CodeConcept9 min20 XPOpen
7No DuplicatesCollapse repeated projected values with SELECT DISTINCT.CodeConcept6 min20 XPOpen
8Naming with AliasesGive projected columns and calculated expressions clear result names.CodeConcept8 min20 XPOpen
9How a Query RunsArrange the logical stages that produce a filtered and ordered result.InteractiveConcept7 min20 XPOpen
10Filter WorkoutCombine null, date, sorting, and limiting clauses in a library query.CodePractice11 min20 XPOpen
11Queries Mastery CheckShape a short priority list with filtering, sorting, and limiting.CodeMastery check10 min40 XPOpen

Databases All Around You Shaping Values