SQL Views Tutorial | 6 Top Use Cases for Views | #SQL Course #17

This video covers everything about SQL VIEWS and is a comprehensive SQL tutorial.

☕ Stay connected

📚 Free Courses

🎓Other Platforms (Certifications)

⏱️ Timestamp
00:00 Intro
00:39 Database Structure & DDL
06:10 3-Levels-Architecture
10:57 What are Views?
12:55 Views vs Tables
14:34 #1 Use Case: Central Logic
17:52 View vs CTE
19:37 Create/Update/Drop Views
31:52 How DB Execute Views
34:52 #2 Use Case: Hide Complexity
45:27 #3 Use Case: Data Security
52:05 #4 Use Case: Flexibility & Dynamic
54:18 #5 Use Case: Multiple Languages
56:22 #6 Use Case: Virtual Marts
59:45 View Summary

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**

[DataWithBaraa]

TIMESTAMPS

00:00 Intro
00:39 Database Structure & DDL
06:10 3-Levels-Architecture
10:57 What are Views?
12:55 Views vs Tables
14:34 #1 Use Case: Central Logic
17:52 View vs CTE
19:37 Create/Update/Drop Views
31:52 How DB Execute Views
34:52 #2 Use Case: Hide Complexity
45:27 #3 Use Case: Data Security
52:05 #4 Use Case: Flexibility & Dynamic
54:18 #5 Use Case: Multiple Languages
56:22 #6 Use Case: Virtual Marts
59:45 View Summary
Enjoy

[DivyYadav-hgjs]

people dont realize how valuable this channel is

[ska]

Thankyou, Baraa. Aadesh is correct in Hindi. Lots of love from India❤❤❤

[manjukb]

Never seen such a selfless teacher like you Baraa. Excellent class.
Please make a video on a complex stored procedure of some 100 to 150 lines of code or more.. Thank you very much

[AO_TSL]

The truth is this is one of the most comprehesive and complete sql series in youtube in those days, are simple and explain solid complex content with a good simplicity. Greetings Baraa 🎉

[DivyYadav-hgjs]

im addicted to this channel more than netflix

[DivyYadav-hgjs]

Bara in ur python project please dont forget to include libraries like pandas numpy and matplotlib they are really confusing and no one is providing a good explanation on that . Ur the only one who can teach complex topics in a simplified manner

[Toyahan]

Another amazing lesson! I am always excited to study with your videos, thanks so much and keep up the hard work

[oksanavorobiova]

Baraa, it is so easy to digest, bravo!

[Jp-yxod]

Can't thank you enough. Another Great tutorial. Please make one for stored procedures, index etc.

[donatusohiaeriaku]

Thanks, Baraa for this tutorial on Views. It is clearer how to use it in real time.

[micaelzekarias]

Bro u r so kind in sharing ur information to us. Thanks as always.

[piyushmahajan]

thanks baraa for providing this wonderful series

[Datacodelab]

Thank you for providing such useful content, Baraa, lots of love from India. ❤❤

[mrsobhanku]

After completing this video, I cleared most of my doubts about database structure and effective table usage for security and reducing the complexity and time-consuming effort of joining tables all the time. Thank you Baraa... Fun fact In India, आदेश for order used is different from the context, Here order is customer ordering a product and आदेश is like instruction given by army commander :)

[ahmedshalaby]

it's good news to this channel grow up from 10k to 30k in very small period
wishing you the best baraa always you are a great youtuber and have a great way to make hard things very simple

[MamadouCellouDiallo-uv]

The only valid comment is thank you very much

[donyelldf]

Hi Baraa, as usual another amazing video, I just love your style as an instructor, you are the best, thank you. Can you explain the difference between and view and materialized view. thanks again.

[RakshitDwivedi-pqqc]

Love the Video and the quality of your presentation. I took a 10 day leave from my work to focus on this series as well as will be starting your Tableau 20 hour course very soon. Just a request, while i love that you have provided a detailed summary of the database architecture with the Cache and Disk storage and everything. Can you also prepare a separate video on Database Normalization and include a recap of all the database architecture that you shared in this video as well as the Disk Storage vs Cache and the other things that you mentioned before the Subquery video.
You are doing a great work. God Bless.

[ManjeeriG]

Hello Baara, hope you are doing well. Once again thank you so much for this tutorial 😊