QwikLab: BigQuery and Cloud SQL

Name: QwikLab: BigQuery and Cloud SQL
Start: 2020-12-19T18:00:00+03:00
End: 2020-12-19T20:00:00+03:00

GDG Kuwait

In this lab we will be discussing the following: 

- Overview

- Setup and Requirements

- The Basics of SQL

- Exploring the BigQuery Console

- More SQL Keywords: GROUP BY, COUNT, AS, and ORDER BY

- Working with Cloud SQL

- New Queries in Cloud SQL

Dec 19, 2020, 3:00 – 5:00 PM

33

RSVP'd

Key Themes

CloudData

About this event

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.