Working with Google Cloud SQL: Advanced Topics in Cloud SQL

Google Cloud    |    Intermediate
  • 14 videos | 1h 59m 29s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Cloud SQL is a relational database service that has a lot to offer. Features such as high availability and more are built into the service, which has been widely adopted across industries. Through this course, learn about advanced Cloud SQL topics. Practice provisioning Cloud SQL instances that are running both PostgreSQL and MySQL database engines and configuring a Cloud SQL instance for high availability. Next, discover how to test a failover process and how read replicas can be provisioned. Finally, learn how to migrate from a VM MySQL database to a MySQL instance in Google Cloud SQL and integrate a Cloud SQL instance with App Engine and BigQuery. Upon completion, you'll be able to provision instances of Cloud SQL using different database engines.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Set up and configure a cloud sql instance with a postgresql engine
    Create and configure a cloud sql instance with a sql server engine
    Set up a cloud sql auth proxy to connect to a sql server instance on cloud sql
    Set up a cloud sql instance for high availability and a window for automated backups
    Provision a read replica for a cloud sql instance and test a failover process
    Disconnect read replicas from a cloud sql instance
  • Generate an on-demand backup of a cloud sql instance and use it to recover to a previous database state
    Provision a virtual machine running a mysql server to be used as the migration source
    Configure a migration job to migrate from a mysql server on a vm to a cloud sql for mysql instance
    Migrate data to cloud sql from a mysql server and confirm the transfer of data
    Create a python web app using google app engine to query the contents of a cloud sql for mysql database
    Set up bigquery to enable the direct querying of data from a mysql instance
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 45s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 58s
    Upon completion of this video, you will be able to set up and configure a Cloud SQL instance with a PostgreSQL engine. FREE ACCESS
  • Locked
    3.  Creating a SQL Server Instance on Cloud SQL
    9m 32s
    In this video, find out how to create and configure a Cloud SQL instance with a SQL Server engine. FREE ACCESS
  • Locked
    4.  Connecting to SQL Server via a Proxy
    7m 56s
    During this video, you will learn how to set up a Cloud SQL Auth proxy to connect to a SQL Server instance on Cloud SQL. FREE ACCESS
  • Locked
    5.  Configuring High Availability and Backups
    9m 55s
    After completing this video, you will be able to set up a Cloud SQL instance for high availability and a window for automated backups. FREE ACCESS
  • Locked
    6.  Provisioning Read Replicas and Performing Failovers
    11m 31s
    Discover how to provision a read replica for a Cloud SQL instance and test a failover process. FREE ACCESS
  • Locked
    7.  Working with Read Replicas
    8m 34s
    In this video, learn how to disconnect read replicas from a Cloud SQL instance. FREE ACCESS
  • Locked
    8.  Generating and Using On-demand Backups
    6m 28s
    Find out how to generate an on-demand backup of a Cloud SQL instance and use it to recover to a previous database state. FREE ACCESS
  • Locked
    9.  Creating a Source for a MySQL Migration
    9m 38s
    Upon completion of this video, you will be able to provision a virtual machine running a MySQL server to be used as the migration source. FREE ACCESS
  • Locked
    10.  Defining a Migration Job
    11m 30s
    During this video, discover how to configure a migration job to migrate from a MySQL server on a VM to a Cloud SQL for MySQL instance. FREE ACCESS
  • Locked
    11.  Migrating from MySQL to Cloud SQL
    7m 41s
    Learn how to migrate data to Cloud SQL from a MySQL server and confirm the transfer of data. FREE ACCESS
  • Locked
    12.  Integrating Google App Engine with Cloud SQL
    11m 22s
    After completing this video, you will be able to create a Python web app using Google App Engine to query the contents of a Cloud SQL for MySQL database. FREE ACCESS
  • Locked
    13.  Querying Cloud SQL Data from Google BigQuery
    8m 15s
    In this video, you will learn how to set up BigQuery to enable the direct querying of data from a MySQL instance. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 25s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Google Professional Cloud Architect: Becoming a Google Cloud Architect
Rating 4.4 of 72 users Rating 4.4 of 72 users (72)
Course Google Professional Cloud Architect: Designing Google Cloud Databases
Rating 4.4 of 24 users Rating 4.4 of 24 users (24)
Course Google Associate Cloud Engineer: Implementing Google Compute Engine
Rating 4.6 of 88 users Rating 4.6 of 88 users (88)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Databricks & Data Pipelines
Rating 4.3 of 42 users Rating 4.3 of 42 users (42)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Book SQL for Dummies, 9th Edition