Heroku Postgres provides a managed SQL database as a service for storing and retrieving business and application data. This service provides you with the power of a relational database without the management burden of monitoring and maintaining it. The service is based on PostgreSQL ” a powerful, stable, and well-tested open-source database project. This workbook provides an introduction to working with the database service provided by Heroku.
The goal is to get you set up with Heroku Postgres so you can provision, manage, and work with the database service. Upon successful completion of this workbook, you will have provisioned a database and will know how to interact with the data using psql, pgAdmin, a local client application, and Microsoft Excel.