deepdives.eu course additional material

Links to additional materials for students of deepdives.eu courses

View My GitHub Profile

Introduction to Data Analytics on Google Cloud links

Module 00: Course Introduction

Full name: Introduction to Data Analytics on Google Cloud

Product code: T-IDAGC-B

These links are based on the current course version.

Online course options:

Introduction to Data Analytics on Google Cloud - Google Cloud Skills Boost
Introduction to Data Analytics on Google Cloud - Coursera

Module 01: Understanding the Data Analytics Lifecycle on Google Cloud

Websites

What is data analytics? https://cloud.google.com/learn/what-is-data-analytics
Cloud Storage documentation https://cloud.google.com/storage/docs
Cloud Storage classes https://cloud.google.com/storage/docs/storage-classes
Pub/Sub overview https://cloud.google.com/pubsub/docs/overview
Dataproc documentation https://cloud.google.com/dataproc/docs
Dataflow documentation https://cloud.google.com/dataflow/docs
Cloud Data Fusion documentation https://cloud.google.com/data-fusion/docs
Cloud SQL documentation https://cloud.google.com/sql/docs
AlloyDB for PostgreSQL https://cloud.google.com/alloydb/docs
Cloud Spanner documentation https://cloud.google.com/spanner/docs
Firestore documentation https://cloud.google.com/firestore/docs
Bigtable documentation https://cloud.google.com/bigtable/docs
BigQuery overview https://cloud.google.com/bigquery/docs/introduction
Looker documentation https://cloud.google.com/looker/docs
Vertex AI documentation https://cloud.google.com/vertex-ai/docs
Database options on Google Cloud https://cloud.google.com/products/databases

Videos

Cloud Storage in a minute https://www.youtube.com/watch?v=wNOs3LlsH6k
What is Pub/Sub? https://www.youtube.com/watch?v=cvu53CnZmGI
What is Dataflow? https://www.youtube.com/watch?v=KalJ0VuEM7s
Dataproc in a minute https://www.youtube.com/watch?v=Jj6mp7Sam10
What is BigQuery? https://www.youtube.com/watch?v=m8WqxLd1jSc
Understanding Looker and Looker Studio https://www.youtube.com/watch?v=bUh5cGOSoaM
What is Vertex AI? https://www.youtube.com/watch?v=gT4qqHMiEpA
What is Cloud SQL? https://www.youtube.com/watch?v=Kl8ig2BtLAY
What is Cloud Spanner? https://www.youtube.com/watch?v=bUSU1e9j8wc
What is Cloud Bigtable? https://www.youtube.com/watch?v=P4q4nqJAamo

Module 02: Exploring Data and Extracting Insights Using BigQuery

Websites

BigQuery documentation https://cloud.google.com/bigquery/docs
Introduction to BigQuery https://cloud.google.com/bigquery/docs/introduction
Loading data into BigQuery https://cloud.google.com/bigquery/docs/loading-data
Querying data in BigQuery https://cloud.google.com/bigquery/docs/running-queries
BigQuery SQL reference https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
DDL statements in BigQuery https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language
DML statements in BigQuery https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
Views in BigQuery https://cloud.google.com/bigquery/docs/views
Materialized views https://cloud.google.com/bigquery/docs/materialized-views-intro
User-defined functions (UDFs) https://cloud.google.com/bigquery/docs/reference/standard-sql/user-defined-functions
BigQuery ML overview https://cloud.google.com/bigquery/docs/bqml-introduction
Scheduled queries https://cloud.google.com/bigquery/docs/scheduling-queries
BigLake overview https://cloud.google.com/biglake/docs/introduction
External tables https://cloud.google.com/bigquery/docs/external-tables
Querying Google Sheets data https://cloud.google.com/bigquery/docs/external-data-drive
Federated queries https://cloud.google.com/bigquery/docs/federated-queries-intro
BigQuery GIS (Geospatial analytics) https://cloud.google.com/bigquery/docs/geospatial-intro
Nested and repeated fields https://cloud.google.com/bigquery/docs/nested-repeated
BigQuery DataFrames (bigframes) https://cloud.google.com/bigquery/docs/bigquery-dataframes-introduction
Gemini in BigQuery https://cloud.google.com/gemini/docs/bigquery/overview
BigQuery data canvas https://cloud.google.com/bigquery/docs/data-canvas
Python notebooks in BigQuery https://cloud.google.com/bigquery/docs/notebooks-introduction
bq command-line tool https://cloud.google.com/bigquery/docs/bq-command-line-tool

Videos

BigQuery in a minute https://www.youtube.com/watch?v=CFw4peH2UwU
BigLake in a minute https://www.youtube.com/watch?v=UdpNYk0EP0g
BigQuery ML in a minute https://www.youtube.com/watch?v=0RMT8uEplbM
Use BigQuery & Gemini AI for Data Analytics https://www.youtube.com/watch?v=qrT4g0hZHns

Module 03: Making Data-Driven Decisions Using Looker

Websites

Looker documentation https://cloud.google.com/looker/docs
Looker Explores https://cloud.google.com/looker/docs/exploring-data
Dimensions and measures in Looker https://cloud.google.com/looker/docs/reference/param-explore-measure
Looker visualizations https://cloud.google.com/looker/docs/best-practices/visualizations
Looker dashboards https://cloud.google.com/looker/docs/building-dashboards
Looker Studio documentation https://support.google.com/looker-studio
Looker Studio overview https://cloud.google.com/looker-studio
Connecting Looker Studio to BigQuery https://support.google.com/looker-studio/answer/6370296
Sharing Looker reports https://cloud.google.com/looker/docs/sharing-looks
LookML overview https://cloud.google.com/looker/docs/what-is-lookml

Videos

Understanding Looker and Looker Studio https://www.youtube.com/watch?v=bUh5cGOSoaM
Looker Studio in a minute https://www.youtube.com/watch?v=ZBoFvaWr-Dk

Module 04: Course Summary

Websites

Google Cloud Data Analytics Learning Path https://cloud.google.com/learn/training/data-engineering-and-analytics
Google Cloud Certification - Professional Data Engineer https://cloud.google.com/learn/certification/data-engineer
Google Cloud Architecture Center https://cloud.google.com/architecture
Google Cloud blog - Data Analytics https://cloud.google.com/blog/products/data-analytics
BigQuery public datasets https://cloud.google.com/bigquery/public-data