Google BigQuery guide for beginners 2021

About this course

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 BigQueryImport your data into BigQuery and Cloud storageSQL basics (WHERE, GROUP BY, JOIN TABLES, CASE WHEN)SQL Date and String functionsSQL BigQuery specific features (Nested fields, Partitioned tables, Clustering)SQL window analytical functionsBigQuery ML – create easily your machine learning models using SQLMaking a time series prediction using BigQuery MLVisualise data in Data Studio Export your data into Jupyter Notebook and Python using Google CollaboratoryThis 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.