Google Cloud Digital Leader: Enterprise Data Warehouses

Google Cloud 2024    |    Beginner
  • 14 videos | 1h 53m 59s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Managing large-scale analytics and diverse data types is essential for organizations to derive valuable insights and optimize performance. Leveraging Google Cloud solutions like BigQuery, Bigtable, Firestore, and Looker enables businesses to efficiently handle analytical and semi-structured data, while gaining powerful business intelligence. Discover how to leverage BigQuery for large-scale analytics to manage and analyze extensive datasets effectively. You will explore Bigtable for semi-structured data and Firestore for real-time capabilities and ease of use. Next, you will learn how to choose the right storage solution for structured data. Then you will investigate the process of migrating databases to the cloud and the best practices for a smooth transition. Additionally, you will learn how to derive business intelligence and insights using Looker. Finally, you will focus on practical aspects of managing data in BigQuery to create datasets and tables, run queries, and optimize data management processes, use Looker Studio to visualize data, and practice command line operations with the bq tool. This course helps prepare learners for the Google Cloud Digital Leader certification exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify the place of bigquery among google cloud offerings
    Outline the strengths of bigquery for online analytical processing (olap) uses
    Outline the various considerations in choosing bigtable
    List the benefits and limitations of firestore
    Distinguish between different google cloud offerings for structured data
    Contrast lift and shift and database migration approaches
  • Outline the place of looker and looker studio in building dashboard applications
    Initialize bigquery via the cloud console
    Run simple queries in bigquery
    Perform data cleaning and create views
    Implement charting natively in bigquery as well as in looker studio
    Use bq to work with bigquery from the command line
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 41s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 7m 25s
    After completing this video, you will be able to identify the place of BigQuery among Google Cloud offerings. FREE ACCESS
  • Locked
    3.  BigQuery Analytic Workflows
    9m 31s
    Upon completion of this video, you will be able to outline the strengths of BigQuery for online analytical processing (OLAP) uses. FREE ACCESS
  • Locked
    4.  Bigtable for Semi-structured Data
    9m 22s
    After completing this video, you will be able to outline the various considerations in choosing Bigtable. FREE ACCESS
  • Locked
    5.  Firestore for Semi-structured Data
    8m 25s
    Upon completion of this video, you will be able to list the benefits and limitations of Firestore. FREE ACCESS
  • Locked
    6.  Choose the Right Storage Solution for Structured Data
    6m
    After completing this video, you will be able to distinguish between different Google Cloud offerings for structured data. FREE ACCESS
  • Locked
    7.  Migration to Cloud Databases
    8m 57s
    Upon completion of this video, you will be able to contrast lift and shift and database migration approaches. FREE ACCESS
  • Locked
    8.  Business Intelligence and Insights with Looker
    12m 18s
    After completing this video, you will be able to outline the place of Looker and Looker Studio in building dashboard applications. FREE ACCESS
  • Locked
    9.  Creating Datasets and Tables
    8m 44s
    In this video, find out how to initialize BigQuery via the Cloud Console. FREE ACCESS
  • Locked
    10.  Running Queries
    7m 50s
    Learn how to run simple queries in BigQuery. FREE ACCESS
  • Locked
    11.  Working with Views and Tables
    9m 28s
    During this video, discover how to perform data cleaning and create views. FREE ACCESS
  • Locked
    12.  Working with Looker Studio
    12m 6s
    Find out how to implement charting natively in BigQuery as well as in Looker Studio. FREE ACCESS
  • Locked
    13.  Using Command Line Operations with bq
    10m 14s
    In this video, you will learn how to use bq to work with BigQuery from the command line. FREE ACCESS
  • Locked
    14.  Course Summary
    1m 58s
    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 Google Cloud Digital Leader: Storage Options for Unstructured Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Course Google Cloud Digital Leader: Compliance & Operations on Google Cloud
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)