Google Cloud Professional Data Engineer Certification with Practice Exam (2024 ver.)

+ 01 Introduction to data engineering 5 lectures

01 Data engineer role Locked

02 Introduction to BigQuery Locked

03 Data lakes and Warehouses Locked

04 Transactional Databases vs Data Warehouses Locked

05 Manage Data Access and Production Locked

+ 02 Building a data lake 5 lectures

01 Data storage and ETL options on Google Cloud Locked

02 Building a data lake with Cloud Storage Locked

03 Secure Cloud Storage Locked

04 Storing different data types Locked

05 Cloud SQL as a relational Data Lake Locked

+ 03 Building a data warehouse 6 lectures

01 Building a Data Warehouse Locked

02 BigQuery for Data Warehouses Locked

03 Load data into BigQuery Locked

04 Schema design in BigQuery Locked

05 Example case scenario - Nested and Repeated fields Locked

06 Optimize with Partitioning and Clustering Locked

+ 04 Managing and Securing Dataflow Operations in Google Cloud with Dataflow 6 lectures

01 Beam Portability Locked

02 Separate Compute and Storage with Dataflow Locked

03 Dataflow Identity Access Management Locked

04 Google Cloud Dataflow Quotas Locked

05 Enhance security while running Dataflow Locked

06 Dataflow security features Locked

+ 05 Essentials of Data Integration Techniques - From ETL to BigQuery Optimization 4 lectures

01 EL, ELT and ETL Locked

02 Build BigQuery Operations Locked

03 Using E-T-L Locked

04 Solve data quality issues with ETL Locked

+ 06 Optimize Big Data Processing with Hadoop and Spark on Dataproc 7 lectures

01 From Traditional Databases to Hadoop and Spark Ecosystems Locked

02 Run Hadoop on Dataproc Locked

03 Cloud Storage vs Hadoop Locked

04 Optimize Dataproc Locked

05 Optimize Dataproc Storage Locked

06 Optimize Dataproc templates and autoscaling Locked

07 Optimize Dataproc monitoring Locked

+ 07 Building Robust Data Processing Pipelines with Dataflow 7 lectures

01 Using Dataflow Locked

02 How Dataflow works Locked

03 Creating Dataflow pipelines with Python programming Locked

04 Designing a Dataflow pipeline Locked

05 Transform data with PTransforms Locked

06 Side inputs and windows of data Locked

07 Creating and re-using pipeline templates Locked

+ LAB - 01 Designing data processing systems 6 lectures

01.01 Working with Identity and Access Management (IAM) Locked

01.02 Data Encryption and Key Management Locked

01.03 Encrypt Data Uing Cutomer Managed Key Locked

01.04 Load data from Cloud Storage into BigQuery Locked

01.05 Run Queries in BigQuery Locked

Source Files Locked

+ LAB - 02 Working with Dataprep 4 lectures

02.01 Data Cleaning and Validation using Dataprep Locked

02.02 Uing Dataprep to validate files from Cloud Storage Locked

02.03 Creating Plans in DataPrep Locked

Source Files Locked

+ LAB - 03 Data Discovery and Inspection using Data Loss Prevention 5 lectures

03.01 Create a template in Data Loss Prevention Locked

03.02 Create scan configuration in DLP Locked

03.03 Create inspection job in Data loss prevention Locked

03.04 Visit Dashboard in Data Loss Prevention Locked

Source Files Locked

+ LAB - 04 Work with Data Catalog, BigQuery, and Cloud Run 8 lectures

04.01 Tag Dataet in Data Catalog Locked

04.02 Perform data transfer using BigQuery Locked

04.03 Create a delivery pipeline Locked

04.04 Create a release in delivery pipeline Locked

04.05 Verify the release in Cloud Run Locked

04.06 Create a servoce in Cloud Run Locked

04.07 Connect to Github repository Locked

Source Files Locked

+ LAB - 05 Working with Dataflow 4 lectures

05.01 Create a pipeline in dataflow Locked

05.02 Create a job in dataflow Locked

05.03 Work with SQL Workbench in Dataflow Locked

Source Files Locked

+ LAB - 06 Create and work with Virtual Private Cloud (VPC) 4 lectures

06.01 Work with Virtual Private Cloud (VPC) Locked

06.02 Create a Virtual Private Cloud Locked

06.03 Create a VPC Network Peering Locked

Source Files Locked

+ LAB - 07 Working with Cloud Composer 7 lectures

07.01 Create Cloud Composer Environment Locked

07.02 Accessing the Web Interface from the Google Cloud Console Locked

07.03 Get the details of your Composer environment Locked

07.04 Get the Database Connection Parameters Locked

07.05 Get the Database Endpoint Address Locked

07.06 Work with DAGs Locked

Source Files Locked

+ LAB - 08 Working with Cloud Datastore 6 lectures

08.01 Create a database using Cloud Datastore Locked

08.02 View the database properties using the cloud shell Locked

08.03 Store data in the database in Cloud Datastore Locked

08.04 View an entity in a database Locked

08.05 Run a query Locked

Source Files Locked

+ LAB - 09 Creating and Verifying instance 3 lectures

09.01 Create an intance in Bigtable Locked

09.02 Verify an instance in Big Table Locked

Source Files Locked

+ LAB - 10 Creating a SQL instance 6 lectures

10.01 Create an instance in Cloud SQL Locked

10.02 Create a MySQL database on the instance Locked

10.03 Create a table Locked

10.04 Import data into the table Locked

10.05 Create Views on the table Locked

Source Files Locked

+ LAB - 11 Work with Spanner 7 lectures

11.01 Work with Cloud Spanner Locked

11.02 Create a database in Spanner Locked

11.03 Create a table in Spanner Locked

11.04 Add data into a table in Spanner Locked

11.05 Update table schema Locked

11.06 Create an index Locked

Source Files Locked

+ LAB - 12 Work with Memorystore 5 lectures

12.01 Working with MemoryStore Locked

12.02 View instance information Locked

12.03 Edit an instance Locked

12.04 Delete an instance Locked

Source Files Locked

+ LAB - 13 Work with Pub-sub 3 lectures

13.01 Create a topic in pub sub Locked

13.02 Create a subscription Locked

Source Files Locked

+ LAB - 14 Work with Cloud Data Fusion and Dataproc 5 lectures

14.01 Work with Cloud Data Fusion Locked

14.02 Required Custom roles and permissions Locked

14.03 Work with the data pipeline Locked

14.04 Role of Dataproc ith Data Fusion Locked

Source Files Locked

+ Test Your Knowledge 1 lecture

Practice Exam Locked