Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020)

Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020)
#bigquery #googlecloud #bigquerytutorial #gcp #googlebigquery #bigquerypricing

**Link to Complete playlist**
1) Latest technology tutorial (2020) -

2) Google Cloud Platform Beginner Series (2020) -

Hi Friends, I am Anshul Tiwari and welcome to our youtube channel ITkFunde.

About this video -
In this 6th video tutorial under the google cloud platform beginner series (2020), we will learn to work with google big query from scratch. In this 25 minute tutorial we will cover the following :-

1) WHAT IS BIG QUERY ?
2) BIG QUERY FEATURES
3) BIG QUERY PRICING
4) BIG QUERY DEMO (ACCESS StackOverflow BIG DATA)
5) HOW BIG QUERY SPECIAL DATATYPES (ARRAY) ?

We will understand why bigquery is the USP of google cloud platform. What makes it so fast, efficient, and cost-effective. We will also learn biqquery pricing model and how it is so cheap to crunch your data on big query.

We will then take a hand on exercise to explore StackOverflow public dataset provided by google big query and try to solve a query using SQL. We will understand how big query supports array data types and provides functions like UNNEST () to convert your array data types into strings.

Credits & Resources -

***Social Links***

***About This Channel***
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

[arshqureshi]

Sir ppl still don't know much about cloud once tis subject gets into the curriculum ur going to be top on youtube channel for gcp

[proud_indian]

I'd say far better explanation than any other GBQ tutorial, really nice sir, is it possible to make the same concept using IaaS like terraform in gcp, please 🙏

[AnshulMarele-gbaa]

Hi, you always post very very informative videos. One Que. I have an Excel365 file which has data from the odbc connection, which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates?

[informationsatellite]

Amazing session .. thank you very much.

[stephenfoster]

Sampson was the strongest man on Earth. Hercules is a myth. Thx.

[googlemani]

Very neatly explained the BigQuery concept along with a good demo. Thank you, its very helpful.

[yuvabhagvatkathakarshriyag]

this is very helpful lab session on GBQ.

[namandeepkaur]

thanks for teaching in a simple way! amazing !!

[nilavasen]

hello, I have a question. Do one need to learn Big Data as pre requisite to learn GCP Data Enginner services, like BigQuery, BigTable etc. ? Plz suggest.. TY.

[timothy]

Your tutorials and explanations are clear to understand and concise, make more on ML pipelines in GCP

[GDHALIWAL]

At 1.58 .. I think its atlas not hercules.

[zishanafzal]

Sir, Is the query similar to what we mysql query becoz here we also use sql but unnest function is not there?

[saptarshisarkar]

Are you continuing this series? Only 9 vdo I can see. Outstanding vdo by the way Sir.

[triumphmusic]

Big query saves data date wise how can i retrieve one month data in big query, will i have to join all tables first

[gamyamentertainment]

Hi Brother, In the google cloud platform cloud shell editor, I was written one code, but I was facing a Chrome driver issue. I was written python code in my local IDE(visual studio code ) code is working and the file I was pushing into the google cloud bucket. the same script I was running into google could shell editor, asking for chrome driver executable, needs to be a path like that error I was facing. Did you know how to overcome this error ? please tell me if you have any solution.

[deepakjaiswal-tmpj]

Please create full course if possible, waiting from bottom of my hart .... :-)

[cricmania]

Sir thanks for this video. Which one is better Snowflake or Big query please explain

[nabarunganguly]

I would like to learn bigquery. Will you please teach me. I need to learn this immediately.

[pradeepkogala]

Nice video . Please post more videos on GCP.

[maheshrai]

Vedio content is not clear. Subject and explaination is good but presentation is not visible