Google Cloud Professional Database Engineer Exam Prep

Know How to Design for High Availability and Reliability, Use Relational and NoSQL, Plan and Execute Database Migrations

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

Requirements
Some experience with cloud computing is helpful

Description
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, 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.

Who this course is for:
Database administrators,Database engineers,Data modelers,Database developers,Cloud engineers,Data engineers,Data analysts,Application developers,Software engineers