Week 6

Aggregations

Transactions

Indexes

Integrating with Spring Boot

Integrating with APIs

Integration Testing

Practice

Assignment

• Teachers

Back end Track

Week 6 Overview

In this week, we will dive a little deeper into SQL queries and concepts, and see how to use Spring Boot with databases. Finally, we will dive into other integrations: webservers over HTTP.

Across the chapters, we keep using the Postify database. Here are some scripts that allow you to work with the same example data (one for the schema, one for the data).

setup-postify.sql

seed-postify.sql

Note that the data scripts starts with deleting from all known tables before inserting.

Learning goals

• Knowing how to join tables, and query there aggregates
• Understand transactions
• Monitoring and understanding query performance
• Knowing how and when to create indexes to improve query performance
• Working with databases using Spring Boot
• Integrating with external servers via HTTP
• Testing integrations

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.