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 section

  • Connecting to Database using Jupyter based environment in our labs. This is relevant to only those who got our lab access.

  • Ability to setup Postgres Database using Docker for those who does not have access to our labs.

  • Relevance of IDEs such as SQL Workbench

  • Understand the key features for IDEs such as SQL Workbench including connecting SQL Workbench to Postgres Database.

  • How to load data into tables using Database native utilities?

  • Exercise to ensure our understanding related to loading data into the tables using database native utilities.