GCP Data Engineer Live Classes
Contact us

Live classes, 2026 edition

GCP Data Engineer Live Classes

Build real batch and streaming pipelines on BigQuery, Dataflow, Dataproc, Cloud Composer and Pub/Sub, and prepare for the Google Cloud Professional Data Engineer certification.

Master GCP data engineering with live classes!

01 · Ingest Pub/Sub
02 · Process Dataflow
03 · Store BigQuery
04 · Visualise Looker Studio
50
hours of live classes
12
modules in 4 phases
4 + 1
projects and a capstone
PDE
certification prep

Created by Sagar Prajapati

Language:

About the course

Description:

This course is designed to provide live classes for aspiring data engineers looking to specialize in Google Cloud Platform (GCP) technologies. Participants will gain hands-on experience in designing, building, and maintaining data processing systems on GCP.

Key Highlights:

  • Hands-on learning with GCP technologies
  • Live classes with expert instructors
  • Practical projects and assignments
  • Interactive Q&A sessions

What you will learn:

  • Understanding GCP Data Engineering
    Learn the fundamentals of data engineering on Google Cloud Platform.
  • Building Data Processing Systems
    Design and build efficient data processing systems using GCP tools and services.
  • Optimizing Data Pipelines
    Optimize and monitor data pipelines for performance and reliability.
  • Real-world Projects
    Apply your skills to real-world projects and showcase your expertise.

Classes
12 modules, 50 hours of live classes held on weekdays, with labs and projects alongside
Projects
Four real-time industry projects plus a production-standard capstone, published to GitHub
Certification
Google Cloud Professional Data Engineer, with exam strategy and two timed mock exams
Prerequisites
Comfortable with Python and SQL. Module 02 covers Google Cloud from first principles.
Who it suits
Python-comfortable professionals and graduates, typically with 2 to 8 years of experience
Batch timing
Morning batch, 8:30 AM to 9:30 AM IST, on weekdays
Batch type
Recurring batch: the same morning slot repeats for every cohort

Engineers and analysts

  • Comfortable with Python and want a premium cloud specialisation
  • Moving from SQL or ETL tools into real pipeline engineering
  • Targeting product and cloud-native companies that run on Google Cloud

Data professionals

  • Want a less crowded, higher-value certification
  • Ready to build production pipelines, not only click through tools
  • Preparing for the Professional Data Engineer exam

Taught by two engineers who build on Google Cloud

A collaborative coaching program. Sagar and Manoj teach together and bring the production data work they do every day into class.

Sagar Prajapati

Sagar Prajapati

Founder, GeekCoders · Lead Data Engineer

Teaching data engineering through GeekCoders since 2022, and a founding member of a startup building a data platform on Databricks since 2024. Brings the same production approach to Google Cloud: pipelines, failures, governance and interviews, in the order you need them.

Manoj Kale

Manoj Kale

Co-instructor · Senior Data Engineer, Deloitte USI

Senior Data Engineer at Deloitte USI with 6+ years building data platforms. Has taught more than 1,000 students and leads the labs, troubleshooting sessions and interview practice.

12 modules in four phases

Every module follows the same rhythm: concepts with the internals explained, a hands-on build, a lab on realistic data, and an independent challenge. Tap a module to see what it covers.

Foundations

For anyone comfortable with Python who is new to data engineering or to Google Cloud.

01SQL for Data EngineeringFoundation
  • SELECT, JOINs, GROUP BY and subqueries
  • Window functions: ROW_NUMBER, RANK, LAG and LEAD
  • CTEs, including recursive CTEs
  • Query optimisation, execution plans and indexing

Lab: write 20 progressive SQL queries and build a cohort-retention analysis on a 1M-row dataset.

02Python for Data Engineering and GCP FoundationsFoundation
  • Functions, file, JSON and CSV I/O, requests and pandas
  • Reusable modules and clean project structure
  • GCP projects, IAM basics, gcloud CLI and Cloud Shell
  • Billing accounts and budget alerts

Lab: build an API-to-JSON-to-CSV script, then set up a GCP project with budget alerts.

Core Google Cloud data engineering

Security, storage and data lake design, BigQuery, streaming and batch pipelines, orchestration and monitoring.

03IAM, Security and Service AccountsCore
  • IAM roles, permissions and conditions
  • Service accounts and key management
  • Workload Identity Federation and organisation policies
  • Secret Manager, CMEK and Data Loss Prevention overview

