Setup Postgres using Docker¶ In some cases you might want to have postgres setup on your machine. Let us understand how we can setup Postgres using Docker. If you are using our labs, the database will be pre-created by us with all the right permissions. If you are using Windows or Mac, ensure that you …
Using psql¶ Let us understand how to use psql utility to perform database operations. psql is command line utility to connect to the Postgres database server. It is typically used for the following by advanced Database users: Manage Databases Manage Tables Load data into tables for testing purposes We need to have at least Postgres …
Connecting to Database¶ We will be using JupyterHub based environment to master Postgresql. Let us go through the steps involved to get started using JupyterHub environment. We will use Python Kernel with sql magic command and for that we need to first load the sql extension. Create environment variable DATABASE_URL using SQL Alchemy format. Write …
Getting Started¶ As part of this section we will primarily understand different ways to get started with Postgres. Connecting to Database Using psql Setup Postgres using Docker Setup SQL Workbench SQL Workbench and Postgres SQL Workbench Features Data Loading Utilities Loading Data – Docker Exercise – Loading Data Here are the key objectives of this …
