What you'll learn:
- Choose appropriate types of database for use cases from relational, document, wide-column, and analytical databases
- Manage database users, security, and networking access
- Implement database migrations and change data capture solutions
- Optimized database performance through modeling, partitioning, clustering, and replicas
- Manage data using exports, imports, and backups
- Monitor databases and troubleshoot problems
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 createdatabase 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 PostreSQLimplementation 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.
