Note: This Jam session is in the morning

Join a community of like-minded developers and
explore the latest Google Cloud technologies as a
team.
Join us for our upcoming Cloud Study Jam and get
hands-on experience with BigQuery for Data Warehousing

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.

BigQuery for Data Warehousing

Looking to build or optimize your data warehouse? Learn best practices to Extract, Transform, and Load your data into Google Cloud with BigQuery. In this series of interactive labs you will create and optimize your own data warehouse using a variety of large-scale BigQuery public datasets. BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.

* Create a Data Warehouse Through Joins and Unions
* Creating Date-Partitioned Tables in BigQuery
* Troubleshooting and Solving Data Join Pitfalls
* Working with JSON, Arrays, and Structs in BigQuery

https://google.qwiklabs.com/quests/68?catalog_rank=%7B%22rank%22%3A4%2C%22num_filters%22%3A1%2C%22has_search%22%3Atrue%7D&search_id=2794878