Cloud SQL is a fully managed database service that stands out from its peers due to high performance, seamless integration, and impressive scalability. In this fundamental-level quest, you will receive hands-on practice with the basics of Cloud SQL and quickly progress to advanced features, which you will apply to production frameworks and application environments. From creating instances and querying data with SQL, to building Deployment Manager scripts and highly available databases that run on GKE containers, Cloud SQL will give you the knowledge and experience needed so you can start integrating this service right away.
Overview
Syllabus
- Introduction to SQL for BigQuery and Cloud SQL
- In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.
- Cloud SQL for MySQL: Qwik Start
- Create a Google Cloud SQL MySQL instance and perform SQL operations using Google Cloud Platform Console and mysql client. Watch this short video, Manage PostgreSQL and MySQL Databases Easily with Cloud SQL.
- Cloud SQL for PostgreSQL: Qwik Start
- Create a Google Cloud SQL PostgreSQL instance. Perform SQL operations using the GCP Console and the psql client.
- Loading Data into Google Cloud SQL
- In this lab you will import data from CSV text files into Cloud SQL and then carry out some basic data analysis using simple queries.
- Cloud SQL with Terraform
- In this hands-on lab you will learn to create Cloud SQL instances with Terraform, then set up the Cloud SQL Proxy, testing the connection with both MySQL and PostgreSQL clients.
- warning Using Ruby on Rails with Cloud SQL for PostgreSQL on Cloud Run
- In this lab, you'll learn how to deploy a new Ruby on Rails application using Google Cloud SQL for PostgreSQL on Cloud Run.
- APIs Explorer: Cloud SQL
- In this lab, you will get hands-on practice with the Cloud SQL API and its associated methods by making calls through the APIs Explorer tool.
- Connect to Cloud SQL from an Application in Kubernetes Engine
- This lab shows how easy it is to connect an application in Kubernetes Engine to a Cloud SQL instance using the Cloud SQL Proxy container as a sidecar container. You will deploy a Kubernetes Engine cluster and a Cloud SQL Postgres instance and use the Cloud SQL Proxy container to allow communication between them.
