hands-on lab

Structure and Analyze Data with Google BigQuery

Difficulty: Beginner
Duration: Up to 45 minutes
Students: 3,612
Rating: 4.5/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.

Description

Google BigQuery is a serverless, highly scalable and fully managed database service that allows you to handle and query a big amount of data in a very short time. BigQuery is designed to make data analysts more productive with unmatched price-performance. Because there is no infrastructure to manage, you can focus on uncovering meaningful insights using familiar SQL without the need for a database administrator. BigQuery is compatible with a lot of GCP's services, such as Cloud Datalab, that allow the user to represents data in an innovative way. This lab will show you the basic concepts of BigQuery and will allow you to handle data and query them in a real GCP environment.

Learning Objectives

Upon completion of this lab you will be able to:

  • Understand the key concepts of Google BigQuery
  • Explain what Datasets and Tables represent
  • Perform queries on data inside Google BigQuery

Intended Audience

This lab is intended for:

  • Google Cloud Associate Cloud Engineer (ACE) certification candidates
  • Individuals that are familiar with SQL and databases who want to deep know big data solutions
  • Solutions architects who want to build smart, efficient and responsive data infrastructures

Prerequisites

Basic knowledge of SQL and structured queries is a plus but it is not required. 

Updates

October 18th, 2022 - Updated screenshots and instructions due syntax error and updated UI

May 06, 2022 - Updated instructions and screenshots for accuracy

March 14th, 2022 - Updated lab screenshots to match the current environment

Environment before

Environment after

Covered topics

Lab steps

Signing In to the Google Cloud Console
Google BigQuery Core Concepts Overview
Creating a BigQuery Dataset
Importing a BigQuery Table
Composing a BigQuery Query