In this workshop, we’ll first introduce BigQuery. You’ll then learn how to load and manage data on petabyte-scale, and get hands-on experience creating optimized queries with partitioning, clustering, and materialized views and writing complex queries. Then we dive into BigQuery ML.Models are trained and accessed in BigQuery using SQL — a language developers and data analysts know. This enables business decision making through predictive analytics across the organization without leaving the query editor.
The course is designed for developers, digital marketers, data analysts and engineers who are looking to answer complex business questions using large datasets and are familiar with SQL language.
What to expect:
Our workshop is relaxed and informal, covering a lot of ground in a fun and stimulating way. We will be working in Google Cloud Platform, and Qwiklabs datasets using an internet browser, and a simple text/code editor. It will help if you have experience with Google Analytics, APIs, interface, and some familiarity with SQL. There will be publicly available datasets available like Wikipedia, Reddit, Stackoverflow or Github for query exercises.
Topics covered
Introduction:
Use cases:
Coding and Beyond:
Efficient and optimization techniques:
BigQuery ML:
Hands-on examples with BigQuery ML:
Final and architecture:
Questions and Answers.
Márton is a Google Developer Expert(GDE) senior software architect at REEA.net . A romanian hero on StackOverflow with 175k reputation points. He led the implementation of complex and distributed systems serving millions of users for companies like FreeLogoServices, LogoMix, WaterSmart, Ausschreibungsdienste and many more.
Active contributor for open-source solutions like Beanstalkd console, and Riak admin interface. Expert in databases and systems like Google BigQuery, Elasticsearch, Redis.
Full speaker bio: https://kodokmarton.com/speaker/