Postgres

A popular relational database

PostgreSQL is one of the most popular relational databases that is currently in use. It is open-source, compatible with most languages and systems, and very reliable. It is an excellent first database for beginners, and it is the database that powers Bento.

Start learning with

Google

Overview

Postgres is a very popular SQL database that is used across the industry. Even if you know SQL already, there are specific features of Postgres that make working with databases easier.

Who curated this track

Jon Chan
  • Founder of Bento
  • Developer at Stack Overflow
  • Self-taught developer
Foundations
Don't know SQL yet?

Hold on! The tutorials in this track assume that you already know the basics of SQL and focus on the parts specific to Postgres. If you haven't learned SQL yet, go to the right track and come back here.

 
Getting Started with PostgreSQL

(www.codementor.io)

This is an excellent introduction on how to get up and running with Postgres. This tutorial covers everything from installation, basic setup, and even common utilities.

1H

 
Postgres Guide

(www.postgresguide.com)

This tutorial gives both beginners and advanced users of Postgres an excellent overview of its main concepts.

4H

Practical Postgres
 
Postico User Guide

(eggerapps.at)

Postico is an application that makes it much easier to interact with your Postgres database than using the command line and psql. Learn how to use it to make working with your Postgres database more manageable.

1H

 
Heroku Postgres

(devcenter.heroku.com)

Postgres is the preferred database solution used with Heroku. This getting started guide walks you through the basics of setting up a database instance with Heroku and how to work with it in multiple languages.

3H

Start this track

What you should learn next

SQLAlchemy

SQLAlchemy is a multipurpose tool to interact with SQL databases using Python. Its most common use is to map data structures in your code with data in your database.