Lesson#6 - BigQuery for beginners| Analyze data in google bigquery

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

Рет қаралды 81,594

4 жыл бұрын

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) -
• What is a Data Vault ?...
2) Google Cloud Platform Beginner Series (2020) -
• Google Cloud Platform ...
3) Crunching Data Series (2020) - • Learn - Data Engineeri...
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 -
Google Documentation - cloud.google.com/docs
A Good article on unnesting - / how-to-use-select-from...
Google Cloud Platform Channel- / googlecloudplatform
**Social Links**
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde.com/
Instagram - / itkfunde
**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!

Пікірлер: 68

@namandeepkaur8165 2 жыл бұрын

thanks for teaching in a simple way! amazing !!

@toast_on_toast1270 3 жыл бұрын

Excellent video, thank you!

@googlemani Жыл бұрын

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

@deepikasrinivasan1808 2 жыл бұрын

Thanks for the detailed explanation!

@timothy2600 Жыл бұрын

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

@Kaabstract 2 жыл бұрын

Man!! Great video!!

@timwebster85 Жыл бұрын

I learnt a ton from this thank you!

@VinodKumar-wc6bu Жыл бұрын

Great job

@luiscunha3759 8 ай бұрын

Very good video! Thanks a lot!

@rajithkumar3424 2 жыл бұрын

good one

@EstherAdeniyi-mr7pt Жыл бұрын

You were Excellent, thank you.

@shivaramakrishna3871 3 жыл бұрын

Excellent

@nilavasen8631 2 жыл бұрын

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.

@informationsatellite5155 9 ай бұрын

Amazing session .. thank you very much.

@CaribouDataScience 2 жыл бұрын

Thanks , this was helpful.

@arshqureshi5388 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Thanks Arshiya hope it helps every one

@yuvabhagvatkathakarshriyag9305 3 жыл бұрын

this is very helpful lab session on GBQ.

@ITkFunde 3 жыл бұрын

Thanks Yagnik

@zishanafzal6671 Жыл бұрын

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

@shahnawazkhan1636 3 жыл бұрын

Awesome

@ITkFunde 3 жыл бұрын

Thanks Shahnawaz ☺️

@pradeepkogala3646 2 жыл бұрын

Nice video . Please post more videos on GCP.

@deepak3475 2 жыл бұрын

Precisely explained for a layman

@ITkFunde 2 жыл бұрын

Thanks Deepak

@saptarshisarkar1002 3 жыл бұрын

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

@deepakjaiswal-tm4pj 3 жыл бұрын

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

@latestvideosnews 2 жыл бұрын

Nice

@proud_indian408 3 жыл бұрын

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 🙏

@ITkFunde 3 жыл бұрын

Hi Rawin thanks its a good idea I will pit it in my list

@EV_Techie 2 жыл бұрын

@@ITkFunde sir I have 2 database and want to compare 2 table and find unmatched records. Can you please reply how to do it.

@niftystrategy6933 3 жыл бұрын

very nice explanation

@ITkFunde 3 жыл бұрын

Thanks Rajiv

@johnho3542 2 жыл бұрын

Do you have more tutorials on big query :)

@digitaldiary9410 3 жыл бұрын

please sir upload more videos on gcp..

@moushmidas2584 3 жыл бұрын

Really helpful.❤️❤️..sir could please create some more video for data migration...like kafka server payload to cloud bucket...demo

@ITkFunde 3 жыл бұрын

Thanks Moushmi sure thanks for your support I have plans to do a data series in future

@sha2460 4 ай бұрын

@@ITkFunde i request you to please create more videos regarding data engineering perspective on GCP as well. also do include dataproc,dataflow, partition, bucketing etc, please

@simmyantony6575 2 жыл бұрын

Really helpful video.Can you please suggest a good comprehensive course on BigQuery ?

@ITkFunde 2 жыл бұрын

Coursera offers some comprehensive courses and also affliated with Google

@jitendrachouhan7024 2 жыл бұрын

How to train Recommandation Model from google analytics event.

@triumphmusic7495 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

You need to have a date field in your table if you simply want last one month data you can have a created_date column to be added for each record moreever you can partition your table month wise for cheaper reads.

@stephenfoster9009 2 жыл бұрын

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

@efcdatasupport6375 3 жыл бұрын

Sir How To Connect Mircosoft SQL Server Database / Table into Google Sheet through BigQuery?

@sandeepmore5290 2 жыл бұрын

Good..Can you give LIVE demo session...?..Reply..

@cricmania1413 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Its a good question but unfortunately i havent worked on Snowflake but I am planning to explore it in my own capacity and will share my novice learnings and comparison with Big Query

@shamsudindahir7655 3 жыл бұрын

How can I download this

@kawtikwarfamily5978 3 жыл бұрын

No further videos uploaded on gcp?

@ITkFunde 3 жыл бұрын

Sorry mate due to multiple request I am currently making vidoe series on networking but would soon switch to GCP. Thanks for your feedback 🙏

@rahulrasure4591 3 жыл бұрын

Hello , Is there any full tutorial on Google BigQuery ? If any can you please provide here the link. It would be very helpful to learn Google BQ.

@nabarunganguly5976 2 жыл бұрын

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

@gamyamentertainment4922 Жыл бұрын

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.

@ITkFunde Жыл бұрын

can you send me the eact error with error code ?

@gamyamentertainment4922 Жыл бұрын

@@ITkFunde yes..i will send you

@gamyamentertainment4922 Жыл бұрын

@@ITkFunde How can i send that image Bro?

@ITkFunde Жыл бұрын

send on anshultiwari353@gmail.com

@gamyamentertainment4922 Жыл бұрын

@@ITkFunde please check sir..I was sended issue in your email

@G7DHALIWAL 10 ай бұрын

At 1.58 .. I think its atlas not hercules.

@moulika123teja7 Жыл бұрын

Any contact for online class?

@kaladharmurakonda9233 2 жыл бұрын

Dear sir , If give me 17 chapter gcp certificate From you. After complete classes. Kaladhar muakonda

@maheshrai5940 2 жыл бұрын

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

@lheojfgzwhfyuodognjo9491 2 жыл бұрын

text

@AkashVerma-mg7ys 2 жыл бұрын

Poor explanation as some where you write whole query and didn’t explain and skip that part.

@jayalakshmij872 Жыл бұрын

Hello sir do you know how to reach sub collections in firestore to bigquery

@jzr6148 8 ай бұрын

This query will give the same result : SELECT tagst, count(*) as tag_count FROM `bigquery-public-data.stackoverflow.posts_questions`, UNNEST(split(tags,"|")) as tagst WHERE EXTRACT(YEAR FROM creation_date) >= 2008 GROUP BY tagst ORDER BY tag_count desc LIMIT 10