Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 53 Minute(s)
Language
English
Taught by
Lukas Vozda
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
The best way to get you started with data science in Google BigQuery in 2021
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 Content
- 4 section(s)
- 25 lecture(s)
- Section 1 Introduction to Google BigQuery
- Section 2 SQL
- Section 3 BigQuery Machine Learning
- Section 4 Data Studio and advanced BigQuery features
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...)
Skills covered in this course
Reviews
-
AAndry Gautama
add some more example model especially on ML
-
VV V
Quick and easy course on BigQuery. It would be nice to have some extra exercises so that we can practice.
-
KKristyna Stadlerova
I have to say that this course is really easy to understand :-) I'm pleasantly surprised. I recommend it for non-programmers or people without any experience with BigQuery. Everyone can do it with Luke :-)
-
TTomáš Netík
Thanks to this course, I easily understood how Google Big Query works and how to use it. The course is definitely worthwhile and I recommend it to anyone who wants to learn more about Google Big Query.
