Learn how to design and build data warehouses using Google Cloud Platform solutions such as BigQuery.
Overview
Syllabus
Introduction
- Why data warehouses are important
- Data science modules covered
- GCP storage options
- Google Cloud Storage
- Cloud SQL
- Cloud Spanner
- Cloud Bigtable
- Cloud Datastore
- Cloud BigQuery
- Intro to BigQuery
- Projects and datasets
- Tables
- Create a dataset
- Create a table with schema
- Create a table from CSV
- Load data from Cloud Storage
- Simple queries
- Filter data
- SQL functions
- Regular expressions
- Grouping and aggregations
- Joins and sub-queries
- Update data
- Partition tables
- External data sources
- Create views
- Create labels
- Google Cloud shell
- Other interfaces
- Table design considerations
- Optimize storage
- Load data
- Speed up queries
- Monitoring and logging
- Next steps
Taught by
Kumaran Ponnambalam