Google Cloud Professional Database Engineer Exam Prep (Udemy.com)

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 AlloyDB

• How to create database instance in managed database services

• Managing users

• Planning for high availability and reliability

• Database security best practices

• Creating, managing, and cloning databases

• Connecting securely to your databases

• Monitoring, logging, and alerting

• Best practices for importing, exporting, and backing up your databases

• Understanding data migration processes and how to execute database migrations

• Using specialized services, like Datastream, Database Migration Service and Oracle Bare Metal

• Understanding how to estimate database sizes and configure IOPS to meet performance requirements

We'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, a scalable PostreSQL implementation that is designed to support both online transaction processing and analytical workloads. You will also learn about Cloud Spanner, the managed, globally scalable relational database offered by Google Cloud.

In addition to relational databases, we dig into the details of BigQuery, a petabyte scale data warehouse, and analytics service. You'll learn how to use BigQuery's console to navigate datasets, organize data using partitioning and clustering, and control access to data in BigQuery.

Bigtable and Cloud Firestore are two managed NoSQL databases available in Google Cloud. In this course, you'll see how to create Bigtable databases, add clusters to a Bigtable instance, and design multidimensional schemas that are highly performant in Bigtable. You'll also learn about Cloud Firestore, a document database, that provides flexible schemas while also offering indexing and a query language that makes it an ideal choice for a database backend for many services.

In addition to knowing about different kinds of databases and when to use them, database engineers have to maintain and troubleshoot databases. This course will help you learn how to estimate the size of databases, monitor databases as well as configure security and networking for databases. You'll also learn about essential data management practices including change data capture (CDC) using Datastream and database migration using Database Migration Service.

Database migrations are an essential step to deploying applications and services in the cloud and they are some of the most challenging operations to plan and execute. This course includes in-depth lectures on the characteristics of database migrations, database migration processes, executing database migrations, ensuring data consistency between source and target databases, using change data capture and differential querying, draining and switchover, as well as fallback planning.

Database engineers are in demand because they understand how to build, deploy, and manage critical information infrastructure.   

Google Cloud has developed the Professional Cloud Database Engineer certification to distinguish database engineers with the necessary skills to operate high-performance databases in production environments in Google Cloud.   Join us in this course to advance your career as a certified Professional Database Engineer.