Jan 2023: Newly updated with additional material on database migration, meeting performance requirements, Oracle migrations, and more.Databases are the foundation of many of the applications and services that we use every day. Keeping them up and running is the responsibility of database engineers. In this course, you will learn essential skills and hear hard-learned lessons about designing, deploying, securing, maintaining and migrating highly scalable and highly available databases. By the end of the course, you'll be ready to take the Google Cloud Professional Database Engineer Exam and take on the responsibilities of a database engineer working in Google Cloud.The course begins with an introduction to relational databases and working with Cloud SQL, a regional, managed database service provided by Google Cloud. You will learn:When to use Cloud SQL, Cloud Spanner, Cloud Firestore, Bigtable, BigQuery, and AlloyDBHow to create database instance in managed database servicesManaging usersPlanning for high availability and reliabilityDatabase security best practicesCreating, managing, and cloning databasesConnecting securely to your databasesMonitoring, logging, and alertingBest practices for importing, exporting, and backing up your databasesUnderstanding data migration processes and how to execute database migrationsUsing specialized services, like Datastream, Database Migration Service and Oracle Bare MetalUnderstanding how to estimate database sizes and configure IOPS to meet performance requirementsWe'll also cover database maintenance and how to migrate a self-managed database to Cloud SQL. But we don't stop with Cloud SQL. Google Cloud offers AlloyDB
What you'll learn
Understand how to work with different Google Cloud database services including Cloud SQL, Cloud Spanner, and BigQuery
Learn how to design, deploy, and maintain scalable databases
Master database security and high availability practices
Execute database migrations using specialized tools