Fundamental 6 Steps 5 hours 26 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.
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.
In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.
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.
Create a Google Cloud SQL PostgreSQL instance. Perform SQL operations using the GCP Console and the psql client.
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.
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.
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.
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.