Go Class

This course includes:

  • 3 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV

Google BigQuery guide for beginners

Lukas Vozda via Udemy

(6 Reviews)

Overview

I designed this class for people that are starting with Google Cloud Platform and BigQuery. I put 5 years of my knowledge into 3 hours of video content where I try to explain all the important concepts of BigQuery.

We will take it through:

  • Understanding the concept of BigQuery

  • Import your data into BigQuery and Cloud storage

  • SQL basics (WHERE, GROUP BY, JOIN TABLES, CASE WHEN)

  • SQL Date and String functions

  • SQL BigQuery specific features (Nested fields, Partitioned tables, Clustering)

  • SQL window analytical functions

  • BigQuery ML – create easily your machine learning models using SQL

  • Making a time series prediction using BigQuery ML

  • Visualise data in Data Studio 

  • Export your data into Jupyter Notebook and Python using Google Collaboratory

This course is not supposed to master your SQL skills. Instead, I will take you through SQL basics and uncover to you the potential of BigQuery. In this class, I will take care that you know what BigQuery is, how you can get in and out your data, what are the most interesting features of BigQuery (BigQuery machine learning, Partitioning, Clustering, Nested fields...) and how you can use the advantage of them.





Who this course is for:

  • Beginner data scientists
  • Geeks interested in Google Cloud
  • Web or marketing analysts that want to extend their data skills

Course Content

4 sections - 25 lectures - 02:53:30 total length

People Also Search

Students Also Bought

Python OOP Crash Course

Python OOP Crash Course

Learn to easily integrate all key OOP concepts such as classes, objects, polymorphism, inheritance into your Python code

CSS Responsive Web Design

CSS Responsive Web Design

Learn Responsive Design from beginner to advanced level with both theoretical and practical explanations

Data Science: Bitcoin Data Visualization & Price Prediction

Data Science: Bitcoin Data Visualization & Price Prediction

Data Science: Hands-on & Practical Cryptocurrency Data Visualization & Bitcoin Price Forecasting using Machine Learning

Design Patterns com Java - Entendendo Padrões de Projetos

Design Patterns com Java - Entendendo Padrões de Projetos

Aprenda os Padrões de Projetos GoF e Princípios de Programação SOLID em explicações práticas com exemplos reais em Java

Spring для начинающих

Spring для начинающих

Изучение Spring на простых примерах для начинающих

Instructor

Lukas Vozda

  • 5 Instructor Rating
  • 6 Reviews
  • 19 Students

I have been working for 5 years as a teamleader of data team at Proficio company.

During that time, I've had an opportunity to work on several ecommerce projects and crystalised my analytical knowledge.

Using Google Cloud and BigQuery became my daily passion so I decided to share it with others here on Udemy.