menu

Cloud SQL

Fundamental 8 Steps 7h 6m 33 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 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.

Infrastructure Application Development Data

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 Quests before beginning.

Quest Outline

Hands-On 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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
Hands-On 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.

Hands-On 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.

Hands-On 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.

Hands-On Lab

Running WordPress on App Engine Flexible Environment

In this lab, you will learn how to run your WordPress blog on App Engine Flexible Environment for PHP.

Hands-On Lab

Create a Cloud SQL Instance Using Deployment Manager

In this hands-on lab you’ll access a repository which contains sample deployment manager templates, and practice launching a CloudSQL instance with an example template. The template you’ll practice with launches one master database instance along with a read replica.

Hands-On 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.

Hands-On Lab

Using Ruby on Rails with Cloud SQL for PostgreSQL

In this lab, you'll learn how to deploy a new Ruby on Rails application using Google Cloud SQL for PostgreSQL to Google App Engine Flexible environment.

Hands-On Lab

Getting Started - App Maker

Create you own App Maker app that has a Google Cloud SQL Database, Google Maps integration, and a Mobile Responsive Design. And of course, fully published and ready to use.

Hands-On Lab

High Availability PostgreSQL and Kubernetes with Google Cloud

In this lab, you will deploy a highly available and quickly scalable "meme generator" application. You will accomplish this by configuring a Postgres Cloud SQL database and connecting it to a Kubernetes cluster.

Enroll Now

Enroll in this quest to track your progress toward earning a badge.

home
Home
school
Catalog
menu
More
More