GCP Data Engineer Pro: Google Cloud OLTP Structured Data Storage

Google Cloud 2024    |    Intermediate
  • 16 videos | 2h 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Google Cloud online transaction processing (OLTP) structured data storage is essential for high availability, scalability, real-time processing, and data integrity, enabling businesses to handle large volumes of data efficiently and securely. In this course, you will explore the architecture and uses of Google Cloud SQL as an OLTP database platform. Discover how business goals like Recovery Point Objective (RPO) and Recovery Time Objective (RTO) influence the selection of Cloud SQL editions. Learn the core tasks involved in managing a Google Cloud SQL database instance, execute database-level management tasks, examine strategies to ensure data availability and access, and implement failback procedures. You will use Google Database Migration Service to migrate existing databases to the Google Cloud Platform (GCP), delve into the functionality of and use cases for Google Cloud Spanner, set up a Spanner instance, and manage it at a high level. Finally, you will establish a database on a Spanner instance and carry out database-level management tasks. This course is one of a collection that prepares learners for the Google Cloud Certified - Professional Data Engineer exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Describe google cloud sql and its uses as an online transaction processing (oltp) database platform
    Describe how the business goals of scalability, recovery point objective (rpo), and recovery time objective (rto) fit into choosing a cloud sql edition
    Identify the core tasks associated with managing a database instance on google cloud sql
    Start up a cloud sql instance and perform high level instance management
    Create a database on an instance of cloud sql and perform database level management tasks including verifying data with a query
    Describe the process used to ensure data is available even in the event of access failure
    Implement a failback to recover an initial deployment on cloud sql
  • Describe how google database migration service can be used to bring existing databases onto the google cloud platform (gcp)
    Describe the functionality of and use cases for google cloud spanner as a relational database
    Start up a spanner instance and perform high level instance management
    Create a database on an instance of spanner and perform database level management tasks, including verifying data with a query
    Describe the pricing options for unstructured data and select the most appropriate model for a business case
    Identify and troubleshoot common issues that can arise with cloud sql
    Identify and troubleshoot common issues that can arise with cloud spanner
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 42s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 8m 7s
    After completing this video, you will be able to describe Google Cloud SQL and its uses as an online transaction processing (OLTP) database platform. FREE ACCESS
  • Locked
    3.  Choosing the Best Cloud SQL Edition
    8m 38s
    Upon completion of this video, you will be able to describe how the business goals of scalability, Recovery Point Objective (RPO), and Recovery Time Objective (RTO) fit into choosing a Cloud SQL edition. FREE ACCESS
  • Locked
    4.  Core Management Tasks in Cloud SQL
    10m 38s
    After completing this video, you will be able to identify the core tasks associated with managing a database instance on Google Cloud SQL. FREE ACCESS
  • Locked
    5.  Provisioning Cloud SQL Instances
    7m 47s
    In this video, find out how to start up a Cloud SQL instance and perform high level instance management. FREE ACCESS
  • Locked
    6.  Creating Databases on Cloud SQL
    7m 57s
    Learn how to create a database on an instance of Cloud SQL and perform database level management tasks including verifying data with a query. FREE ACCESS
  • Locked
    7.  Creating High Availability on Cloud SQL
    10m 23s
    Upon completion of this video, you will be able to describe the process used to ensure data is available even in the event of access failure. FREE ACCESS
  • Locked
    8.  Recovering from Failure on Cloud SQL
    3m 34s
    During this video, discover how to implement a failback to recover an initial deployment on Cloud SQL. FREE ACCESS
  • Locked
    9.  Migration to Google Cloud SQL
    8m 36s
    After completing this video, you will be able to describe how Google Database Migration Service can be used to bring existing databases onto the Google Cloud Platform (GCP). FREE ACCESS
  • Locked
    10.  Google Cloud Spanner
    8m 52s
    Upon completion of this video, you will be able to describe the functionality of and use cases for Google Cloud Spanner as a relational database. FREE ACCESS
  • Locked
    11.  Provisioning a Spanner Instance, Database, and Schema
    4m 21s
    Find out how to start up a Spanner instance and perform high level instance management. FREE ACCESS
  • Locked
    12.  Defining Cloud Spanner Schema and Adding Data
    4m 14s
    In this video, you will learn how to create a database on an instance of Spanner and perform database level management tasks, including verifying data with a query. FREE ACCESS
  • Locked
    13.  Pricing Out Structured Data Services
    8m 52s
    After completing this video, you will be able to describe the pricing options for unstructured data and select the most appropriate model for a business case. FREE ACCESS
  • Locked
    14.  Troubleshooting Cloud SQL
    13m 27s
    Upon completion of this video, you will be able to identify and troubleshoot common issues that can arise with Cloud SQL. FREE ACCESS
  • Locked
    15.  Troubleshooting Cloud Spanner
    12m 46s
    After completing this video, you will be able to identify and troubleshoot common issues that can arise with Cloud Spanner. FREE ACCESS
  • Locked
    16.  Course Summary
    1m 2s
    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 GCP Data Engineer Pro: Creating a Pipeline of Services
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Google Professional DevOps Engineer: Architecture Optimization & Best Practices
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
Course GCP Data Engineer Pro: Optimizing a Google Data Warehouse
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)