Skip to main content

Google Cloud SQL Deep Dive

Course

Intro Video

Photo of Broadus Palmer

Broadus Palmer

Google Cloud Training Architect

Length

07:15:37

Difficulty

Intermediate

Videos

19

Hands-on Labs

6

Course Details

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

Syllabus

Course Introduction

Getting Started

Course Introduction

00:01:18

Lesson Description:

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

00:00:30

Lesson Description:

Learn more about the Training Architect!

Using the Interactive Diagram

00:01:01

Lesson Description:

In this video lesson, we are going to take a look at the Interactive Diagram.

Introduction to Cloud SQL

What Is Cloud SQL?

00:01:51

Lesson Description:

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

00:05:28

Lesson Description:

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

00:04:31

Lesson Description:

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

00:02:49

Lesson Description:

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

00:07:40

Lesson Description:

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

00:03:40

Lesson Description:

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

00:04:33

Lesson Description:

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.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Creating a Database and Table with Cloud SQL

00:30:00

Connecting to a Cloud SQL Instance

Connecting to Cloud SQL Using the Google Cloud Shell

00:03:09

Lesson Description:

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

00:08:11

Lesson Description:

In this video, we are going to look at connecting to your Cloud SQL Instance from a Compute Engine Instance.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Creating a MySQL Database in Cloud SQL

00:30:00

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Cloning and Connecting to a Cloud SQL Instance

01:15:00

Replication and Data Management

Enabling and Disabling High Availability on a Cloud SQL Instance

00:05:36

Lesson Description:

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

00:04:38

Lesson Description:

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

00:04:53

Lesson Description:

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

00:04:06

Lesson Description:

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

00:06:07

Lesson Description:

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

00:04:15

Lesson Description:

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.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Creating a Cloud SQL Instance and Promoting Read Replica to Primary

01:15:00

Troubleshooting Cloud SQL
Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Troubleshooting a Connection Issue with Cloud SQL

01:00:00

Course Conclusion

Final Steps

What's Next?

00:01:13

Lesson Description:

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