Course 7 of 19

Databases: PostgreSQL & Supabase

Schema, Queries, Auth, and more.

Yiga AI

Intermediate en

Intermediate · Course · 4 weeks at 5 hrs/week

Duration: 4 weeks
Effort: 5 hrs/week
Lessons: 20
Hands-on exercises: 20
Projects: 1
Language: en

What you’ll learn

Skills you can put to work.

How the Web Works

HTML & CSS

JavaScript Fundamentals

Git & GitHub

Syllabus

Every module, step by step.

4 modules · 25 lessons · 17 hours · 1 graded project

1000 minutes of guided lesson time.

Module 1 · 6 lessons · 3.7 hoursSchemaModule 1 of 4 in Databases: PostgreSQL & Supabase.

Overview and set-up
Overview and set-up — Schema in Databases: PostgreSQL & Supabase.
Lesson
40 min
Core concepts
Core concepts — Schema in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Worked example
Worked example — Schema in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Schema in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Schema in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Module quiz: Schema
Check what you learned in Schema before moving on.
Quiz · Locked
20 min

Module 2 · 6 lessons · 3.7 hours LockedQueriesModule 2 of 4 in Databases: PostgreSQL & Supabase.

Overview and set-up
Overview and set-up — Queries in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Core concepts
Core concepts — Queries in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Worked example
Worked example — Queries in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Queries in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Queries in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Module quiz: Queries
Check what you learned in Queries before moving on.
Quiz · Locked
20 min

Module 3 · 6 lessons · 3.7 hours LockedAuthModule 3 of 4 in Databases: PostgreSQL & Supabase.

Overview and set-up
Overview and set-up — Auth in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Core concepts
Core concepts — Auth in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Worked example
Worked example — Auth in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Auth in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Auth in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Module quiz: Auth
Check what you learned in Auth before moving on.
Quiz · Locked
20 min

Module 4 · 7 lessons · 5.7 hours LockedRow-level securityModule 4 of 4 in Databases: PostgreSQL & Supabase.

Overview and set-up
Overview and set-up — Row-level security in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Core concepts
Core concepts — Row-level security in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Worked example
Worked example — Row-level security in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Row-level security in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Row-level security in Databases: PostgreSQL & Supabase.
Lesson · Locked
40 min
Module quiz: Row-level security
Check what you learned in Row-level security before moving on.
Quiz · Locked
20 min
Graded project: Databases: PostgreSQL & Supabase
Apply everything from Databases: PostgreSQL & Supabase in one graded, portfolio-ready build.
Graded project · Locked
120 min

Applied learning project

Make the learning visible.

Use Graded project: Databases: PostgreSQL & Supabase to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Apply the course’s core skillMake and explain practical decisionsCreate evidence you can share

Your instructor

Grace A.

AI for professions

Shows working professionals how to use AI responsibly inside everyday workflows.

“The examples felt relevant to public service and worked on the connection I actually have.”
Samuel Mwangi
Public service officer, Nairobi

Continue with

Your next best step.

Following the order of Full-Stack Web Developer.

See the full chain

Next lesson

Overview and set-up

Databases: PostgreSQL & Supabase

40 min · Resume

Course 8 in the track

Deployment & DevOps Basics

Vercel, Docker, Environment variables, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 9 in the track

AI-Assisted Coding

Copilot & Cursor, Lovable, Code review with AI, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 10 in the track

Git & GitHub

Commits, Branches, Pull requests, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Loading reviews…

Previous coursePortfolio Project: Marketplace App Next courseDeployment & DevOps Basics

Keep going

Other courses in this track.

View full track

Technical Interview Prep cover illustration

Career

20 lessons · 16.7h · Advanced

Technical Interview Prep

Structured practice for coding interviews, plus mock interviews with feedback.

Modern Web Development cover illustration

Programming

25 lessons · 19.5h · Intermediate

Modern Web Development

Build and ship responsive web apps with HTML, CSS, JavaScript and React.

JavaScript Fundamentals cover illustration

Coding

24 lessons · 19.3h · Beginner

JavaScript Fundamentals

Syntax, DOM, Events, and more.

Payments for African Apps cover illustration

Coding

16 lessons · 14h · Intermediate

Payments for African Apps

Flutterwave, Paystack, MTN MoMo API, and more.