Google Cloud SQL for Developers Course E-Learning

In this online E-Learning Google Cloud SQL course you will learn what Cloud SQL has to offer and how to use the Google Developers Console when developing and managing Cloud SQL applications. In the second part of this course you will learn to connect Cloud SQL applications by using the MySQL client via Google Cloud Compute and Google App Engine.Topics covered include SSL certification, Secure Socket Layer, MySQL, Google Cloud Compute Engine, REST API, O Auth 2.0 and much more.

Your result

Google Cloud SQL, part of the Google Cloud Platform, is a fully managed relational MySQL database service. It is easy to use and manage from anywhere by providing storage in the cloud. Being in the cloud does not require any additional software and it's ideal for small to medium-sized businesses. Google manages the automation of backups and replication, which provides security and reliability for the databases. Cloud SQL can be used for Google App Engine applications using the MySQL protocol, and it can be managed using the administration and reporting tools provided by Google. This path of courses covers how to administer, interact with, and access a Google Cloud SQL instance and covers the objectives for the CPE303 Google Cloud SQL Qualification exam. This exam is part of the Google Cloud Platform Qualified Developer designation.

Course content

Cloud SQL Fundamentals

Course: 20 Minutes

• Course Introduction
• Overview of Cloud SQL
• Benefits and Features of Cloud SQL
• Cloud SQL Pricing
• Regions and Zones

Instance Creation

Course: 37 Minutes

• Creating a Cloud SQL Instance
• Defining a Network
• Configuring Access Control for IP Connections
• Configuring SSL for Instances
• Configuring MySQL Flags
• Creating a Database
• Configuring MySQL Access Control
• Editing a Cloud SQL Instance

Managing Instances

Course: 57 Minutes

• Scheduling Backups
• Restoring from a Backup
• Overview of SQL Cloud Replication
• Enabling Cloud SQL Read Replicas
• Managing Cloud SQL Read Replicas
• Enabling External Read Replicas in Cloud SQL
• Viewing Instance Information
• Viewing Instance Operations Logs
• Adding a Project Member
• Importing Data to Cloud SQL
• Exporting Data from Cloud SQL
• Migrating MySQL 5.5 to MySQL 5.6

Practice: Create and Manage an Instance

Course: 5 Minutes

• Exercise: Creating and Managing a Cloud SQL Instance

Connecting Using MySQL Client

Course: 27 Minutes

• Course Introduction
• Installing the MySQL Client
• Connecting to a Cloud SQL Instance
• Connecting to a Cloud SQL Instance Using SSL
• Using the MySQL Client
• Connecting Through Google Cloud Compute

Connecting with Admin & Reporting Tools

Course: 20 Minutes

• Connecting with MySQL Workbench
• Connecting with Toad for MySQL
• Connecting with SQuirrel SQL
• Google Cloud SQL for Developers: SSL with SQuirrel

Connecting with App Engine

Course: 13 Minutes

• Authorizing a Java Application
• Connecting to Cloud SQL with a Python App
• Size and Access Limits to Cloud SQL with App Engine

Using the Cloud SDK

Course: 57 Minutes

• Overview of the REST API and OAuth 2.0
• Installing the Google Cloud SDK
• Using the Cloud SQL API to do Basic Tasks
• Performing Advanced Tasks with the Cloud SQL API
• Importing and Exporting with the Cloud SQL API
• Performing Backups Using the API
• Performing Point-in-time Recovery Using the API
• Using the Client Libraries
• Identifying Connection Issues
• Identifying Performance Issues

Practice: Connecting and Using Cloud SQL

Course: 3 Minutes

• Exercise: Accessing a Cloud SQL Instance