Lab: create least-privilege service accounts, store credentials in Secret Manager, and configure Workload Identity.

04Cloud Storage, Cloud SQL and Data Lake DesignCore
  • GCS storage classes: Standard, Nearline, Coldline, Archive
  • Lifecycle, versioning and retention policies
  • Cloud SQL for relational sources (MySQL, PostgreSQL, SQL Server)
  • Datastream change-data-capture into BigQuery
  • Raw, Curated and Serving zone architecture

Lab: build a three-zone data lake on GCS, stand up a Cloud SQL instance, and stream its changes into BigQuery with Datastream.

05BigQuery Fundamentals and Data ModellingCore
  • BigQuery architecture: Dremel and Colossus
  • Slots, reservations, datasets and tables
  • INFORMATION_SCHEMA
  • Star schema, denormalisation and One Big Table

Lab: load a 10M-row dataset, build a star schema, and analyse query execution.

06BigQuery Advanced: Partitioning, Clustering and CostPDE exam
  • Range, ingestion-time and timestamp partitioning
  • Partition pruning and clustering keys
  • Materialised and authorised views; slot commitments
  • Cost optimisation: predicate pushdown, avoiding SELECT *

Lab: cut a simulated BigQuery bill by 60% or more using partitioning, clustering and scheduled queries.

07Dataflow and Apache BeamPDE exam
  • The Beam model: PCollections, PTransforms and runners
  • Windowing: fixed, sliding and session
  • Watermarks, triggers and exactly-once semantics
  • Flex Templates; batch and streaming pipelines

Lab: build a batch GCS-to-BigQuery pipeline and a streaming Pub/Sub-to-BigQuery pipeline, then deploy a Flex Template.

08Dataproc, PySpark and Pub/SubCore
  • Dataproc clusters and serverless Spark
  • PySpark optimisation: broadcast joins, AQE, skew handling
  • Pub/Sub topics, subscriptions and dead-letter queues
  • Cloud Functions (Gen 2) and Eventarc; event-driven patterns

Lab: run a PySpark ETL job on Dataproc, then build an event-driven order pipeline at 50K events per hour.

09Cloud Composer and OrchestrationCore
  • Cloud Composer 2 (managed Airflow)
  • DAGs, operators, task dependencies, XComs, pools and sensors
  • SLAs, dynamic DAGs and the DAG-factory pattern
  • Retries and alerting

Lab: build a 15-task production DAG for a daily data-warehouse refresh, with SLA alerting.

10Monitoring, Security and Cost OptimisationCore
  • Cloud Monitoring: metrics, uptime checks and alerting
  • Cloud Logging: sinks and log-based metrics
  • Security Command Center and VPC Service Controls
  • Committed-use discounts and rightsizing
  • Governance and data-protection patterns

Lab: build an end-to-end observability dashboard with alerting, and run a cost-optimisation audit.

Production engineering

CI/CD, infrastructure as code, data-quality gates and incident response, built the way production teams run them.

11Production EngineeringProduction
  • Git branching and pull requests
  • GitHub Actions CI/CD for Dataflow and Dataproc
  • Terraform for GCP infrastructure
  • Great Expectations data-quality gates
  • Secret Manager, monitoring and SLOs
  • Live incident simulation and postmortem

Lab: build a CI/CD pipeline that tests and deploys a Dataflow Flex Template behind a quality gate.

Capstone and certification

The capstone, Professional Data Engineer exam strategy, mock exams and career preparation.

12Capstone, Certification and Career WeekCapstone
  • Capstone delivery and review
  • Professional Data Engineer exam strategy and the 2026 domain review
  • Two timed mock exams
  • Resume, LinkedIn and ATS keywords
  • Mock interviews and job-search strategy

Lab: submit a deployed capstone, pass two timed mock exams, and complete a reviewed resume.

The tools in real GCP job descriptions

Each tool below is used in a lab or a project, not only shown on a slide.

BigQuery Warehouse, partitioning, clustering, cost
Cloud Storage Data lake, storage classes, lifecycle
Cloud SQL Managed MySQL, PostgreSQL, SQL Server
Datastream Change data capture into BigQuery
Dataflow Apache Beam batch and streaming
Dataproc Managed and serverless Spark
Cloud Composer Managed Airflow orchestration
Pub/Sub Event ingestion, dead-letter queues
Cloud Functions Event-driven processing with Eventarc
Dataform / dbt SQL transformations and testing
Monitoring & Logging Metrics, alerts and log sinks
IAM & Secret Manager Least privilege and secrets
Terraform Infrastructure as code for GCP
Great Expectations Data-quality checks and gates
GitHub Actions CI/CD for pipelines
Looker Studio Dashboards and the serving layer

