• Google Cloud
  • Data Engineering and Analytics

Professional Data Engineer Certification Workshop

Contact us to book this course
Learning Track icon
Learning Track

Data Engineering and Analytics

Delivery methods icon
Delivery methods

On-Site, Virtual

Duration icon
Duration

2 days

This workshop is designed to help IT professionals prepare for the Google Cloud Certified – Professional Data Engineer exam.

In this workshop, we review the exam guidelines and product strategies for the major Cloud Storage, big data, and analytics services covered by the exam. We examine concepts related to data transformation, real-time processing, visualization, machine learning, and best practices to solve common problems.

This workshop assumes prior knowledge of Google Cloud and is not an introduction to Google Cloud. To see the full Google Cloud curriculum, click here.

Learning objectives

  • Prepare for the Google Cloud Professional Data Engineer certification exam
  • Choose the appropriate Google Cloud data storage solution
  • Store binary, relational, and NoSQL data using Google Cloud services
  • Secure data using IAM and encryption
  • Architect batch and streaming data processing pipelines on Google Cloud
  • Leverage Google Cloud tools for data manipulation, analysis, and visualization
  • Build machine learning models with Google Cloud tools

This workshop includes instructor lectures, group activities, case study discussions, practice exams, and links to recommended study, videos, and tutorials. Homework assignments are also included to help students further prepare for the exam.

Who should attend

IT professionals interested in obtaining the Google Certified Professional Data Engineer certification. Data scientists and machine learning practitioners who want to learn more about taking optimal advantage of the big data services provided by Google Cloud will also benefit from this course.

Prerequisites

Prior to taking the Google Cloud Data Engineer Professional exam, students should have prior experience working with Google Cloud big data services. The exam tests one’s understanding of architecting secure and reliable business solutions that leverage Google Cloud for storing, analyzing, and visualizing data. We strongly recommend taking the Data Engineering on Google Cloud course prior to attending this workshop.

Practice quizzes and case study examples

Included with this course are sample quizzes and numerous case study examples that will help you both prepare for the exam, and have a greater level of understanding of how to build data analytics and machine learning systems on Google Cloud.

Course outline

  • Storage Overview
  • Google Cloud Storage Options
  • Architecting Data Processing Solutions
  • Exam Prep
    • Practice Quiz
  • Cloud Storage
  • Persistent Disks
  • Encryption
  • Data Transfer Options
  • Exam Prep
    • Practice Quiz
  • Modeling Relational Data
  • Moving Relational Databases to Cloud SQL
  • Exercise: Cloud SQL Quickstart
  • Exploiting Spanner for Massively Scalable Relational Systems
  • Exercise: Cloud Spanner Quickstart
  • Exam Prep
    • Practice Quiz
  • Understanding NoSQL Storage
  • Simplifying Structured Storage with Cloud Firestore and Datastore
  • Exercise: Cloud Datastore/Firestore Quickstart
  • Storing Massive Data Sets with Bigtable
  • Choosing between Firestore and Bigtable
  • Caching Data using Memorystore
  • Exam Prep
    • Practice Quiz
  • Big Data Processing Overview
  • Migrating Hadoop and Spark Jobs to Cloud Dataproc
  • Exercise: Creating Dataproc Clusters
  • Big Data Warehousing and Analytics with BigQuery
  • Denormalizing Data for Query Optimization in BigQuery
  • Exercise: Querying Data with BigQuery
  • Choosing Big Data Processing Strategies
  • Exam Prep
    • Practice Quiz
  • Programming ETL Pipelines with Cloud Dataflow
  • Simplify Dataflow Coding Using Templates
  • Exercise: Cloud Dataflow
  • Designing Real-time Data Processing Systems
  • Leveraging Pub/Sub for Scalable, Asynchronous Messaging
  • Preparing Data for Analysis with Cloud DataPrep
  • Building Workflows with Composer
  • Preventing Data Misuse with Data Loss Prevention
  • Manipulating and Analyzing Data with Vertex AI Workbench
  • Building Dashboards with Looker Studio
  • Machine Learning Overview
  • Machine Learning Algorithms
  • Writing Code with Tensorflow
  • Building ML Models with Vertex AI
  • Leveraging Pre-Built ML Models
  • Creating Codeless Models with AutoML
  • Using SQL to Build Models with BigQuery ML
  • Exam Prep
    • Practice Quiz

Ready to accelerate your team's innovation?