Google Cloud Storage and BigQuery
The workshop is divided into two parts:
The first focuses on storage, and the second focuses on BigQuery.In the first part, participants will learn about GCP storage options, including Cloud Storage, Cloud SQL, Cloud Spanner, Firestore, and Cloud Bigtable, and compare storage options. Participants will learn about each storage option’s unique features and use cases.
In the second part, participants will learn about the concept of a data warehouse, a column-based database, why BigQuery is essential, BigQuery UI, manage BigQuery, control usage costs, and design BigQuery tables to enhance performance.
Participants will also learn to work with complex data types such as struct, arrays, and JSONs.
By the end of the workshop, you will be able to manage, store, and large query datasets. You will also be equipped with the best practices to save money while querying and optimizing your queries to improve performance.
Have basic proficiency with the Google Cloud Platform.
Familiarity with Storage concepts and databases.
Level – Beginner
Important note: The class will be delivered in Hebrew. Participants must bring laptops to participate.
This course is intended for the following participants:
Individuals planning to deploy applications and create application environments on Google Cloud
Developers, systems operations professionals, DBA, and solution architects.
Executives and business decision-makers evaluating the potential of Google Cloud’s data capabilities to address their business needs.
- 9:30 - 10:00
- Breakfast & Networking
- 10:00 - 11:30
- GCP Storage Solutions - Part I
- Cloud Storage, Cloud SQL, Cloud Spanner, Firestore, Cloud Bigtable, Comparing storage options.
- 11:30 - 13:00
- BigQuery - Part 1
- Why BigQuery - the concept of data warehouse, column based database etc. BigQuery UI - get comfortable with it and understand what are the possibilities in BigQuery Manage your BigQuery - data types, create tables, load data, query external tables etc. Usage cost control - best practices to save money while querying.
- 13:00 - 13:45
- 13:45 - 16:45
- BigQuery - Part 2
- BigQuery Architecture, BigQuery table design for enhancing performance. BigQuery Execution plan - how to understand it and optimize queries. Working with complex data types - struct, arrays and JSONs.
- 16:45 - 17:00