> > > DEGCP

Data Engineering on Google Cloud Platform (DEGCP)

Course Description Schedule
 

Course Overview

This four-day instructor-led class provides participants a hands-on introduction to designing and building data processing systems on Google Cloud Platform. Through a combination of presentations, demos, and hand-on labs, participants will learn how to design data processing systems, build end-to-end data pipelines, analyze data and carry out machine learning. The course covers structured, unstructured, and streaming data.

Who should attend

This class is intended for experienced developers who are responsible for managing big data transformations including:

  • Extracting, Loading, Transforming, cleaning, and validating data
  • Designing pipelines and architectures for data processing
  • Creating and maintaining machine learning and statistical models
  • Querying datasets, visualizing query results and creating reports

Prerequisites

To get the most of out of this course, participants should have:

  • Completed Google Cloud Fundamentals: Big Data and Machine Learning (GCF-BDM) course OR have equivalent experience
  • Basic proficiency with common query language such as SQL
  • Experience with data modeling, extract, transform, load activities Developing applications using a common programming language such Python
  • Familiarity with Machine Learning and/or statistics

Course Objectives

This course teaches participants the following skills:

  • Design and build data processing systems on Google Cloud Platform
  • Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow
  • Derive business insights from extremely large datasets using Google BigQuery
  • Train, evaluate and predict using machine learning models using Tensorflow and Cloud ML
  • Leverage unstructured data using Spark and ML APIs on Cloud Dataproc
  • Enable instant insights from streaming data

Course Content

Module 1: Google Cloud Dataproc Overview
  • Creating and managing clusters.
  • Leveraging custom machine types and preemptible worker nodes.
  • Scaling and deleting Clusters.
  • Lab: Creating Hadoop Clusters with Google Cloud Dataproc.
Module 2: Running Dataproc Jobs
  • Running Pig and Hive jobs.
  • Separation of storage and compute.
  • Lab: Running Hadoop and Spark Jobs with Dataproc.
  • Lab: Submit and monitor jobs.
Module 3: Integrating Dataproc with Google Cloud Platform
  • Customize cluster with initialization actions.
  • BigQuery Support.
  • Lab: Leveraging Google Cloud Platform Services.
Module 4: Making Sense of Unstructured Data with Google’s Machine Learning APIs
  • Google’s Machine Learning APIs.
  • Common ML Use Cases.
  • Invoking ML APIs.
  • Lab: Adding Machine Learning Capabilities to Big Data Analysis.
Module 5: Serverless data analysis with BigQuery
  • What is BigQuery.
  • Queries and Functions.
  • Lab: Writing queries in BigQuery.
  • Loading data into BigQuery.
  • Exporting data from BigQuery.
  • Lab: Loading and exporting data.
  • Nested and repeated fields.
  • Querying multiple tables.
  • Lab: Complex queries.
  • Performance and pricing.
Module 6: Serverless, autoscaling data pipelines with Dataflow
  • The Beam programming model.
  • Data pipelines in Beam Python.
  • Data pipelines in Beam Java.
  • Lab: Writing a Dataflow pipeline.
  • Scalable Big Data processing using Beam.
  • Lab: MapReduce in Dataflow.
  • Incorporating additional data.
  • Lab: Side inputs.
  • Handling stream data.
  • GCP Reference architecture.
Module 7: Getting started with Machine Learning
  • What is machine learning (ML).
  • Effective ML: concepts, types.
  • ML datasets: generalization.
  • Lab: Explore and create ML datasets.
Module 8: Building ML models with Tensorflow
  • Getting started with TensorFlow.
  • Lab: Using tf.learn.
  • TensorFlow graphs and loops + lab.
  • Lab: Using low-level TensorFlow + early stopping.
  • Monitoring ML training.
  • Lab: Charts and graphs of TensorFlow training.
Module 9: Scaling ML models with CloudML
  • Why Cloud ML?
  • Packaging up a TensorFlow model.
  • End-to-end training.
  • Lab: Run a ML model locally and on cloud.
Module 10: Feature Engineering
  • Creating good features.
  • Transforming inputs.
  • Synthetic features.
  • Preprocessing with Cloud ML.
  • Lab: Feature engineering.
Module 11: Architecture of streaming analytics pipelines
  • Stream data processing: Challenges.
  • Handling variable data volumes.
  • Dealing with unordered/late data.
  • Lab: Designing streaming pipeline.
Module 12: Ingesting Variable Volumes
  • What is Cloud Pub/Sub?
  • How it works: Topics and Subscriptions.
  • Lab: Simulator.
Module 13: Implementing streaming pipelines
  • Challenges in stream processing.
  • Handle late data: watermarks, triggers, accumulation.
  • Lab: Stream data processing pipeline for live traffic data.
Module 14: Streaming analytics and dashboards
  • Streaming analytics: from data to decisions.
  • Querying streaming data with BigQuery.
  • What is Google Data Studio?
  • Lab: build a real-time dashboard to visualize processed data.
Module 15: High throughput and low-latency with Bigtable
  • What is Cloud Spanner?
  • Designing Bigtable schema.
  • Ingesting into Bigtable.
  • Lab: streaming into Bigtable.
