Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Experfy Team, Instructor - Google Cloud SQL Qualification Exam Training

Experfy Team

The Experfy Team consists of leading technologists based in Harvard Innovation Lab and forward-thinking tech companies.

Instructor: Experfy Team

Create and deploy applications that store data in Google Cloud SQL

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
Lecture 5 Egress bytes
Quiz 1 Google Cloud SQL Fundamentals

Module 2: Cloud SQL Database Administration

Lecture 6 MySQL flags
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

Reviews

4 Reviews

Empty user
Suvradeep R

July, 2017

I was inspired by this course where it was smooth sailing for me to learning to produce and expand operations and collect data in cloud SQL, and take care of its environment. Particularly well lined up, and carried out in a pattern where you would practice as you picked up and had different knowledge, as well as create and deploy applications that store data in Cloud SQL.

Empty user
Suresh S

July, 2017

Thanks to the instructors of this exceptional course. It helped me become intelligent cloud SQL proficient and be ready for the exam. Module on interacting with Cloud SQL was particualrly interesting.

Empty user
Fernand L

July, 2017

This is a formidable course of study and a must for everybody attempting cloud SQL proficiency. This is a great course for automating SQL environments! Just what I need! Thank you

Empty user
Jonathan F

July, 2017

The course covered all the technological information to keep up with maintaining Cloud SQL environments. The course work preps you well.

350