Aspire Journeys
Working with Google Cloud SQL
- 4 Courses | 4h 40m 30s
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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.
