Week 6

Aggregations

Transactions

Indexes

Integrating with Spring Boot

Integrating with APIs

Integration Testing

Practice

Assignment

• Teachers

Back end Track

Content

Let’s get practical

🫂 Joins and aggregations

Exercise: Artist stream counts

Exercise: Album track durations

Exercise: Most active users per country

⚛️ Transactions

Exercise: Safe deletion

Exercise: Subscription upgrade

🗂️ Indexes

Exercise: indexing the Postify backend

Exercise: Query plan analyses

📡 Integrating with APIs

Exercise: Public Holiday API

🧑‍🏫 Integration testing

Exercise: which test database?

Exercise: mocking HTTP

Exercise: testing postgreSQL

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.