menu
arrow_back

Introduction to SQL for BigQuery and Cloud SQL

75분 액세스 · 60분 완료
Connection Details

1 크레딧

info_outline
This lab costs 1 크레딧 to run. You can purchase credits or a subscription under My Account.

01:15:00

Introduction to SQL for BigQuery and Cloud SQL

GSP281

Google Cloud Self-Paced Labs

Overview

SQL (Structured Query Language) is a standard language for data operations that allows you to ask questions and get insights from structured datasets. It's commonly used in database management and allows you to perform tasks like transaction record writing into relational databases and petabyte-scale data analysis.

This lab serves as an introduction to SQL and is intended to prepare you for the many labs and quests in Qwiklabs on data science topics. This lab is divided into two parts: in the first half, you will learn fundamental SQL querying keywords, which you will run in the BigQuery console on a public dataset that contains information on London bikeshares.

In the second half, you will learn how to export subsets of the London bikeshare dataset into CSV files, which you will then upload to Cloud SQL. From there you will learn how to use Cloud SQL to create and manage databases and tables. Towards the end, you will get hands-on practice with additional SQL keywords that manipulate and edit data.

Objectives

In this lab, you will learn how to:

  • Distinguish databases from tables and projects.
  • Use the SELECT, FROM, and WHERE keywords to construct simple queries.
  • Identify the different components and hierarchies within the BigQuery console.
  • Load databases and tables into BigQuery.
  • Execute simple queries on tables.
  • Learn about the COUNT, GROUP BY, AS, and ORDER BY keywords.
  • Execute and chain the above commands to pull meaningful data from datasets.
  • Export a subset of data into a CSV file and store that file into a new Cloud Storage bucket.
  • Create a new Cloud SQL instance and load your exported CSV file as a new table.
  • Run CREATE DATABASE, CREATE TABLE, DELETE, INSERT INTO, and UNION queries in Cloud SQL.

Prerequisites

Important: Before starting this lab, log out of your personal gmail account.

This is a introductory level lab. This assumes little to no prior experience with SQL. Familiarity with Cloud Storage and Cloud Shell is recommended, but not required. This lab will teach you the basics of reading and writing queries in SQL, which you will apply by using BigQuery and Cloud SQL.

Before taking this lab, consider your proficiency in SQL. Below are more challenging labs that will let you apply your knowledge to more advanced use cases:

Once you're ready, scroll down and follow the steps below to get your lab environment set up.

Join

  • Temporary Access
  • Catalog
  • Bite Sized
Join To Start
점수

—/20

Create a cloud storage bucket

단계 진행

/ 5

Upload CSV files to Cloud Storage

단계 진행

/ 5

Create a Cloud SQL instance

단계 진행

/ 5

Create a database

단계 진행

/ 5

home
school
카탈로그
menu
펼치기
펼치기