PostgreSQL Foundations
Install PostgreSQL and learn its tools, types and everyday commands.
What you'll learn
- Install PostgreSQL and use psql
- Create databases, tables and roles
- Choose PostgreSQL data types
About this course
In two weeks you set up PostgreSQL and work in psql. You create databases, tables and users and learn the data types you will use most.
Course curriculum
3 modules and 9 lessons over 2 weeks. Plan for about 6 learning hours.
01SetupWeek 1 · 3 lessons
- Installing
- psql basics
- GUI clients
02ObjectsWeek 1 · 3 lessons
- Databases
- Tables
- Roles
03TypesWeek 2 · 3 lessons
- Text and numbers
- Dates and times
- JSON columns
Project
PostgreSQL workspace. A database with tables, roles and sample data set up from a script.
Who this course is for
Developers starting with PostgreSQL.
Prerequisites
You know basic SQL.
What's included
- 90-day course access
- Guided lessons
- Coding exercises
- Starter files
- Solution examples
- A digital completion certificate
Learning format
Self-paced mini-course, part of our self-paced courses. Guided lessons, exercises and student support.
Access and delivery
- Digital access is activated within 15 minutes after successful payment.
- Student support replies are targeted within 2 business days.
- The completion certificate is issued within 2 business days after the final exercise is submitted.
Certificate
You receive a digital completion certificate. The completion certificate is issued within 2 business days after the final exercise is submitted.
Frequently asked questions
When does access start?
Digital access is activated within 15 minutes after successful 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 self-paced mini-course programs.
