Backend Master Class [Golang + Postgres + Kubernetes + gRPC]

Course Curriculum

Chapter 1: Working with database [Postgres + SQLC]

Lecture 1: Design DB schema and generate SQL code with dbdiagram.io

Lecture 2: Setup development environment on Windows: WSL2, Go, VSCode, Docker, Make, Sqlc

Lecture 3: Setup development environment on MacOS: Install Go and Visual Studio Code

Lecture 4: Use Docker + Postgres + TablePlus to create DB schema

Lecture 5: How to write & run database migration in Golang

Lecture 6: Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx & sqlc

Lecture 7: Write unit tests for database CRUD with random data in Golang

Lecture 8: A clean way to implement database transaction in Golang

Lecture 9: DB transaction lock & How to handle deadlock in Golang

Lecture 10: How to avoid deadlock in DB transaction? Queries order matters!

Lecture 11: Deeply understand transaction isolation levels & read phenomena

Lecture 12: Setup Github Actions for Golang + Postgres to run automated tests

Chapter 2: Building RESTful HTTP JSON API [Gin + JWT + PASETO]

Lecture 1: Implement RESTful HTTP API in Go using Gin

Lecture 2: Load config from file & environment variables in Go with Viper

Lecture 3: Mock DB for testing HTTP API in Go and achieve 100% coverage

Lecture 4: Implement transfer money API with a custom params validator

Lecture 5: Add users table with unique & foreign key constraints in PostgreSQL

Lecture 6: How to handle DB errors in Golang correctly

Lecture 7: How to securely store passwords? Hash password in Go with Bcrypt!

Lecture 8: How to write stronger unit tests with a custom gomock matcher

Lecture 9: Why PASETO is better than JWT for token-based authentication?

Lecture 10: How to create and verify JWT & PASETO token in Golang

Lecture 11: Implement login user API that returns PASETO or JWT access token in Go

Lecture 12: Implement authentication middleware and authorization rules in Golang using Gin

Chapter 3: Deploying the application to production [Docker + Kubernetes + AWS]

Lecture 1: How to build a small Golang Docker image with a multistage Dockerfile

Lecture 2: How to use docker network to connect 2 stand-alone containers

Lecture 3: How to write docker-compose file and control service start-up orders

Lecture 4: How to create a free-tier AWS account

Lecture 5: Auto build & push docker image to AWS ECR with Github Actions

Lecture 6: How to create a production database on AWS RDS

Lecture 7: Store & retrieve production secrets with AWS secrets manager

Lecture 8: Kubernetes architecture & How to create an EKS cluster on AWS

Lecture 9: How to use kubectl & k9s to connect to a kubernetes cluster on AWS EKS

Lecture 10: How to deploy a web app to Kubernetes cluster on AWS EKS

Lecture 11: Register a domain & set up A-record using Route53

Lecture 12: How to use Ingress to route traffics to different services in Kubernetes

Lecture 13: Auto issue & renew TLS certificates with cert-manager and Let's Encrypt

Lecture 14: Automatic deploy to Kubernetes with Github Action

Chapter 4: Advanced Backend Topics [Sessions + gRPC]

Lecture 1: How to manage user session with refresh token

Lecture 2: Generate DB documentation page and schema SQL dump from DBML

Lecture 3: Introduction to gRPC

Lecture 4: Define gRPC API and generate Go code with protobuf

Lecture 5: How to run a golang gRPC server and call its API

Lecture 6: Implement gRPC API to create and login users in Go

Lecture 7: gRPC Gateway: write code once, serve both gRPC & HTTP requests

Lecture 8: How to extract information from gRPC metadata

Lecture 9: Automatic generate & serve swagger documentation from Go server

Lecture 10: Embed static front-end files inside Golang backend server's binary

Lecture 11: Validate gRPC parameters and send human/machine friendly response

Lecture 12: Run DB migrations directly inside Golang code

Lecture 13: Partial update DB record with SQLC nullable arguments

Lecture 14: Build gRPC update API with optional parameters

Lecture 15: Add authorization to protect gRPC API

Lecture 16: Write structured logs for gRPC APIs

Lecture 17: How to write HTTP logger middleware in Go

Chapter 5: Asynchronous processing with background workers [Asynq + Redis]

Lecture 1: Implement background worker with Redis task queue

Lecture 2: Integrate async worker to Go web server

Lecture 3: Send async tasks to Redis within a DB transaction

Lecture 4: How to handle errors and print logs for Async workers

Lecture 5: Some delay might be good for your async tasks

Lecture 6: How to send email in Go via Gmail

Lecture 7: How to skip test in Go and config test flag in vscode

Lecture 8: Email verification feature: design DB and send email

Lecture 9: Implement email verification API in Go

Lecture 10: Unit test gRPC API with mock DB & Redis

Lecture 11: How to test a gRPC API that requires authentication

Chapter 6: Improve the stability and security of the server

Lecture 1: Upgrade and config sqlc with version 2 syntax

Lecture 2: Switch DB driver from lib/pq to pgx

Lecture 3: How to properly handle DB errors with pgx driver

Lecture 4: Docker compose: port + volume mapping

Lecture 5: How to install & use binary packages in Go

Lecture 6: Implement role-based access control (RBAC) in Go

Lecture 7: Grant AWS EKS cluster access to Postgres and Redis using security group

Lecture 8: Deploy gRPC + HTTP server to AWS EKS cluster

Lecture 9: Don't lose money on AWS

Lecture 10: Graceful shutdown gRPC/HTTP servers and async worker

Lecture 11: Go 1.22 fixed the most common for-loop trap

Lecture 12: Hey, it's not the end yet!

Lecture 13: What's next?