Google Cloud Professional Data Engineer: Get Certified 2020
- Description
- Curriculum
- FAQ
- Reviews
The need for data engineers is constantly growing and certified data engineers are some of the top paid certified professionals. Data engineers have a wide range of skills including the ability to design systems to ingest large volumes of data, store data cost-effectively, and efficiently process and analyze data with tools ranging from reporting and visualization to machine learning. Earning a Google Cloud Professional Data Engineer certification demonstrates you have the knowledge and skills to build, tune, and monitor high performance data engineering systems.
This course is designed and developed by the author of the official Google Cloud Professional Data Engineer exam guide and a data architect with over 20 years of experience in databases, data architecture, and machine learning. This course combines lectures with quizzes and hands-on practical sessions to ensure you understand how to ingest data, create a data processing pipelines in Cloud Dataflow, deploy relational databases, design highly performant Bigtable, BigQuery, and Cloud Spanner databases, query Firestore databases, and create a Spark and Hadoop cluster using Cloud Dataproc.
The final portion of the course is dedicated to the most challenging part of the exam: machine learning. If you are not familiar with concepts like backpropagation, stochastic gradient descent, overfitting, underfitting, and feature engineering then you are not ready to take the exam. Fortunately, this course is designed for you. In this course we start from the beginning with machine learning, introducing basic concepts, like the difference between supervised and unsupervised learning. We’ll build on the basics to understand how to design, train, and evaluate machine learning models. In the process, we’ll explain essential concepts you will need to understand to pass the Professional Data Engineer exam. We’ll also review Google Cloud machine learning services and infrastructure, such as BigQuery ML and tensor processing units.
The course includes a 50 question practice exam that will test your knowledge of data engineering concepts and help you identify areas you may need to study more.
By the end of this course, you will be ready to use Google Cloud Data Engineering services to design, deploy and monitor data pipelines, deploy advanced database systems, build data analysis platforms, and support production machine learning environments.
ARE YOU READY TO PASS THE EXAM? Join me and I’ll show you how!
-
3Introduction to Object StorageVideo lesson
Understand what object storage is used for
-
4Options for Loading DataVideo lesson
Use gsutil, Transfer Service and other methods to upload data.
-
5Access Controls for Cloud StorageVideo lesson
Use IAM and access control lists to limit access to data in Cloud Storage
-
6Lifecycle Policy ManagementVideo lesson
Use policies to manage objects in Cloud Storage
-
7Using Cloud Storage ConsoleVideo lesson
Use GCP console to manage Cloud Storage
-
8Exercise: Cloud StorageVideo lesson
Check your understanding of Cloud Storage
-
9Solution: Cloud StorageVideo lesson
Know the solution to the exercise.
-
10Introduction to Relational DatabasesVideo lesson
Effectively use GCP's managed relational database options
-
11When to use Cloud SQLVideo lesson
Use Cloud SQL for regional and zonal relational databases
-
12Creating a Cloud SQL DatabaseVideo lesson
Create Cloud SQL databases
-
13Monitoring Cloud SQLVideo lesson
-
14Exercise: Create a Cloud SQL DatabaseVideo lesson
Check your knowledge of Cloud SQL
-
15Solution: Create a Cloud SQL DatabaseVideo lesson
Review the correct way to deploy a Cloud SQL database
-
16When to use Cloud SpannerVideo lesson
When to use Cloud Spanner for multi-regional and global database applicaitons
-
17Creating a Cloud Spanner DatabaseVideo lesson
Create a Cloud Spanner instance.
-
18Cloud Spanner Performance ConsiderationsVideo lesson
Optimized Cloud Spanner I/O performance
-
19Check Your Knowledge: Choosing a Primary Key for a Spanner TableText lesson
-
20Introduction to Cloud Firestore & Document DatabasesVideo lesson
-
21Entities and KindsVideo lesson
-
22Indexing in Cloud FirestoreVideo lesson
-
23Creating EntitiesVideo lesson
-
24Querying EntitiesVideo lesson
-
25Creating Kinds and NamespacesVideo lesson
-
26Working with TransactionsVideo lesson
-
27Exercise: Create a Kind and EntitiesVideo lesson
-
28Solution: Creating Kinds and EntitiesVideo lesson
-
29Introduction to Bigtable and Wide-Column DatabasesVideo lesson
-
30Creating a Bigtable InstanceVideo lesson
-
31Designing Row-keys for BigtableVideo lesson
-
32Query Patterns and DenormalizationVideo lesson
-
33Designing for Time Series DataVideo lesson
-
34Check Your Knowledge: Creating a Time Series DatabaseText lesson
-
35Introduction to BigQuery and Analytical DatabasesVideo lesson
-
36BigQuery Scalar DatatypesVideo lesson
-
37BigQuery Nested and Repeated FieldsVideo lesson
-
38Querying Scalars, Nested and Repeated FieldsVideo lesson
-
39Exercise: Querying BigQuery Public DatasetsVideo lesson
-
40Solution: Querying BigQuery Public DatasetsVideo lesson
-
41Access Controls in BigQueryVideo lesson
-
42Partitioning TablesVideo lesson
-
43Clustering Partitioned TablesVideo lesson
-
44Loading Data into BigQueryVideo lesson
-
63Stream and Batch Processing with Cloud DataflowVideo lesson
-
64Running a Job in Cloud DataflowVideo lesson
-
65Analyzing a Failed Job in Cloud DataflowVideo lesson
-
66Monitoring Cloud DataflowVideo lesson
-
67Troubleshooting a Cloud Dataflow PipelineVideo lesson
-
68Check Your Knowledge: Troubleshooting a Cloud Dataflow PipelineText lesson

External Links May Contain Affiliate Links read more