Difference Between SQL Views vs Materialized Views | Frequently Asked SQL Interview Question

In this video we will understand SQL views and difference Between SQL Views vs Materialized Views. This is a very frequently asked SQL interview question. This is the only video you need to answer this question in your next SQL interview.

script:
CREATE TABLE orders (
order_id INT,
order_date DATE,
product_name VARCHAR(20),
sales INT
);

INSERT INTO orders (order_id, order_date, product_name, sales) VALUES
(1, '2023-01-15', 'Laptop', 1200),
(2, '2023-01-17', 'Smartphone', 800),
(3, '2023-01-20', 'Tablet', 600),
(4, '2023-02-05', 'Smartwatch', 300),
(5, '2023-02-08', 'Headphones', 150),
(6, '2023-02-10', 'Monitor', 200),
(7, '2023-02-15', 'Keyboard', 80),
(8, '2023-02-20', 'Mouse', 50),
(9, '2023-03-01', 'Printer', 220),
(10, '2023-03-05', 'Camera', 500);

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer

[Datapassenger_prashant]

Thank you so much Ankit sir for this wonderful video and clearing the concept of views in SQL..
I'm pretty much sure I'll not forget it now..

[subhajitdey]

man dope data contents are coming, need more of this,

[aneelanarayanam]

Explanation is So clear sir! But I have a doubt. Suppose, I have created a view on a complex query and I forgot to note down the query. Where Can I refer the query?

[rohansingh]

Hello please also make the playlist on case study using SQL It will help everyone and me too
It will be great if u explain this 😊

[anandmahajan]

Thanks Ankit for the video. Waiting for the Redshift tutorial.

[sivabonu]

Really awesome explanation.. Thanks alot sir

[rajathratnakaran]

Great explanation as always. I have a doubt on how is views different from stored procedure?

[Leo-qohk]

Hello Sir great explanation please also make a videso on stored procedures and index as well

[ramakumarguntamadugu]

Good explanation.. keep posting such many interesting videos 👍

[harshitsalecha]

Excellent explanation Ankit. Thanks a lot for providing such amazing knowledgeable videos.

[GSrinivasulu-sd]

I got full clarity b/w Normal views and Materialized views just in one 13 min video

[theraizadatalks]

This is one of the common interview question.

[srinivasanselvam]

Thank you so much 🙏 ankit😊 You explained very clearly

[rahulkushwaha]

Great as always, can you also make something similar on Partitions. Thank you bhaiya.

[varunas]

Great demo as always.

Could you please make another video explaining the backend things of how altering a view (performing update to views) changes the contents of the base table as well

TIA!

[mahesh]

Bro, can you please make some videos on SQL stored procedure. I couldn't find tutorials anywhere. If you explain it, we can easily learn it. I am fond of your teaching.

[venkkatmerla]

Hi Ankit
Vedio is good but I have some doubts in it.
As a storage point it is clear.
Data freshness also clear.
Performance point i have some doubt it mean view and materialised will you the same plan hash value or it is different for view since it is taking data from base team, there might be a chance that base table search path might change, can you please help me with your input on this

[muruganselva]

Hi Ankit, Are you doing videos for Snowflake

[mohammedvahid]

Wht is difference between snowflake materialized views and SQL materialized views bro can u explain please

[Pyari_Guddiya]

What would be the difference between Views and CTE then ?