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) -
   • What is a Data Vault ? | 3NF vs Dimen...  

2) Google Cloud Platform Beginner Series (2020) -
   • Google Cloud Platform (GCP) - Beginne...  

3) Crunching Data Series (2020) -    • Learn - Data Engineering, Data Archit...  

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 -   / how-to-use-select-from-unnest-to-analyze-m...  
Google Cloud Platform Channel-   / googlecloudplatform  

**Social Links**
Facebook -   / itkfunde  
Linkedin -   / ansh9685  
Twitter -   / ansh9685  
Blog - https://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!