Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020)
HTML-код
- Опубликовано: 6 окт 2024
- 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.c...
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...
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!
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
Thanks Arshiya hope it helps every one
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 🙏
Hi Rawin thanks its a good idea I will pit it in my list
@@ITkFunde sir I have 2 database and want to compare 2 table and find unmatched records. Can you please reply how to do it.
Very neatly explained the BigQuery concept along with a good demo. Thank you, its very helpful.
Your tutorials and explanations are clear to understand and concise, make more on ML pipelines in GCP
Amazing session .. thank you very much.
this is very helpful lab session on GBQ.
Thanks Yagnik
You were Excellent, thank you.
Very good video! Thanks a lot!
I learnt a ton from this thank you!
Precisely explained for a layman
Thanks Deepak
Man!! Great video!!
Sampson was the strongest man on Earth. Hercules is a myth. Thx.
Thanks , this was helpful.
Are you continuing this series? Only 9 vdo I can see. Outstanding vdo by the way Sir.
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?
thanks for teaching in a simple way! amazing !!
Nice video . Please post more videos on GCP.
Thanks for the detailed explanation!
Sir thanks for this video. Which one is better Snowflake or Big query please explain
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
Great job
very nice explanation
Thanks Rajiv
good one
Good..Can you give LIVE demo session...?..Reply..
Please create full course if possible, waiting from bottom of my hart .... :-)
At 1.58 .. I think its atlas not hercules.
Really helpful video.Can you please suggest a good comprehensive course on BigQuery ?
Coursera offers some comprehensive courses and also affliated with Google
Thanks
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.
Nice
I would like to learn bigquery. Will you please teach me. I need to learn this immediately.
Excellent
Awesome
Thanks Shahnawaz ☺️
No further videos uploaded on gcp?
Sorry mate due to multiple request I am currently making vidoe series on networking but would soon switch to GCP. Thanks for your feedback 🙏
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.
Really helpful.❤️❤️..sir could please create some more video for data migration...like kafka server payload to cloud bucket...demo
Thanks Moushmi sure thanks for your support I have plans to do a data series in future
@@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
Sir, Is the query similar to what we mysql query becoz here we also use sql but unnest function is not there?
Big query saves data date wise how can i retrieve one month data in big query, will i have to join all tables first
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.
Do you have more tutorials on big query :)
How to train Recommandation Model from google analytics event.
please sir upload more videos on gcp..
Sir How To Connect Mircosoft SQL Server Database / Table into Google Sheet through BigQuery?
Vedio content is not clear. Subject and explaination is good but presentation is not visible
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.
can you send me the eact error with error code ?
@@ITkFunde yes..i will send you
@@ITkFunde How can i send that image Bro?
send on anshultiwari353@gmail.com
@@ITkFunde please check sir..I was sended issue in your email
How can I download this
Any contact for online class?
Dear sir ,
If give me 17 chapter gcp certificate
From you. After complete classes.
Kaladhar muakonda
Poor explanation as some where you write whole query and didn’t explain and skip that part.
text
Hello sir do you know how to reach sub collections in firestore to bigquery
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
Excellent video, thank you!