Spring Cloud GCP: Setting Up a Cloud SQL Database

Leverage the power of Cloud SQL in your Spring Boot application. Learn how to set up a Cloud SQL database and effectively test your application.

Cloud SQL is one of the most frequently used products on Google Cloud Platform (GCP). This fully managed relational database service for MySQL, PostgreSQL, and SQL Server provides an alternative to configuring and hosting your own database. Plus, it's relatively easy to integrate Cloud SQL with a Spring Boot app, due to the use of Spring Data Cloud SQL and the Spring Data Java Persistence API. In this course, learn how to set up a Cloud SQL database and effectively test your Spring Boot application. Instructor Cecili Reid discusses why and when to leverage a hosted cloud technology. Cecili steps through how to set up your environment and application to use Cloud SQL, as well as how to connect to the database and send requests. To wrap up, she covers how to incorporate unit and integration testing while mitigating costs.

Introduction

• Why GCP for Java Spring?
• What you should know

1. Getting Started with GCP SDK

• What is Spring Data Cloud SQL?
• Setting up your Cloud SQL database

2. GCP Cloud SQL

• Importing the Spring Data Cloud Library
• Configuring your application
• Using the Spring Data Cloud library
• Challenge: Adding a new entity
• Solution: Adding a new entity

3. Validating through Testing

• Unit vs. integration testing
• Unit testing
• Integration testing: In Cloud SQL
• Integration testing: In memory
• Challenge: Add tests for the GET endpoint
• Solution: Add tests for the GET endpoint

Conclusion

• Next steps with Spring Cloud GCP