Database Design and Basic SQL in PostgreSQL

Michigan introduces database design alongside SQL commands in PostgreSQL. Single-table work develops into relationships and the roles of different keys. It suits learners who want to understand why a schema has its structure before concentrating on more advanced queries, particularly those with the basic Python background expected by the course.

What you will learn

• Use psql for basic table and data operations.
• Distinguish primary, logical and foreign keys.
• Model one-to-many and many-to-many relationships.

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

Design a small library schema with books, members and loans, then show how a foreign key prevents an inconsistent relationship.

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.