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.
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
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
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.
A
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.
B
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
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.
C
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.
D
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.
BigQueryWarehouse, partitioning, clustering, cost
Cloud StorageData lake, storage classes, lifecycle
Cloud SQLManaged MySQL, PostgreSQL, SQL Server
DatastreamChange data capture into BigQuery
DataflowApache Beam batch and streaming
DataprocManaged and serverless Spark
Cloud ComposerManaged Airflow orchestration
Pub/SubEvent ingestion, dead-letter queues
Cloud FunctionsEvent-driven processing with Eventarc
Dataform / dbtSQL transformations and testing
Monitoring & LoggingMetrics, alerts and log sinks
IAM & Secret ManagerLeast privilege and secrets
TerraformInfrastructure as code for GCP
Great ExpectationsData-quality checks and gates
GitHub ActionsCI/CD for pipelines
Looker StudioDashboards 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.
DataflowWindowingLate dataCI/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.
PySparkPartitioningClusteringCost
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 DAGsDataformQuality gatesAlerting
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.
CDCDatastreamTerraformIAM
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 EngineerBigQuery DeveloperCloud Data EngineerAnalytics EngineerData 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
Read the curriculumCheck the modules, projects and certification mapping against your goals.