This Data Engineering on Google Cloud Platform course is designed to provide 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.
The Data Engineering on Google Cloud Platform course is intended for experienced developers who are responsible for managing big data transformations including:ul> Extracting, Loading, Transforming, cleaning, and validating data/li> Designing pipelines and architectures for data processing/li> Creating and maintaining machine learning and statistical models/li> Querying datasets, visualizing query results and creating reports/li>
- Completed Google Cloud Fundamentals: Big Data & Machine Learning 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.
Google Cloud Dataproc Overviewul> Creating and managing clusters./li> Leveraging custom machine types and preemptible worker nodes./li> Scaling and deleting Clusters./li> Lab: Creating Hadoop Clusters with Google Cloud Dataproc./li>Running Dataproc Jobsul> Running Pig and Hive jobs./li> Separation of storage and compute./li> Lab: Running Hadoop and Spark Jobs with Dataproc./li> Lab: Submit and monitor jobs./li>Integrating Dataproc with Google Cloud Platformul> Customize cluster with initialization actions./li> BigQuery Support./li> Lab: Leveraging Google Cloud Platform Services./li>Making Sense of Unstructured Data with Google's Machine Learning APIsul> Google's Machine Learning APIs./li> Common ML Use Cases./li> Invoking ML APIs./li> Lab: Adding Machine Learning Capabilities to Big Data Analysis./li>Serverless data analysis with BigQueryul> What is BigQuery./li> Queries and Functions./li> Lab: Writing queries in BigQuery./li> Loading data into BigQuery./li> Exporting data from BigQuery./li> Lab: Loading and exporting data./li> Nested and repeated fields./li> Querying multiple tables./li> Lab: Complex queries./li> Performance and pricing./li>Serverless, autoscaling data pipelines with Dataflowul> The Beam programming model./li> Data pipelines in Beam Python./li> Data pipelines in Beam Java./li> Lab: Writing a Dataflow pipeline./li> Scalable Big Data processing using Beam./li> Lab: MapReduce in Dataflow./li> Incorporating additional data./li> Lab: Side inputs./li> Handling stream data./li> GCP Reference architecture./li>Getting started with Machine Learningul> What is machine learning (ML)./li> Effective ML: concepts, types./li> ML datasets: generalization./li> Lab: Explore and create ML datasets./li>Building ML models with Tensorflowul> Getting started with TensorFlow./li> Lab: Using tf.learn./li> TensorFlow graphs and loops + lab./li> Lab: Using low-level TensorFlow + early stopping./li> Monitoring ML training./li> Lab: Charts and graphs of TensorFlow training./li>Scaling ML models with CloudMLul> Why Cloud ML?/li> Packaging up a TensorFlow model./li> End-to-end training./li> Lab: Run a ML model locally and on cloud./li>Feature Engineeringul> Creating good features./li> Transforming inputs./li> Synthetic features./li> Preprocessing with Cloud ML./li> Lab: Feature engineering./li>Architecture of streaming analytics pipelinesul> Stream data processing: Challenges./li> Handling variable data volumes./li> Dealing with unordered/late data./li> Lab: Designing streaming pipeline./li>Ingesting Variable Volumesul> What is Cloud Pub/Sub?/li> How it works: Topics and Subscriptions./li> Lab: Simulator./li>Implementing streaming pipelinesul> Challenges in stream processing./li> Handle late data: watermarks, triggers, accumulation./li> Lab: Stream data processing pipeline for live traffic data./li>Streaming analytics and dashboardsul> Streaming analytics: from data to decisions./li> Querying streaming data with BigQuery./li> What is Google Data Studio?/li> Lab: build a real-time dashboard to visualize processed data./li>High throughput and low-latency with Bigtableul> What is Cloud Spanner?/li> Designing Bigtable schema./li> Ingesting into Bigtable./li> Lab: streaming into Bigtable./li>