Google BigQuery guide for beginners 2021

Name: Google BigQuery guide for beginners 2021
Rating: 4.3 (34 reviews)

The best way to get you started with data science in Google BigQuery in 2021

Created byLukas Vozda

Last updated 3/2021

English

What you'll 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...)

Course content

4 sections • 25 lectures • 2h 53m total length

Welcome – Introduction video1:05
Welcome to my class. I will take you briefly through what you will learn in my class.
- SQL basics (GROUP BY, WHERE, JOIN, HAVING)
- Create ML models and predictions in SQL and BigQuery ML
- Visualise data in Google Data Studio
- Create Partitioned tables, Clusters, Nested fields...
Content of this class2:13
Check out what you will learn at this class!
What is BigQuery compared to other databases3:16
Where is the place for BigQuery compared to classical relational databases such as MySQL or Postgress.
Create your Google Cloud account and get 300$ credit voucher3:00
In this video, I am showing how you can open your new account and get 300$ credit for free. I also describe a free tier of BigQuery.
Tour through BigQuery and Google Cloud interface8:39
BigQuery Public Datasets1:46
How to open BigQuery public datasets that we'll be working with to practice SQL skills.
Import your data to BigQuery4:52
Step by step how you can import data from your local computer to BigQuery
Export your data and Data Studio Explorer3:38
How can you export your data out of BigQuery and how can you use Data Studio explorer to visualise your data quickly.
BigQuery pricing explained4:14
How much will BigQuery cost you when you run out of your free 300$ account?
Data transfers from Cloud Storage7:22
Use data transfers to automatically transfer data from other services (Amazon, Google Ads, Youtube...) to BigQuery. You can also use Cloud Storage to store your raw data and use a transfer to import them to the BigQuery table.
Section 1 Quiz

The best way to learn SQL2:23
What is the best way (from my experience) for you to learn SQL.
SQL basics (SELECT, WHERE, ORDER BY)7:19
What is SQL? How can you query simple data. Practicing filtering by WHERE clause and ORDER BY.
SQL - Aggregating functions (SUM, AVG, COUNT), GROUP BY, HAVING, LIKE6:48
SQL - Joining tables14:23
In this lesson I show how you can join another table, join sub table under another select and combine it with SUM, GROUP BY, WHERE learned from previous lesson.
SQL - DATE Functions5:49
Learn how to format and work with Dates in BigQuery.
SQL – String formating, cleaning, CASE WHEN5:49
SQL - Window Functions (PARTITION OVER)10:41
Learn the concept of window analytical functions in BigQuery.
SQL quick test

Introduction to BigQuery ML3:09
Introduction to BigQuery ML, create machine learning model simply using SQL.
Time series prediction using BigQuery ML15:38
Learn how to make a future prediction on a time series data with BigQuery ML.
Multiple time series prediction10:55
Learn how to create a multidimensional time series prediction model.
ML daily prediction refresh – Scheduled Queries5:40
Schedule BigQuery ML query to run daily to keep your prediction fresh every day.
ML excercise

Display your data with Google Data Studio21:20
20 minutes video to show you how you can use BigQuery together with Data Studio to visualise your data for free.
Clustering and Partitioning tables8:02
Learn how to create partitions and clusters in BigQuery to improve the performance of your queries and lower costs.
Nested fields8:26
Nested fields are another cool feature of BigQuery, that lets you create arrays and structure your data in SQL tables.
Connect your BigQuery data to Python data frame in Google Colab7:03
A simple way how you can get you started working with BigQuery data in Python. Using Google Colaboratory hosted Jupyter Notebooks.
Last Quiz

Requirements

Interest in data or cloud technologies
No specific technical knowledge needed

Description

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.

Who this course is for:

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

Google BigQuery guide for beginners 2021

What you'll learn

Explore related topics

Course content

Introduction to Google BigQuery10 lectures • 40min

SQL7 lectures • 53min

BigQuery Machine Learning4 lectures • 35min

Data Studio and advanced BigQuery features4 lectures • 45min

Requirements

Description

Who this course is for: