Node + PostgreSQL
Connect Node to PostgreSQL with queries, migrations and a query builder.
What you'll learn
- Connect with node-postgres and pools
- Write parameterized queries
- Run migrations
- Use Knex or Drizzle for queries
About this course
You build a library API backed by PostgreSQL. You write SQL with node-postgres, add migrations and move to a query builder, and a project checkpoint reviews your schema.
Course curriculum
4 modules and 12 lessons over 4 weeks. Plan for about 12 learning hours.
01ConnectingWeek 1 · 3 lessons
- Installing PostgreSQL
- node-postgres
- Connection pools
02QueriesWeek 2 · 3 lessons
- CRUD queries
- Parameters
- Transactions
03MigrationsWeek 3 · 3 lessons
- Migration files
- Seeding
- Rollbacks
04Library APIWeek 4 · 3 lessons
- Schema
- Endpoints
- Checkpoint
Project
Library API. A PostgreSQL-backed API for books, members and loans.
Who this course is for
Node developers adding a relational database.
Prerequisites
You build Express APIs and know basic SQL.
What's included
- 180-day course access
- Project brief
- Starter repository
- Coding labs
- Reference solutions
- One written project review
- A digital completion certificate
Learning format
Project-based online course, part of our guided project courses. One written project review.
Access and delivery
- Course access is delivered within 15 minutes after payment.
- Written project review is returned within 2 business days of submission.
- Completion materials are issued within 2 business days after the project is approved.
Certificate
You receive a digital completion certificate. Completion materials are issued within 2 business days after the project is approved.
Frequently asked questions
When does access start?
Course access is delivered within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for project-based programs.
