This course includes:
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:
4 sections - 25 lectures - 02:53:30 total length
People Also Search
Students Also Bought
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.