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) -
https://www.youtube.com/watch?v=l5UcUEt1IzM&list=PLcnJIHtHiTA2Hdgon51_-G3Kt43hcU6kI

2) Google Cloud Platform Beginner Series (2020) -
https://www.youtube.com/watch?v=OzwSBbuHY-0&list=PLcnJIHtHiTA2Jp3klIkeHiwqGrxjXBzh6

3) Crunching Data Series (2020) - https://www.youtube.com/playlist?list=PLcnJIHtHiTA2HmIleev4scARSFwrQ0bIy

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 - https://cloud.google.com/docs
A Good article on unnesting - https://medium.com/firebase-developers/how-to-use-select-from-unnest-to-analyze-multiple-parameters-in-bigquery-for-analytics-5838f7a004c2
Google Cloud Platform Channel-https://www.youtube.com/user/googlecloudplatform

***Social Links***
Facebook - https://www.facebook.com/ITkFUNDE/
Linkedin - https://www.linkedin.com/in/ansh9685
Twitter - https://twitter.com/ansh9685
Blog - https://blogs.itkfunde.com/
Instagram -https://www.instagram.com/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!

Видео Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020) канала IT k Funde