GCP Data Engineer Pro: Optimizing a Google Data Warehouse

Google Cloud 2024    |    Intermediate
  • 9 videos | 59m 36s
  • Earns a Badge
Managing Google Cloud Platform (GCP) resources is not unlike unlocking the doors of your own store, where every lesson on cost management and resource optimization added means your business can stay open another day, serve another customer, and become a profitable business operation. In this course, discover the intricacies of GCP cost-efficiency and resource management, how to balance expenses, and orchestrate resources in Dataproc clusters. Next, learn about automating workflows with Cloud Composer or Workflows and create and execute DAGs for Cloud Composer. Finally, explore how to fine-tune BigQuery processing and master the nuances of workload management for BigQuery. This course is one of a collection that prepares learners for the Google Professional Data Engineer exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify what costs can be minimized while still achieving business needs
    List common techniques to optimize costs for database and smart analytics
    Recognize whether a persistent or ephemeral cluster is a better solution for a particular business case
    Compare how workflows and cloud composer can be used to orchestrate pipeline tasks
  • Use the tools in google cloud to create and run orchestration using a directed acyclic graph (dag) with cloud composer
    Outline the costs and benefits of selecting between interactive and batch query jobs in bigquery
    Identify how bigquery workload management enables control over resources
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 10s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 12m 9s
    Upon completion of this video, you will be able to identify what costs can be minimized while still achieving business needs. FREE ACCESS
  • Locked
    3.  Database and Smart Analytics Cost Optimization
    4m 45s
    After completing this video, you will be able to list common techniques to optimize costs for database and smart analytics. FREE ACCESS
  • Locked
    4.  Control Resources in Dataproc Clusters
    7m 1s
    Through this video, you will be able to recognize whether a persistent or ephemeral cluster is a better solution for a particular business case. FREE ACCESS
  • Locked
    5.  Pipeline Automation with Cloud Composer or Workflows
    9m 13s
    In this video, we will compare how Workflows and Cloud Composer can be used to orchestrate pipeline tasks. FREE ACCESS
  • Locked
    6.  Creating and Running a DAG for Cloud Composer
    8m 38s
    Discover how to use the tools in Google Cloud to create and run orchestration using a directed acyclic graph (DAG) with Cloud Composer. FREE ACCESS
  • Locked
    7.  BigQuery Processing Optimization
    8m 31s
    Upon completion of this video, you will be able to outline the costs and benefits of selecting between interactive and batch query jobs in BigQuery. FREE ACCESS
  • Locked
    8.  Workload Management for BigQuery
    7m 19s
    Through this video, you will be able to identify how BigQuery workload management enables control over resources. FREE ACCESS
  • Locked
    9.  Course Summary
    50s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Course GCP Data Engineer Pro: Navigating the Google Cloud Platform
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Google Professional Cloud Developer: Cloud Applications & APIs
Rating 4.4 of 78 users Rating 4.4 of 78 users (78)