Course Description
This course prepares you for the Google Cloud SQL Qualification Exam and is meant for solution developers, solutions architects, and systems operations professionals who: 1) create and deploy applications that store data in Cloud SQL; and 2) create and maintain Cloud SQL environments. The training will cover: Google Cloud SQL Fundamentals; Cloud SQL Database Administration; Interacting with Cloud SQL; Accessing Cloud SQL from Google App Engine; and Accessing Cloud SQL from Google Compute Engine.
What am I going to get from this course?
- Create and deploy applications that store data in Cloud SQL
- Create and maintain Cloud SQL environments
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Understanding of the fundamentals of Google App Engine is necessary to take this course. You can take the Experfy course "Google App Engine Qualification Exam Training" as a refresher. You must also know the fundamentals of MySQL.
Who should take this course? Who should not?
This course is meant for solution developers, solutions architects, and systems operations professionals
Curriculum
Module 1: Google Cloud SQL Fundamentals
Lecture 1
Cloud SQL versus MySQL
Lecture 2
The benefits of Cloud SQL
Lecture 3
Pay-per-use versus packaged billing
Lecture 4
Storage engine and storage usage
Quiz 1
Google Cloud SQL Fundamentals
Module 2: Cloud SQL Database Administration
Lecture 7
Read and write operations
Lecture 8
Access controls: App Engine application ID or IP address
Lecture 9
Authorizing applications with dynamic and static IP addresses
Lecture 10
Scheduling backups for an instance and viewing backup history
Lecture 11
Viewing instance usage data and instance operations logs
Lecture 12
Granting access to applications
Lecture 13
Configuring MySQL access control: user accounts
Lecture 14
Configuring SSL for a MySQL instance
Lecture 15
Changing the billing model for an instance
Quiz 2
Cloud SQL Database Administration
Module 3: Interacting with Cloud SQL
Lecture 16
Connection string formats
Lecture 17
Creating a Cloud SQL instance
Lecture 18
Defining a network
Lecture 19
Connecting to a Cloud SQL instance from the command line or from third-party tools
Quiz 3
Interacting with Cloud SQL
Module 4: Accessing Cloud SQL from Google App Engine
Lecture 20
Authorizing App Engine applications
Lecture 21
Authorized networks
Lecture 22
Preferred locations and following App Engine applications
Lecture 23
Connecting to Cloud SQL from App Engine and from the App Engine development server
Lecture 24
Enabling the MySQL driver for App Engine in an application
Lecture 25
Writing code to detect if an application is running locally or remotely
Lecture 26
Installing a MySQL driver for use with the App Engine development server
Quiz 4
Accessing Cloud SQL from Google App Engine
Module 5: Accessing Cloud SQL from Google Compute Engine
Lecture 27
Authorized networks
Lecture 28
Preferred locations
Lecture 29
Compute Engine zones
Lecture 30
Connecting to Cloud SQL from Compute Engine
Lecture 31
Connecting to Cloud SQL using a client over the public internet
Quiz 5
Accessing Cloud SQL from Google Compute Engine
Email
Share
