Aspire Journeys

Working with Google Cloud SQL

  • 4 Courses | 4h 40m 30s
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Working with Google Cloud SQL is a comprehensive journey that teaches participants how to use Google Cloud's fully managed relational database service. Throughout the journey, participants will learn how to set up and manage a Google Cloud SQL instance, Google Cloud SQL architecture, creating and configuring Cloud SQL with MySQL, PostgreSQL, and with SQL Server. They will also gain experience with performing basic CRUD operation, understanding and creating replicas and backups. In addition, participants will learn advanced features such as Cloud SQL integrations, migration to Cloud SQL from MySQL and PostgreSQL using Database Migration service. They will also learn integrating Cloud SQL with Google App Engine and Google Big Query. Whether you're a developer, administrator, or architect, this journey will provide you with the hands-on experience and knowledge needed to effectively use Google Cloud SQL.

Track 1: Cloud Databases

In this track of the Working with Google Cloud SQL Aspire journey, the focus will be on cloud databases.

  • 1 Course | 53m 28s

Track 2: Google Cloud SQL Database

In this track of the Working with Google Cloud SQL Aspire journey, the focus will be on how to set up and manage a Google Cloud SQL instance, Google Cloud SQL architecture, creating and configuring Cloud SQL with MySQL, PostgreSQL, and with SQL Server. You will also gain experience with performing basic CRUD operation, understanding and creating replicas and backups. In addition, you will learn advanced features such as Cloud SQL integrations, migration to Cloud SQL from MySQL and PostgreSQL using Database Migration service, as well as learn integrating Cloud SQL with Google App Engine and Google Big Query. 

  • 3 Courses | 3h 47m 2s

COURSES INCLUDED

An Overview of Cloud Databases
Cloud databases are hosted on and often maintained by a cloud platform. The platform manages the hardware, networks, and OS, and users pay for the allocated or consumed resources. Through this course, learn what cloud-hosted databases have to offer, the factors that influence the adoption of a cloud database, and what to watch out for when using such systems. Explore the characteristics of cloud-hosted databases and the benefits and caveats of such services. Next, discover factors to consider when moving to the cloud. Finally, compare SQL and NoSQL systems and learn about some of the most powerful cloud-hosted database services. Upon completion, you'll be able to recognize the elements of different cloud databases and select the best option.
7 videos | 53m has Assessment available Badge

COURSES INCLUDED

Working with Google Cloud SQL: An Introduction to Cloud SQL
Google Cloud SQL is a cloud-hosted, fully-managed database service on Google Cloud Platform (GCP). With Cloud SQL, users focus on modeling and managing the data in the systems, and GCP takes care of the management of the infrastructure and platform. Through this course, learn about Cloud SQL's architecture and features and how to set up a MySQL instance on this service. Explore Cloud SQL and some of its significant features and use cases. Next, practice provisioning a MySQL database instance and connect to Cloud SQL from an external client. Finally, discover some important configuration options for a Cloud SQL instance. Upon completion, you'll be able to name Cloud SQL's features and use cases and provision a MySQL instance.
14 videos | 1h 47m has Assessment available Badge
Working with Google Cloud SQL: Advanced Topics in Cloud SQL
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.
14 videos | 1h 59m has Assessment available Badge
Final Exam: Working with Google Cloud SQL
Final Exam: Working with Google Cloud SQL will test your knowledge and application of the topics presented throughout the Working with Google Cloud SQL journey.
1 video | 32s has Assessment available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE TRACKS

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

Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Rating 4.4 of 78 users Rating 4.4 of 78 users (78)