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 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 a 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.
In the end, 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.
After the Study Jam, you’ll receive 30-days free access to the entire Qwiklabs catalogue, so you can keep developing your skills at home. Complete all of the labs in the session’s quest, and you’ll earn an additional free month of access to Qwiklabs as well as a badge for your online profile.
Bring a laptop and charger (PC, Mac or Chromebook)! The labs will run on all of the latest versions of popular browsers. For the best experience, make sure your laptop has Firefox or Chrome installed. Don’t forget your charger.