Google Cloud SQL Deep Dive
Google Cloud Training Architect
Welcome to the Linux Academy's Google Cloud SQL Deep Dive Course.
This course is designed for students who have a good understanding of the Google Cloud Platform. You should be familiar with services such as Compute Engine Instance, Cloud Storage, and Google Cloud Shell. This course will give you experience in creating and managing Cloud SQL instances.
In this course, we will spend a lot of time learning the following:What is Cloud SQL? Creating and Managing Instances Connecting to a Cloud SQL Instance Replication and Data Management Troubleshooting
Broadus Palmer, Google Cloud Training Architect
In this video lesson, we are going to talk about what you can expect in the Google Cloud Cloud SQL Deep Dive course!
About the Training Architect
Learn more about the Training Architect!
Using the Interactive Diagram
In this video lesson, we are going to take a look at the Interactive Diagram. https://interactive.linuxacademy.com/diagrams/426_Google+Cloud+Cloud+SQL+Deep+Dive.html
Introduction to Cloud SQL
What Is Cloud SQL?
In this video lesson, we are going to learn about Cloud SQL. We will cover Cloud SQL features and benefits as well as database services that Cloud SQL has.
Creating and Managing Instances
Creating a MySQL Instance in Cloud SQL
Choosing and configuring your database instance is an important task as an admin. In this video lesson, we will learn how to create and manage your Cloud SQL Instance.
Viewing and Editing Instance Information in Cloud SQL
After the launch and configuration of your instance, you will need to learn how to view and edit your instance info. In this video lesson, we will do just that.
Cloning a Cloud SQL Instance
In this video lesson, we will learn how to clone your Cloud SQL instance. We will dive into the Google Cloud console and clone our current instance to provide failover for disaster recovery.
Starting, Stopping, Restarting, and Deleting a Cloud SQL Instance
In this video lesson, we learn how to start the instance, why you should stop and restart, and how to preserve data when deleting.
Configuring Private and Public IP Connectivity in Cloud SQL
In this video lesson, we will learn how to configure Private and Public IP connectivity on our Cloud SQL instance.
Configuring SSL and Database Flags in Cloud SQL
In this video, we are going to talk about configuring SSL and Database Flags in Cloud SQL. We will go over downloading certificates from the Google Cloud Console as well as setting up a flag.
Connecting to a Cloud SQL Instance
Connecting to Cloud SQL Using the Google Cloud Shell
In this video, we will learn how to connect to your Cloud SQL instance from the Cloud Shell.
Connecting to Cloud SQL from a Compute Engine Instance
In this video, we are going to look at connecting to your Cloud SQL Instance from a Compute Engine Instance. Here is the API you need to enabled for Private Connectivity: **Service Networking API ** Documentation: https://cloud.google.com/sql/docs/mysql/private-ip
Replication and Data Management
Enabling and Disabling High Availability on a Cloud SQL Instance
Having a highly available instance is essential to disaster recovery. In this video lesson, we will learn how to enable, manage, and disable High Availability within your Cloud SQL instance.
Creating and Managing Read Replicas on Cloud SQL
Creating Read Replicas is another way to keep your instance highly available. In the video lesson, we are going to learn how to create and manage read replicas through the Google Cloud console.
Creating and Managing Automated Backups on Cloud SQL
Backups are an important asset to Cloud SQL's data and recovery. In this video lesson, we talk about automated backups as well as create and delete backups within the Google Cloud Console.
Importing Data into Cloud SQL
Importing Data files from Cloud Storage is an easy way to load data into your Cloud SQL instance. In this video lesson, we will go through how to import a CSV file into our Cloud SQL instance. Here is a csv file you can use to follow along! https://github.com/BPalmerLA/googlecloud/blob/master/SneakersandDates
Exporting Data from Cloud SQL
Exporting Data is an important way to save and retrieve data from your Database Instance. In this video lesson, we will learn how to export data from your Cloud SQL instance to Cloud Storage.
Creating and Managing Users
Knowing how to create and manage users to maintain and access your Database Instance is essential. In this video lesson, we will take a look at creating users in Cloud SQL from the Google Cloud console.
Troubleshooting Cloud SQL
In this video, we will discover what is next for you if you wish to continue learning with Linux Acacdemy.
Take this course and learn a new skill today.
Transform your learning with our all access plan.Start 7-Day Free Trial