STANDARD vs. MATERIALIZED views in SQL | BigQuery

Lets see the the main difference Standard & Materialized view in SQL. Also we will see what are the main reason why we need views.
1. Defining Views
2. Standard Views
3. Materialized Views
4. When to use either type of views
+ Bonus - Recap on Saving Queries
Data Used
finance.yahoo.....
More Info on Views
www.datacamp.c...
Visit my blog for more content :
www.pivotalstats.com
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.i...
Cool tech used for these videos :
1. Blue Yeti Microphone - amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor - amzn.to/3EaHY8v
bigquery,creating permanent tables and access-controlled views in bigquery,bigquery tutorial,how to use bigquery,creating permanent tables and access-controlled views in bigquery 2022,creating permanent tables and access-controlled views in bigquery github,google bigquery tutorial,what is bigquery,authorized views in bigquery,how to create authorized views in bigquery,intro to bigquery,google bigquery,bigquery spotlight,bigquery and big data,sql in bigquery

[@jamieclarke2694]

Was hoping to learn a little aboht materialized views, its a shame most of the video was talking about normal views that have been around decades. Do you have any videos specifically on how materialized views work and perform? And how they change the execution plan?

[@pivotalstats]

Unfortunately this is my only video where I cover this topic, but I will definitely try to create a dedicated video on materialized views. Thanks for watching!

[@nidhisachdeva11]

Materialized views are not specific to big query as you claimed

[@pivotalstats]

Thanks for highlighting this mistake! I didn't realize that I said "specific" while recording this video.

[@Xiler6969]

Don't add background music

[@pivotalstats]

Thanks for the feedback 👍

[@connormc711]

I liked it maybe just 10% less volume?😊