Git, Docker and Postgres Workshop

A hands-on workshop to explain the basics of Git, Docker, and Postgres. In this, you will learn the foundations of using git for project collaboration, docker for app containerization, and postgres for storing and retrieving application data.

Prerequisites

Any Linux machine (ubuntu is preferred) with following packages installed
  • git
  • python3.10
  • Docker
  • Docker Compose
GitHub account
  • Create an account on GitHub (if you don't already have one)
  • Fork this repository and then clone it to your machine
  • You can refer this guide to understand how to fork and clone
Docker
  • To install docker go to your cloned repository and run the following command
  • sudo sh install_docker.sh

What will you learn by the end of this workshop?

  • Introduction to git
  • Git commands (push, pull make Pull request etc)
  • Concepts of containerisation and why its required.
  • Building and running your own Containers.
  • Running Multiple Services with Docker Compose
  • Other docker concepts like exposing Ports, Volume Mounts, Utilizing Networks, Limiting Resources (the 4 features we use regularly.)
  • Basics of postgres.
  • Connecting and querying to postgres database.
  • Integration of scripts and postgres as multiple services as containers.
  • Reading data from files and populating to database.

Schedule

Time Topics
09:00 - 9:15 Introduction
09:15 - 10:00 Introduction to git
9:45 - 10:15 Git Commands (push, pull, make Pull request etc)
10:15 - 10:30 What is docker
10:30 - 11:30 Docker Commands
11:45 - 12:00 Run Multiple Services with Docker Compose
12:00 - 12:30 Expose Ports, Volume Mounts, Utilizing Networks, Limiting Resources
12:30 - 1:00 Introduction to Postgres
01:00 - 02:00 Break
2:00 - 2:30 Docker compose with Postgres
2:00 - 2:30 Postgres Continuation
2:30 - 4:00 Running scripts
4:00 - 4:30 Q & A and Wrapping Up