Module Overview

What You’ll Learn

• Use PostgreSQL functions
• Perform calculations
• Manipulate strings
• Work with dates

💡 Why this module matters: Not every answer lives in a column as-is, sometimes it needs calculating, formatting, or extracting first. PostgreSQL’s built-in functions do this directly inside a query, no need to pull raw data out and process it somewhere else.

What’s Covered

• Arithmetic expressions, calculations built from column values.
• String functions, manipulating and formatting text.
• Numeric functions, rounding, absolute value, and other numeric operations.
• Date and time functions, extracting and calculating with dates.
• COUNT, SUM, AVG, MIN, MAX, the core aggregate functions, a first look before Module 8 puts them to work with GROUP BY.
• Type casting, converting a value from one data type to another.

Hands-On

By the end of this module, you’ll calculate totals, format names, extract date values, and compute averages, all directly inside a query.

Next module puts the aggregate functions from here to real use, grouping rows together with GROUP BY to build genuine summary reports.