Four industry projects for your resume

Each project matches the work GCP data engineers do at product companies and MNCs, and ships with a GitHub repository, a README, an architecture diagram and measurable impact statements.

Pub/Sub, Dataflow, BigQuery

Real-time retail analytics pipeline

Stream clickstream and order events through a Beam pipeline into a partitioned BigQuery warehouse, with deduplication, late-data handling and a Looker Studio dashboard, deployed through GitHub Actions.

Dataflow Windowing Late data CI/CD

GCS, Dataproc, BigQuery

Banking data warehouse with Medallion architecture

Land raw CSVs in GCS, transform them with PySpark on Dataproc through Bronze, Silver and Gold, and serve a curated BigQuery layer tuned with partitioning and clustering.

PySpark Partitioning Clustering Cost

Cloud Composer, Dataform, Great Expectations

Automated pipeline orchestration

Schedule multi-step ETL DAGs with Cloud Composer, run Dataform SQL transformations, enforce quality gates, and alert on SLA breach or failure.

Airflow DAGs Dataform Quality gates Alerting

Cloud SQL, Datastream, BigQuery, Terraform

CDC-driven lakehouse with Terraform

Stream live changes from Cloud SQL (MySQL) into BigQuery with Datastream, with VPCs, IAM, buckets and datasets provisioned and torn down by Terraform.

CDC Datastream Terraform IAM

Plus a production-standard capstone

An end-to-end platform, set for each cohort. A typical brief: an e-commerce retailer with hundreds of thousands of daily orders and millions of product events, ingested through Pub/Sub, processed with Dataflow and Dataproc, modelled in BigQuery, orchestrated with Composer and shipped through CI/CD with monitoring.

  • Git repository with pipeline code, README and architecture diagram
  • Documented BigQuery model with an entity diagram
  • Cloud Monitoring dashboard and alerts
  • Before-and-after BigQuery cost report
  • Five-minute video walkthrough of the live pipeline

Prepare for the Professional Data Engineer exam

Google's flagship data engineering certification validates that you can design, build, secure and monitor data processing systems on Google Cloud. It maps directly to the BigQuery, Dataflow, Dataproc and Composer work in this program.

Aligned to the 2026 exam objectives
  • Exam strategy and a review of the 2026 exam domains
  • Two timed mock exams
  • Scenario questions that test trade-offs across BigQuery, Dataflow, Dataproc and Composer
  • Exam-registration guidance

Google administers and awards the certification. You register and pay for the exam directly with Google, separately from the course fee, online or at an authorised test centre.

Roles this prepares you for

GCP Data Engineer BigQuery Developer Cloud Data Engineer Analytics Engineer Data Platform Engineer

Career support

  • Five mock interview rounds: technical, SQL, system design and behavioural
  • Resume review with ATS keywords for Naukri and LinkedIn
  • LinkedIn profile built around your capstone
  • Job-search strategy with referral templates
  • Access to the GeekCoders alumni network

What we promise, and what we don't

  • Taught by working data engineers, not slide-readers
  • Curriculum aligned to current Google Cloud certification objectives and real job descriptions
  • Every module ends in a hands-on build, not only a quiz
  • Four real-time projects and a capstone, published to GitHub
  • Refund and fit policies stated clearly before you enrol

We don't promise

Exam results, job placement or a specific salary. Pay depends on experience, employer, city and the market. What you get is current, job-ready skills, certification preparation and a portfolio that helps you get shortlisted.

How to join

  1. Read the curriculumCheck the modules, projects and certification mapping against your goals.
  2. Get in touchEmail info@geekcoders.co.in with your current role.
  3. Talk to usA short discovery call to check fit and answer your questions.
  4. Confirm your seatComplete enrolment and start with Module 01.

Have a question before you enrol? Join our WhatsApp group for batch updates and Q&A: Join our WhatsApp group

Take the full curriculum with you

Every module, lab, project and the certification mapping in one guide you can share with your manager.

Download curriculum

What learners say

Enroll now Download curriculum