BigQuery

🗣

Standing at the third place of the cloud provider market* and losing hundreds of millions every quarter* does not seem to bother Google that much as they keep burning money on Google Cloud Platform (GCP)*, which also makes them the fastest growing cloud provider on the market. As of today, 70% of the top 100 unicorns run on GCP*.

BigQuery, serverless OmniCloud data warehouse solution of GCP, has an undeniable advantage in terms of it’s native integrations with all the products under Google Marketing Platform (GMP) portfolio which eventually takes cloud backed marketing analytics processes to a new level if you are using one of them -we bet you do-.

BigQuery release notes | Google Cloud

This page documents production updates to BigQuery. We recommend that BigQuery developers periodically check this list for any new announcements. You can see the latest product updates for all of Google Cloud on the Google Cloud page, browse and filter all release notes in the Google Cloud console, or you can programmatically access release notes in BigQuery.

cloud.google.com

💬

This training will provide you a basic overview of GCP, a deep-dive on BigQuery along with it’s pricing model and native GMP integrations. You'll also gain hands-on experience by creating views and writing queries as well by loading and manipulating data.

⭐

Pre-Intermediate: Basic knowledge of SQL is required for hands-on practices.

Goals ⛳

🎯 What is the Google Cloud Platform (GCP)

🎯 BigQuery interface

🎯 How to write efficient queries in BigQuery

🎯 Ingesting data into BigQuery

🎯 Google Analytics 4 tables

🎯 Extracting data and parameters from streamed tables

🎯 Creating and maintaining permanent tables and views

🎯 Create reusable tables by managing datasets and tables

Content 📖

☁️ Introduction to Google Cloud Platform

🚩 What is BigQuery and how to use it?

🔧 Examination of BigQuery public dataset

✍️ Exploring data with SQL statements and tips

💾 Google Marketing Platform datasources

🪆 Analyzing nested fields

⏰ Scheduling queries

🎨 Visualization of BigQuery tables

🏆

After this course, you’ll gain a basic understanding of Google Cloud Platform and you will start writing fundamental queries on BigQuery for your daily tasks.