Classroom Training
Modality: C

Duration 4 days

Price (excl. tax)
  • Germany: 2,600.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Dates and Booking
 
Click on town name to book Schedule
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
Germany
08/01/2019 - 11/01/2019 Hamburg
22/01/2019 - 25/01/2019 Münster
05/02/2019 - 08/02/2019 Munich
19/02/2019 - 22/02/2019 Berlin
05/03/2019 - 08/03/2019 Düsseldorf
19/03/2019 - 22/03/2019 Frankfurt
02/04/2019 - 05/04/2019 Hamburg
23/04/2019 - 26/04/2019 Stuttgart
FLEX Training

Please see below our alternative, English language, FLEX course options.

11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/London
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/Amsterdam
28/01/2019 - 31/01/2019 FLEX training This is an English language FLEX course.
Time zone: Asia/Istanbul
19/02/2019 - 22/02/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
19/02/2019 - 22/02/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Amsterdam
01/04/2019 - 04/04/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
14/05/2019 - 17/05/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
Switzerland
19/03/2019 - 22/03/2019 Zurich
24/06/2019 - 27/06/2019 Zurich
10/09/2019 - 13/09/2019 Zurich
10/12/2019 - 13/12/2019 Zurich
Austria
05/02/2019 - 08/02/2019 Vienna (iTLS)
06/05/2019 - 09/05/2019 Vienna (iTLS)
30/07/2019 - 02/08/2019 Vienna (iTLS)
04/11/2019 - 07/11/2019 Vienna (iTLS)

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Bulgaria
14/10/2019 - 17/10/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Sofia
Czech Republic
01/04/2019 - 04/04/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
Italy
22/01/2019 - 25/01/2019 Rome
19/02/2019 - 22/02/2019 Milan
09/04/2019 - 12/04/2019 Rome
21/05/2019 - 24/05/2019 Milan
23/07/2019 - 26/07/2019 Rome
03/09/2019 - 06/09/2019 Milan
12/11/2019 - 15/11/2019 Rome
10/12/2019 - 13/12/2019 Milan
Netherlands
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/Amsterdam
19/02/2019 - 22/02/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Amsterdam
14/05/2019 - 17/05/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Amsterdam
Portugal
29/01/2019 - 01/02/2019 Lisbon
14/05/2019 - 17/05/2019 Lisbon
23/07/2019 - 26/07/2019 Lisbon
05/11/2019 - 08/11/2019 Lisbon
Romania
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Serbia
02/09/2019 - 05/09/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Belgrade
Spain
22/01/2019 - 25/01/2019 Madrid
07/05/2019 - 10/05/2019 Madrid
16/07/2019 - 19/07/2019 Madrid
22/10/2019 - 25/10/2019 Madrid
Turkey
28/01/2019 - 31/01/2019 FLEX training This is an English language FLEX course.
Time zone: Asia/Istanbul
United Kingdom
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Europe/London
19/02/2019 - 22/02/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
14/05/2019 - 17/05/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
Latin America
Argentina
09/04/2019 - 12/04/2019 Online Training Time zone: America/Buenos_Aires Course language: Spanish
10/12/2019 - 13/12/2019 Online Training Time zone: America/Buenos_Aires Course language: Spanish
Brazil
19/03/2019 - 22/03/2019 Online Training Time zone: America/Sao_Paulo Course language: Portuguese
07/05/2019 - 10/05/2019 Online Training Time zone: America/Sao_Paulo Course language: Portuguese
24/09/2019 - 27/09/2019 Online Training Time zone: America/Sao_Paulo Course language: Portuguese
03/12/2019 - 06/12/2019 Online Training Time zone: America/Sao_Paulo Course language: Portuguese
Chile
21/01/2019 - 24/01/2019 Online Training Time zone: America/Santiago Course language: Spanish
25/09/2019 - 28/09/2019 Online Training Time zone: America/Santiago 3 days Course language: Spanish
Colombia
11/12/2018 - 14/12/2018 Online Training Time zone: America/Bogota Course language: Spanish
12/03/2019 - 15/03/2019 Online Training Time zone: America/Bogota Course language: Spanish
20/08/2019 - 23/08/2019 Online Training Time zone: America/Bogota Course language: Spanish
Costa Rica
14/05/2019 - 17/05/2019 Online Training Time zone: America/Costa_Rica Course language: Spanish
01/10/2019 - 04/10/2019 Online Training Time zone: America/Costa_Rica Course language: Spanish
Mexico
12/02/2019 - 15/02/2019 Online Training Time zone: America/Mexico_City Course language: Spanish
08/07/2019 - 11/07/2019 Online Training Time zone: America/Mexico_City Course language: Spanish
Peru
04/06/2019 - 07/06/2019 Online Training Time zone: America/Lima Course language: Spanish
05/11/2019 - 08/11/2019 Online Training Time zone: America/Lima Course language: Spanish
Asia Pacific
Singapore
11/12/2018 - 14/12/2018 FLEX training This is an English language FLEX course.
Time zone: Asia/Singapore
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!