Intermediate PostgreSQL

Michigan builds on introductory database work with techniques for organizing imported data and querying text. Dates, stored procedures and regular expressions extend the range of tasks handled inside PostgreSQL. It suits learners who already understand basic programming and want to examine how data preparation and query design interact.

What you will learn

• Normalize and import tabular data.
• Work with text, dates and stored procedures.
• Use regular expressions to select matching records.

Who this suits

Intermediate learners with basic Python equivalent to the first two Python for Everybody courses.

Before you enroll

Run examples in a disposable local database and keep sample data separate from production. Check PostgreSQL and extension versions before following setup instructions. Queries that work on a small example can behave differently as data grows. Inspect constraints, query plans and transaction behavior before applying an approach to a working application.

Coursera offers paid enrollment or subscription access. Check the enrollment screen for assessment and certificate terms, trials and any financial-aid options. Provider access terms can change; review them before paying.

Put it into practice

Import a small fictional CSV with inconsistent text fields, document the cleaning rules and compare queries before and after normalization.

Source and review

This overview is based on the provider's published information, checked on 12 October 2026. It is an editorial assessment, not a claim that we completed the resource. Time filters are approximate study ranges; projects and exercises can take longer.

View the curriculum and current access options at Coursera.

How YellowCourse describes and checks learning resources.