Introduction to SQL for BigQuery and Cloud SQL

In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.

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.

Very Important: Before starting this lab, log out of your personal or corporate 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.