Gcp Professional Dataengineer Certification-A Complete Guide

A Complete end to end knowledge on Google Cloud and Data Engineering stacks in GCP for aspiring data professionals!

What you'll learn

Start your journey on Google Cloud to become a Cloud Certified Professional Data Engineer

Knowledge on all the essential concepts related to data engineers like Database(SQL & NoSQL), BigData, Apache Beam, Apache Airflow and Apache Spark.

Complete Hands-on on GCP Core services like Compute engine, Kubernetes engine, App engine, Cloud Run and Cloud Functions.

Understand the best practices for building available, scalable, resilient and secure data pipelines on the Google Cloud Platform

You will acquire professional level data engineering skills in google cloud like Cloud SQL,Cloud DataStore/Firestore,BigQuery, Memorystore and Cloud Storage.

You will acquire professional level data engineering skills in google cloud like Cloud PubSub, Cloud Dataproc, Cloud Dataflow,DataFusion, BigTable and Composer.

Hands on Practical Lab Sessions in Services like Cloud Data Prep, Data Catalog and Looker Studio

Learn how to create big data ETL/ELT pipelines using Google Cloud platform

You will learn how to monitor pipelines using Cloud Monitor, Cloud Logging and Error Reporting with a real-world project.

Data-sets, Script files and command file used in lectures are available in resources tab. This will save your typing efforts.

Implement real life end-to-end solutions by combining latest available services in Google Cloud Platform.

Hands on Practical Lab Sessions

Ideal for candidates aspiring to clear Professional Data Engineer exam

Requirements

Google Cloud account Free trial - (valid debit or credit card)

Basic understanding of Python, PySpark and SQL

You have an attitude to learn while having fun

Description

ONLY COURSE YOU NEED TO GET READY for Google Cloud (GCP) Certified Professional Cloud Data Engineer Exam!Immerse in a classroom style coaching of GCP cloud data engineering certification topics. This course has 17+ Hours of insanely great video contents with 90+ hands-on Lab (Most Practical Course)Cloud is the future and GCP is Fastest growing Public cloud. 87 percentage of Google Cloud certified individuals are more confident about their cloud skills.Google Cloud Platform is one of the fastest-growing cloud service platforms offered today that lets you run your applications and data workflows at a 'Google-sized' scale.Google Cloud Certified Professional Cloud Data Engineer certification is one of the most highly desired IT certifications out today. It is also one of the most challenging exams offered by any cloud vendor today. Passing this exam will take many hours of study, hands-on experience, and an understanding of a very wide range of GCP services.Have a look at course curriculum, to see depth of Course coverage.This course also comes with:Lifetime access to all course material & updatesQ&A SectionUdemy Certificate of CompletionSo, What are you waiting for, Enroll NOW and I will see you inside course.Best Wishes,Vignesh Sekar.

Overview

Section 1: Overview of Cloud and Google Cloud Platform

Lecture 1 Course Introduction - Google Cloud Professional Data Engineer Certification

Lecture 2 Introduction On Cloud Computing

Lecture 3 Benefits of Cloud Computing

Lecture 4 Why Google Cloud Platform?

Lecture 5 GCP vs Azure vs AWS - A Brief Comparison

Lecture 6 Creating a GCP Account - free trial

Lecture 7 GCP account activation troubleshooting

Lecture 8 Important Message

Lecture 9 About Instructor

Section 2: Overview on Google Cloud Fundamentals

Lecture 10 Google Cloud - Regions and Zones

Lecture 11 Google Cloud - Resource Hierarchy

Lecture 12 Lab On GCP Console and Services Offered

Lecture 13 Lab on Google Cloud Project ID & Project Name

Lecture 14 Google Cloud - Cloud Shell & Cloud Editor

Lecture 15 Lab on Cloud Shell & Cloud Editor

Lecture 16 Lab on Cloud Shell & Cloud Editor[Contd]

Lecture 17 Google Cloud - Identity & Access Management (IAM)

Lecture 18 Lab on Google Cloud - IAM & Roles

Lecture 19 Google Cloud - Service Account & Types

Lecture 20 Lab on Google Cloud - Service Account

Section 3: Getting Started With Google Cloud Platform

Lecture 21 Managed Services in Google Cloud

Lecture 22 Google Cloud - Compute Engine(IAAS)

Lecture 23 Lab on Google Cloud - Compute Engine

Lecture 24 Google Cloud - App Engine(PAAS)

Lecture 25 Lab on Google Cloud App Engine - Python

Lecture 26 Google Cloud - Kuberentes Engine(IAAS)

Lecture 27 Lab on Google Cloud - Kubernetes Engine (CLI)

Lecture 28 Google Cloud - Cloud Run(CAAS)

Lecture 29 Lab on Google Cloud Cloud Run - Python

Lecture 30 Google Cloud - Cloud Function(FAAS)

Lecture 31 Lab on Google Cloud Cloud Function - Python

Section 4: Data Engineering - Overview

