Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Shaping Values: PostgreSQL: Uncharted

Courses PostgreSQLShaping Values

Shaping Values

Calculate new values, clean text, work with dates, and turn missing or conditional data into useful reports.

PostgreSQL
Unit 3 of 12
11 lessons
97 min
240 XP

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

Sign in to start

Lessons

11 total

1Calculated ColumnsCalculate a line total from price and quantity and label the expression.CodeConcept7 min20 XPOpen
2Working with TextCombine, change case, and measure text values in one result.CodeConcept9 min20 XPOpen
3Cleaning TextNormalize surrounding spaces, replace separators, and extract a text fragment.CodeConcept9 min20 XPOpen
4Rounding and MathRound a calculated share in several ways and calculate an integer remainder.CodeConcept9 min20 XPOpen
5Dates and TimesConstruct a report date, extract a timestamp part, and truncate a timestamp.CodeConcept9 min20 XPOpen
6Date MathAdd an interval and measure elapsed calendar time from an order timestamp.CodeConcept9 min20 XPOpen
7The Trouble with NULLDistinguish missing data from zero and empty text and predict a NULL comparison.InteractiveConcept7 min20 XPOpen
8NULL in PracticeFind missing and present values and replace missing output with a fallback label.CodeConcept10 min20 XPOpen
9Choosing with CASELabel prices by evaluating ordered CASE conditions.CodeConcept9 min20 XPOpen
10Changing TypesConvert between text and numeric values with CAST and PostgreSQL shorthand.CodeConcept8 min20 XPOpen
11Values Mastery CheckBuild one report with arithmetic, a date part, a NULL fallback, and conditional labels.CodeMastery check11 min40 XPOpen

Your First Queries Counting and Summarizing