Google BigQuery Tutorial for beginners | Load Dataset and Run SQL queries for Data Analysis

In this video we will teach you how to use Google BigQuery and run SQL queries on dataset. We will also shows ways to load dataset into BigQuery.

Course Timeline:
00:13 Setup Google Cloud Platform Account
03:00 Introduction to BigQuery Console and setup
05:11 Creating your first Google Cloud Project
07:15 Loading Dataset from local machine into Google BigQuery
10:58 Run SQL Queries on Dispatch Dataset
- Group BY
- Numerical Functions
- Joins
32:29 Loading Dataset from Google Storage Bucket
40:07 Run SQL Queries on Sales Dataset

[LightOurDirection]

SQL was so intimidating when I first saw it . Thank you for this video, not difficult at all !!!

[mr.tech_fun]

Very informative and hands on Tutorial.... Keep creating such contents

[jenniferrebbecaosornio]

muchisimas gracias por compartirlo, me ayudo a solucionar los problemas que tengo para poder contestar los examenes que estoy presentando usando BIG QUERY.

[TaimoorRauf]

thank you so much for this helpful content, i was really stuck in basics of Bigquery settings❤❤

[folashadeolaitan]

Thank you for this tutorial. Please can you provide a link for the datasets download. Also when is it important to use a bucket instead of uploading files directly?

[anithaa]

The session helped me perfectly to clear my doubts.
Thank you :)

[ojieokogua]

Thanks for the video. In the result table when you used left JOIN to join both table, is the total number of rows = total rows in sales + total rows in Dispatch tables?

[abebewasihunabro]

Thanks for the video. can I get the link for the data to exercise following you ?

[hzzjreq]

People have requested to share the dataset, hence, why don't you share them?

[maxm]

Hi! I go to ADD DATA / EXPLORE PUBLIC DATASETS / VIEW DATASET / * AND HERE NOTHING HAPPENS (I DONT HAVE ANY PINNED PROJECTS ON MY LEFT TOP SIDE)

[hamzarahman]

how to disable automatic billing ? please help

[vaibhavsharma]

Hey can u provide me the link to dispatch datset CSV file ??