What is a Local PostgreSQL Database, and How to Get Setup?

This is our first attempt at creating an introduction to setting up a local database. In this tutorial we use DBngin and TablePlus to get setup on a PostgreSQL database.