Week 5

PostgreSQL

Relationships and Constraints

Normalization

Joins

JDBC

SQL Injection2

IoC & DI

Practice

Assignment

• Teachers

Back end Track

Under construction

<aside> 🚧

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

</aside>

Implementation plan:

1. Recap: INNER JOIN from core program
2. LEFT JOIN — all rows from left table, matching from right
3. RIGHT JOIN and FULL OUTER JOIN (awareness)
4. Self-joins — joining a table with itself
5. Joining multiple tables in a single query
6. Table aliases for readability
7. Common mistakes: accidental cartesian products, missing join conditions
8. Exercise: write multi-table join queries on the schema from 5.2

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

Built with ❤️ by the HackYourFuture community · Thank you, contributors

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