Google BigQuery guide for beginners 2021

Google BigQuery guide for beginners 2021, available at $49.99, has an average rating of 4.3, with 25 lectures, 4 quizzes, based on 34 reviews, and has 147 subscribers.

You will learn about Understand the concept of BigQuery and how does it stand next to other databases such as MySQL or Postgress Import your data to BigQuery and Cloud storage, create your table, export data SQL basics – SELECT, WHERE, ORDER BY, LIKE, JOIN, Date and String functions SQL aggregation functions – SUM, AVG, COUNT, HAVING and GROUP BY BigQuery ML to create your own machine learning model easily with SQL, make a time series prediction Visualise your data in Google Data Studio and make your own dashboard Advanced BigQuery concepts – Partitioning tables, Clustering and Nested Fields Window analytical functions – SUM() OVER (PARTITION BY…) This course is ideal for individuals who are Beginner data scientists or Geeks interested in Google Cloud or Web or marketing analysts that want to extend their data skills It is particularly useful for Beginner data scientists or Geeks interested in Google Cloud or Web or marketing analysts that want to extend their data skills.

Enroll now: Google BigQuery guide for beginners 2021

Summary

Title: Google BigQuery guide for beginners 2021

Price: $49.99

Average Rating: 4.3

Number of Lectures: 25

Number of Quizzes: 4

Number of Published Lectures: 25

Number of Published Quizzes: 4

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Understand the concept of BigQuery and how does it stand next to other databases such as MySQL or Postgress
Import your data to BigQuery and Cloud storage, create your table, export data
SQL basics – SELECT, WHERE, ORDER BY, LIKE, JOIN, Date and String functions
SQL aggregation functions – SUM, AVG, COUNT, HAVING and GROUP BY
BigQuery ML to create your own machine learning model easily with SQL, make a time series prediction
Visualise your data in Google Data Studio and make your own dashboard
Advanced BigQuery concepts – Partitioning tables, Clustering and Nested Fields
Window analytical functions – SUM() OVER (PARTITION BY…)

Who Should Attend

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

Target Audiences

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

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.

The best way how to get started with Google BigQuery in 2021. All the concepts and features I am showing in the UI are completely up to date. I will be happy to answer any questions.

Course Curriculum

Chapter 1: Introduction to Google BigQuery

Lecture 1: Welcome – Introduction video

Lecture 2: Content of this class

Lecture 3: What is BigQuery compared to other databases

Lecture 4: Create your Google Cloud account and get 300$ credit voucher

Lecture 5: Tour through BigQuery and Google Cloud interface

Lecture 6: BigQuery Public Datasets

Lecture 7: Import your data to BigQuery

Lecture 8: Export your data and Data Studio Explorer

Lecture 9: BigQuery pricing explained

Lecture 10: Data transfers from Cloud Storage

Chapter 2: SQL

Lecture 1: The best way to learn SQL

Lecture 2: SQL basics (SELECT, WHERE, ORDER BY)

Lecture 3: SQL – Aggregating functions (SUM, AVG, COUNT), GROUP BY, HAVING, LIKE

Lecture 4: SQL – Joining tables

Lecture 5: SQL – DATE Functions

Lecture 6: SQL – String formating, cleaning, CASE WHEN

Lecture 7: SQL – Window Functions (PARTITION OVER)

Chapter 3: BigQuery Machine Learning

Lecture 1: Introduction to BigQuery ML

Lecture 2: Time series prediction using BigQuery ML

Lecture 3: Multiple time series prediction

Lecture 4: ML daily prediction refresh – Scheduled Queries

Chapter 4: Data Studio and advanced BigQuery features

Lecture 1: Display your data with Google Data Studio

Lecture 2: Clustering and Partitioning tables

Lecture 3: Nested fields

Lecture 4: Connect your BigQuery data to Python data frame in Google Colab

Instructors

Lukas Vozda
Head of Analytics, Proficio

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 6 votes
4 stars: 10 votes
5 stars: 17 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu