Week 5

PostgreSQL

Relationships and Constraints

Normalization

Joins

JDBC

SQL Injection2

IoC & DI

Practice

Assignment

Back end Track

Under construction

<aside> 🚧

This page is currently under construction. Please check back later.

</aside>

Implementation plan:

  1. Setup
  2. Recap: what trainees already know (tables, rows, columns, primary keys, basic SQL, SQLite)
  3. SQLite vs PostgreSQL — when to use which (embedded vs client-server)
  4. Why PostgreSQL for production: concurrency, data integrity, extensibility
  5. Installing and connecting to PostgreSQL (via a local Docker container)
  6. PostgreSQL-specific data types: VARCHAR vs TEXT, SERIAL, TIMESTAMP, UUID
  7. Using a GUI tool (e.g., pgAdmin, DBeaver) - Prefer the same tool as in the core program.
  8. Running queries from the CLI (psql)

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

CC BY-NC-SA 4.0 Icons

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.