Cloud SQL

7 hours Introductory universal_currency_alt 24 Credits

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 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 connecting Cloud SQL instances with applications run on GKE containers, this quest will give you the knowledge and experience needed so you can start integrating this service right away.

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

Lab

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.

Lab

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.

Lab

Cloud SQL for PostgreSQL: Qwik Start

Create a Google Cloud SQL PostgreSQL instance. Perform SQL operations using the GCP Console and the psql client.

Lab

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.

Lab

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.

Lab

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.

Lab

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.

Lab

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.

info

Quest Info

Prerequisites

Although this quest will teach you the fundamentals of Cloud SQL, you will still need prior hands-on experience with the platform's core tools and services. It is recommended that you have earned at least the Badge for completing the GCP Essentials and/or the Baseline: Infrastructure Quest before beginning.

Available languages

English

What do I do when I finish this quest?

After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.

What badges can I earn?

Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.

Google Cloud Skills Boost

Cloud SQL

Quest Info