Lecture 32 Overview on Data Engineering

Lecture 33 Basic Terminologies in Data Engineering

Lecture 34 Scope of Data Engineering

Lecture 35 Types Of Data

Lecture 36 What is a data pipeline?

Lecture 37 What is ETL?

Lecture 38 What is ELT?

Lecture 39 Types Of ETL Tools

Section 5: Google Cloud Storage

Lecture 40 Overview on Google Cloud Storage

Lecture 41 Google Cloud Storage Hierarchy

Lecture 42 Features of Cloud Storage

Lecture 43 Lab on Creating Cloud Storage Bucket - Console

Lecture 44 Cloud Storage Classes - Types

Lecture 45 Lab on Creating Cloud Storage Bucket - gsutil (CLI) Commands

Lecture 46 Lab on Object Life Cycle Management - Cloud Storage Bucket

Lecture 47 Lab on Object Versioning - Cloud Storage Bucket

Lecture 48 Lab on Signed Temporary URL access - Cloud Storage Bucket

Lecture 49 Overview on Cloud IAM roles - Cloud Storage bucket

Lecture 50 Lab on on Cloud IAM roles - Cloud Storage bucket

Lecture 51 Lab on Bucket Retention policy - Cloud Storage Bucket

Lecture 52 Lab on Creating Cloud Storage Bucket - Client library(Python)

Lecture 53 Pricing on Cloud Storage buckets

Lecture 54 Popular Use Cases

Section 6: Google Cloud SQL

Lecture 55 Overview on Google Cloud SQL

Lecture 56 Features of Google Cloud SQL

Lecture 57 Lab on Creating SQL Instance(PostgreSQL) - Console

Lecture 58 Lab on Connecting to Cloud SQL Instance

Lecture 59 Lab on Allow Whitelisting in Cloud SQL Instance

Lecture 60 Lab on Creating SQL Instance(PostgreSQL) - CLI

Lecture 61 Lab on Import and Export Data files from Cloud SQL to Cloud Storage

Lecture 62 Lab on Cloud SQL Failover

Lecture 63 Cloud SQL Pricing

Lecture 64 Benefits of Cloud SQL

Section 7: Google Cloud Spanner

Lecture 65 Overview on Google Cloud Spanner

Lecture 66 What is CAP Theorem

Lecture 67 Features of Cloud Spanner

Lecture 68 Lab on Cloud Spanner - E2E

Lecture 69 Cloud Spanner Pricing

Lecture 70 Use cases & Drawbacks of Cloud Spanner

Lecture 71 Google Cloud SQL Vs Cloud Spanner - Which one to use and When

Section 8: Google Cloud BigTable

Lecture 72 History of BigTable

Lecture 73 Overview on Cloud BigTable

Lecture 74 Cloud BigTable Storage Model

Lecture 75 Overview on BigTable Architecture

Lecture 76 Features Of Cloud BigTable

Lecture 77 Lab on Cloud BigTable - HBase shell

Lecture 78 Lab on Cloud BigTable - cbt (CLI) Commands

Lecture 79 Cloud BigTable Pricing

Lecture 80 Pros & Cons of Cloud BigTable

Lecture 81 Popular Use cases

Lecture 82 Cloud BigTable Vs Apache HBase - A Brief Comparison

Section 9: Google Cloud Datastore and Firestore

Lecture 83 Overview on Cloud Datastore

Lecture 84 Features Of Cloud Datastore

Lecture 85 Cloud Datastore Pricing

Lecture 86 Best Practices for Cloud Datastore

Lecture 87 Overview on Cloud Firestore (Native mode)

Lecture 88 Features Of Cloud Firestore

Lecture 89 Cloud Firestore Pricing

Lecture 90 Best Practices for Cloud Firestore

Lecture 91 Datastore Mode Vs Native Mode - Which one to use and When

Section 10: Google Cloud MemoryStore

Lecture 92 Overview on Cloud Memory Store

Lecture 93 What is Memorystore for Redis

Lecture 94 Features of Cloud Memorystore - Redis

Lecture 95 Overview on GCP Memorystore - Redis in console

Lecture 96 Lab on Cloud Memory store - Redis Instance

Lecture 97 Pricing of Memorystore for Redis

Lecture 98 What is Cloud Memcached

Lecture 99 Features of Cloud Memorystore - Memcached

Lecture 100 Overview on GCP Memorystore - Memcached in console

Lecture 101 Pricing of Memorystore for Memcached

Lecture 102 Difference between Redis and Memcached

Section 11: Google Cloud BigQuery

Lecture 103 Overview on Cloud BigQuery

Lecture 104 Cloud BigQuery Hierarchy

Lecture 105 Features of Cloud Bigquery

Lecture 106 Lab on Cloud Bigquery - Console I

Lecture 107 Lab on Cloud Bigquery - Console II

Lecture 108 Lab on Cloud Bigquery - bq (CLI) Commands

