Google Cloud Professional Database Engineer Exam Prep

Focused View

Dan Sullivan,Daniel Sullivan

3:50:51

110 View

1 - Introduction

1 - Introduction.mp4

02:00

2 - First Look at Google Cloud.mp4

04:17

3 - How to Get Help If You Are Stuck.mp4

01:14

2 - Getting Started with Cloud SQL

1 - Quiz.html

4 - Introduction to Relational Databases.mp4

08:03

5 - When to Use Cloud SQL.mp4

01:40

6 - Creating a PostgreSQL Instance.mp4

05:09

7 - Adding and Deleting Users in Cloud SQL.mp4

02:33

8 - Cloning a Cloud SQL Database.mp4

03:54

9 - Deleting a Cloud SQL Instance.mp4

01:18

10 - Estimating the Cost of A Cloud SQL Database.mp4

06:03

3 - Cloud SQL Auth Proxy and SSL

2 - Quiz.html

11 - Overview of Cloud SQL Auth Proxy.mp4

03:47

12 - Installing Cloud SQL Auth Proxy.mp4

04:33

13 - Using SSL with Cloud SQL.mp4

03:35

4 - Additional Cloud SQL Functionality

3 - Quiz.html

14 - Importing and Exporting with Cloud SQL.mp4

03:13

15 - Best Practices for Importing and Exporting Data with Cloud SQL.mp4

02:19

16 - Replication in Cloud SQL.mp4

02:58

17 - Creating a Read Replica in Cloud SQL.mp4

03:06

18 - Creating Cloud SQL Backups.mp4

01:36

19 - Cloud SQL Maintenance.mp4

04:54

20 - Database Migration Service.mp4

07:21

21 - Using gcloud Commands with Cloud SQL.mp4

02:43

5 - AlloyDB

4 - Quiz.html

22 - Overview of AlloyDB.mp4

05:30

23 - Creating and AlloyDB Instance.mp4

05:00

24 - Estimating the Cost of AlloyDB Databases.mp4

02:32

6 - Cloud Spanner

5 - Quiz.html

25 - When to Use Cloud Spanner.mp4

01:05

26 - Creating a Cloud Spanner Instance.mp4

04:12

27 - Creating a Database and Tables in Cloud Spanner.mp4

02:58

28 - Adding Users to Cloud Spanner.mp4

01:23

29 - Deleting a Cloud Spanner Instance.mp4

00:38

30 - Cloud Spanner Change Streams.mp4

02:26

31 - Exporting Data from Cloud Spanner.mp4

03:13

32 - Importing Data to Cloud Spanner.mp4

02:06

33 - Cloud Spanner Performance Considerations.mp4

04:02

34 - Estimating the Cost of Cloud Spanner Instances.mp4

03:48

7 - BigQuery

6 - Quiz.html

35 - Introduction to BigQuery.mp4

03:40

36 - Navigating and Querying BigQuery Datasets.mp4

09:13

37 - Loading Data into BigQuery.mp4

03:43

38 - Partitioning and Clustering BigQuery Tables.mp4

04:13

39 - Access Controls in BigQuery.mp4

05:03

40 - Estimating the Cost of BigQuery.mp4

06:23

8 - Firestore

7 - Quiz.html

41 - Firestore and Document Databases.mp4

04:07

42 - Create a Collection in Firestore.mp4

04:37

43 - Firestore Indexes.mp4

04:32

44 - Firestore Importing and Exporting.mp4

03:18

45 - Estimating the Cost of a Firestore Database.mp4

02:56

9 - Bigtable

8 - Quiz.html

46 - Introduction to Bigtable.mp4

04:37

47 - Creating a Bigtable Instance.mp4

00:55

48 - Creating a Table in Bigtable.mp4

02:02

49 - Adding a Cluster to a Bigtable Instance.mp4

01:08

50 - Designing Bigtable Row Keys.mp4

06:01

51 - Denormalization Patterns in Bigtable.mp4

02:48

52 - Deleting a Bigtable Instance.mp4

00:55

53 - Bigtable App Profiles.mp4

02:48

54 - Estimating the Cost of Bigtable.mp4

03:06

10 - Database Operations

9 - Quiz.html

55 - Roughly Estimate Database Size.mp4

06:41

55 - Rough-Estimate-of-Database-Size.xlsx

56 - DBE-Estimating-Database-Sizes.pdf

56 - More Precisely Estimate Relational Database Size based on Database Platform.mp4

07:07

57 - Monitoring and Alerting.mp4

05:38

58 - Database Security Best Practices.mp4

04:57

59 - Datastream and Change Data Capture.mp4

01:58

60 - IP Addressing.mp4

03:30

61 - Private Service Connect.mp4

03:19

11 - Conclusions

62 - Exam Tips and Strategies.mp4

03:56

63 - Additional Resources.mp4

02:05

64 - Concluding Remarks.mp4

00:26

12 - Practice Exam

Description

Pass the Google Cloud Professional Database Engineer Exam

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

Who is this for?

Database administrators

Database engineers

Data modelers

Database developers

Cloud engineers

Data engineers

Data analysts

Application developers

Software engineers

More details

Description
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, and maintaining 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
How to create a Cloud SQLÂ database instance
Managing users
Creating, managing, and cloning databases
Connecting securely to your databases
Best practices for importing, exporting, and backing up your databases
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 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

User Reviews

Rating

average 0

Total votes0

Focused display

Dan Sullivan is a cloud architect, systems developer, and author of the Official Google Cloud Professional Architect Study Guide, the Official Google Cloud Professional Data Engineer Study Guide, and the Official Google Cloud Associate Engineer Study Guide. He is an experienced trainer and his online training courses have been viewed over 1 million times. Dan has extensive experience in multiple fields, including cloud architecture, data architecture and modeling, machine learning, data science, and streaming analytics.

Daniel Sullivan

Instructor's Courses

Founder of Sullivan Learning Group and author of courses on cloud computing, data engineering, and cloud architecture.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.