gammaticatech

Google Cloud Data Engineering

Learning Format

Online mode

Total training duration

120 hrs

Duration

3 Months

Certification

Yes

Google Cloud Data Engineering

The Google Cloud Data Engineering course focuses on building and managing data solutions using Google Cloud Platform (GCP). You’ll learn to design data pipelines, process and transform large datasets, and work with tools like BigQuery, Dataflow, and Pub/Sub. This course prepares you to develop efficient, scalable data solutions and pursue roles such as Data Engineer or Cloud Data Specialist.

Syllabus Summary

Data Storage & Lakehouse

  •  Cloud Storage for Data Lake
  • Partitioning, lifecycle policies
  • Best practices for Data Lakes in GCP
  • Hands-on: Setup Data Lake in Cloud Storage
  • Assignment

BigQuery 

  • Data Warehousing
  • BigQuery datasets, tables, partitions
  • Loading data from Cloud Storage
  • SQL queries in BigQuery
  • Partitioned & clustered tables
  • Hands-on: Query structured & semi-structured data
  • Assignment

Data Integration with Dataflow

  • Apache Beam concepts (batch & streaming pipelines)
  • Dataflow pipelines for ETL
  • Hands-on: Transform & load data from Pub/Sub → BigQuery
  • Assignment

Dataproc for Big Data

  • Cluster setup (Spark, Hadoop)
  • Submitting Spark jobs
  • Integration with Cloud Storage & BigQuery
  • Hands-on: ETL pipeline using Dataproc + Spark
  • Assignment
  • Mock Interview
  • Real-Time Data Processing with Pub/Sub- Pub/Sub topics & subscriptions
  • Push vs pull delivery models
  • Integrating Pub/Sub with Dataflow
  • Hands-on: Real-time streaming pipeline (Pub/Sub → Dataflow → BigQuery)
  • Assignment

Orchestration with Cloud Composer

  • Managed Apache Airflow overview
  • DAGs in Airflow for data workflows
  • Hands-on: Schedule BigQuery ETL job with Cloud Composer
  • Assignment

Visualization & BI- Looker

  • Studio basics (dashboards, data sources)
  • Connecting Looker Studio to BigQuery
  • Building reports for business insights
  • Hands-on: Create interactive BI dashboard
  • Assignment

Capstone Project & Interview Prep

  •  Project: Real-time Data Pipeline (Pub/Sub → Dataflow → BigQuery → Looker Studio)
  • Assignment
  • Mock Interview 2

Course Summary

Eligibility

Tech & Non-Tech Working professional, Freshers, Graduate from any domain.

Live Doubt Solving

Get your queries solved with daily dedicated doubts solving sessions.

Instructor

Experts and trainer for top-tech companies.

Certification

10+ ISO Globally recognized certified

Mode of Learning

100% Live Learning with experienced instructors and hands-on sessions.

Real time projects

Get practical experience with real-world projects for a career in analytics.

Certification

Scroll to Top