Lecture 109 Lab on Cloud Bigquery - Client library(Python)

Lecture 110 Export BigQuery Table to Cloud Storage Bucket

Lecture 111 Pricing in Cloud BigQuery

Lecture 112 Use Cases of Google BigQuery

Lecture 113 BigQuery: Benefits of Use

Lecture 114 Other services in Cloud BigQuery

Section 12: Google Cloud Data Fusion

Lecture 115 Overview on Cloud Data Fusion

Lecture 116 Features of Cloud Data Fusion

Lecture 117 Lab on Cloud Data Fusion - I

Lecture 118 Lab on Cloud Data Fusion - II

Lecture 119 Cloud Data Fusion pricing

Section 13: Google Cloud PubSub

Lecture 120 Overview on Cloud PubSub

Lecture 121 Cloud PubSub Architecture

Lecture 122 Features on Cloud PubSub

Lecture 123 Types Of Cloud PubSub Services

Lecture 124 Lab on Cloud PubSub - Console

Lecture 125 Lab on Cloud PubSub - gcloud CLI

Lecture 126 Cloud PubSub Pricing

Lecture 127 Pros and Cons of Cloud PubSub

Lecture 128 Popular Use cases

Section 14: Google Cloud Dataproc

Lecture 129 Overview on Cloud Dataproc

Lecture 130 Features of Cloud Dataproc

Lecture 131 Why use Dataproc?

Lecture 132 Lab on Cloud Dataproc Console - Standard Cluster

Lecture 133 Lab on Cloud Dataproc CLI - Single Node Cluster

Lecture 134 Lab on Submitting Pyspark job in Notebook Instance

Lecture 135 Cloud Dataproc Pricing

Lecture 136 Best Practices and Limitations of Cloud Dataproc

Section 15: Google Cloud Dataflow

Lecture 137 Overview on Cloud Dataflow

Lecture 138 Features of Cloud Dataflow

Lecture 139 Why use GCP Dataflow?

Lecture 140 Overview on Dataflow Concepts

Lecture 141 Lab on Cloud Dataflow - Batch Predefined template

Lecture 142 Lab on Creating Dataflow Pipeline Custom template - Apache Beam(Python SDK)

Lecture 143 Cloud Dataflow Pricing

Lecture 144 Cloud Dataflow Use Cases

Lecture 145 Limitations of Cloud Dataflow

Lecture 146 Cloud Dataflow vs Cloud Dataproc - Which one to use when ?

Section 16: Google Cloud Composer

Lecture 147 Overview on Cloud Composer

Lecture 148 Features of Cloud Composer

Lecture 149 Difference between Composer 1 and Composer 2

Lecture 150 Lab on Cloud Composer Using Dataflow

Lecture 151 Architecture on Cloud Composer

Lecture 152 Cloud Composer Pricing

Lecture 153 Pros and Cons of Cloud Composer

Lecture 154 Popular Use cases

Section 17: Google Cloud Data Catalog

Lecture 155 Overview on Cloud Data Catalog

Lecture 156 Why do you need Data Catalog?

Lecture 157 How Data Catalog works

Lecture 158 Overview on Dataplex

Section 18: Google Cloud Dataprep

Lecture 159 Overview on Cloud Dataprep

Lecture 160 What is Dataprep by Trifacta

Lecture 161 Pricing of Cloud Dataprep

Lecture 162 Advantages and Limitations of Cloud Dataprep

Section 19: Google Cloud Looker Studio

Lecture 163 Overview on Looker Studio

Section 20: Labs based on Real Time Scenarios

Lecture 164 Streaming - Serverless Data Processing with Cloud Dataflow

Section 21: Professional Data Engineer - Preparing for Exam + Practice Exam

Lecture 165 Exam Tips

Lecture 166 Additional Resources

Lecture 167 Sample Question 1

Lecture 168 Sample Question 2

Lecture 169 Sample Question 3

Lecture 170 Sample Question 4

Lecture 171 Sample Question 5

Lecture 172 Sample Question 6

Lecture 173 Sample Question 7

Lecture 174 Sample Question 8

Lecture 175 Sample Question 9

Lecture 176 Sample Question 10

Lecture 177 Sample Question 11

Lecture 178 Sample Question 12

Lecture 179 Sample Question 13

Lecture 180 Sample Question 14

Lecture 181 Sample Question 15

Lecture 182 Sample Question 16

Lecture 183 Sample Question 17

Lecture 184 Sample Question 18

Lecture 185 Sample Question 19

Lecture 186 Sample Question 20

Section 22: Congratulations - Google Cloud Professional Certified Data Engineer

Lecture 187 Congratulations - Google Cloud Professional Certified Data Engineer

Lecture 188 Thank You

Lecture 189 Bonus Lecture

You want to start your Cloud Journey with Google Cloud Platform,You want to Clear Google Cloud Professional Data Engineer certification,You want to learn Deep Internals of Data Engineering components in Google Cloud.