5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

IT Professional Curricula     Internet and Network Technologies Solution Area     Cloud Computing     Google Cloud SQL for Developers
Google Cloud SQL allows developers to quickly create and manage instances of MySQL. It offers various tools for completing the tasks required to create and maintain the Cloud SQL environments as well as to create and deploy applications that store data in Cloud SQL. In this course, you will learn what Cloud SQL offers and how to use the Google Developers Console to create and manage Cloud SQL instances. This course is one of a series in the learning path that covers the objectives for the Google Cloud SQL Qualification exam CPE303.

Objectives

Cloud SQL Fundamentals

  • start the course
  • describe Cloud SQL
  • describe the benefits and features of Cloud SQL
  • identify the billing plans Google offers for Cloud SQL
  • describe the regions and zones used for Google Cloud Platform for storing data in Cloud SQL

Instance Creation

  • create a basic instance in Cloud SQL using the Developers Console
  • define a network and specify external address in Google Cloud Platform
  • define the external networks allowed to connect to a Cloud SQL instance using an IP address using the Developers Console
  • create a client SSL certification to connect to a Cloud SQL instance using Secure Socket Layer protocol using the Developers Console
  • configure MySQL flags for a Cloud SQL instance using the Developers Console
  • create a database in a Cloud SQL instance using the Developers Console
  • create user accounts to allow applications to connect to MySQL instance via IP using the Developers Console
  • edit the settings defined for a Cloud SQL instance using the Developers Console

Managing Instances

  • schedule backups and review backup history for a Cloud SQL instance using the Developers Console
  • restore a Cloud SQL instance from a backup, including to another instance, using the Developers Console
  • describe Cloud SQL Replication
  • enable Cloud SQL Read Replicas
  • stop, start, promote, and check the status of a Cloud SQL read replica
  • enable external read replicas for a Cloud SQL instance
  • view Cloud SQL instance usage data in the Developers Console
  • view Cloud SQL instance operation logs and view and export MySQL error logs
  • add a project member to manage a Cloud SQL instance
  • import data to Cloud SQL through the Developers Console
  • export data from Cloud SQL through the Developers Console
  • migrate MySQL 5.5 to MySQL 5.6 using the Developers Console

Practice: Create and Manage an Instance

  • create and manage a Google Cloud SQL Instance using the Developers Console