GCP Data Engineer Pro: BigQuery Data Warehouse

Google Cloud 2024    |    Intermediate
  • 21 videos | 1h 56m 44s
  • Includes Assessment
  • Earns a Badge
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
In order to answer the big questions, you'll need to have the right data, arranged in the right way. BigQuery is the main Google repository for data that will be used in analysis and machine learning (ML). In this course, you will navigate the BigQuery UI and command line interface (CLI), explore public datasets, and learn the art of dataset replication. We will unveil the process of creating robust datasets, delve into the world of BigQuery tables, views, routines, and connections, and uncover the capabilities of BigQuery search and vector indexes. You'll also gain proficiency in importing data, batch loading options, and publishing datasets for collaboration. The course will guide you through optimizing costs with various pricing models, and introduce you to Looker and Looker Studio, where you'll create and share insightful reports. Finally, you'll be equipped to troubleshoot both BigQuery and Looker, ensuring a smooth data analysis experience. 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
    Outline the use cases for implementing bigquery and its basic architecture for storage and analytics
    Query bigquery data by using bigquery data public datasets
    Outline the tools available in the cloud console and user interface (ui) for managing bigquery
    Select an appropriate method of regional or cross-regional replication
    Create a dataset in bigquery and describe when to use the various options available
    Outline the structure and use of tables and views in bigquery
    Identify how functions and stored procedures can be called for in the context of bigquery routines
    Outline how bigquery connections can be used to query data outside of bigquery
    Compare and contrast how search and vector indexes are used to improve query performance in bigquery
    Outline how to upload data into bigquery from a file or google sheet
  • Recognize the various options to load data including sql and bigquery data transfer service
    Identify the steps necessary to allow for controlled user access to datasets
    Select between different editions and pricing models to maximize the cost efficiency of using bigquery for various business needs
    Outline the use cases for using looker to visualize data from bigquery
    Create various reports to visually display data derived from bigquery
    Identify the methods of sharing looker reports to ensure that safe access can be granted to the reports
    Outline the options that affect the cost of using the google looker service
    Identify common issues that can arise with bigquery and how to troubleshoot them
    Identify common issues that can arise with looker and how to troubleshoot them
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 15s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 30s
    After completing this video, you will be able to outline the use cases for implementing BigQuery and its basic architecture for storage and analytics. FREE ACCESS
  • Locked
    3.  Viewing BigQuery Data Public Datasets
    8m
    In this video, you will learn how to query BigQuery data by using BigQuery data public datasets. FREE ACCESS
  • Locked
    4.  Navigating the BigQuery User Interface (UI) and Command Line Interface (CLI)
    4m 23s
    In this video, we will outline the tools available in the cloud console and user interface (UI) for managing BigQuery. FREE ACCESS
  • Locked
    5.  Replication Options for Datasets in BigQuery
    5m 18s
    Upon completion of this video, you will be able to select an appropriate method of regional or cross-regional replication. FREE ACCESS
  • Locked
    6.  Creating a Dataset
    3m 58s
    In this video, we will create a dataset in BigQuery and describe when to use the various options available. FREE ACCESS
  • Locked
    7.  BigQuery Tables and Views
    6m 47s
    After completing this video, you will be able to outline the structure and use of tables and views in BigQuery. FREE ACCESS
  • Locked
    8.  BigQuery Routines
    3m 57s
    Upon completion of this video, you will be able to identify how functions and stored procedures can be called for in the context of BigQuery routines. FREE ACCESS
  • Locked
    9.  BigQuery Connections
    3m 21s
    After completing this video, you will be able to outline how BigQuery connections can be used to query data outside of BigQuery. FREE ACCESS
  • Locked
    10.  BigQuery Search and Vector Indexes
    6m 3s
    Upon completion of this video, you will be able to compare and contrast how search and vector indexes are used to improve query performance in BigQuery. FREE ACCESS
  • Locked
    11.  Import Data into BigQuery
    9m 1s
    After completing this video, you will be able to outline how to upload data into BigQuery from a file or Google Sheet. FREE ACCESS
  • Locked
    12.  Options to Batch Load Data into BigQuery
    5m 33s
    Upon completion of this video, you will be able to recognize the various options to load data including SQL and BigQuery Data Transfer Service. FREE ACCESS
  • Locked
    13.  Dataset Publishing for Sharing
    5m 2s
    After completing this video, you will be able to identify the steps necessary to allow for controlled user access to datasets. FREE ACCESS
  • Locked
    14.  Pricing Models and BigQuery Cost Optimization
    7m 22s
    Upon completion of this video, you will be able to select between different editions and pricing models to maximize the cost efficiency of using BigQuery for various business needs. FREE ACCESS
  • Locked
    15.  Looker and Looker Studio
    4m 37s
    After completing this video, you will be able to outline the use cases for using Looker to visualize data from BigQuery. FREE ACCESS
  • Locked
    16.  Creating Reports in Looker
    5m 37s
    Find out how to create various reports to visually display data derived from BigQuery. FREE ACCESS
  • Locked
    17.  Report Sharing from Looker
    7m 33s
    Upon completion of this video, you will be able to identify the methods of sharing Looker reports to ensure that safe access can be granted to the reports. FREE ACCESS
  • Locked
    18.  Looker Pricing
    5m 33s
    After completing this video, you will be able to outline the options that affect the cost of using the Google Looker service. FREE ACCESS
  • Locked
    19.  BigQuery Troubleshooting
    6m 55s
    Upon completion of this video, you will be able to identify common issues that can arise with BigQuery and how to troubleshoot them. FREE ACCESS
  • Locked
    20.  Looker Troubleshooting
    4m 58s
    After completing this video, you will be able to identify common issues that can arise with Looker and how to troubleshoot them. FREE ACCESS
  • Locked
    21.  Course Summary
    1m 3s
    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 CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course GCP Data Engineer Pro: Building Robust Data Structures
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course GCP Data Engineer Pro: Optimizing a Google Data Warehouse
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)