f you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE 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
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 🎉
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
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
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 :)
When you say Analysis the way to say it. It makes me feel as if you are saying a naughty word :D Other than that you are doing a phenomenal job keep going bro.
Hey bara, thank you so much!! Was waiting for your content!! It would be very grateful of you if you cover topics like stored procedure and trigger and indexes. These kind of advance topics also You explain everything so smoothly and nicely.
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
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.
@@DataWithBaraa yes I will be joining back on Monday and I am already starting your Tableau course tomorrow. Hoping to get major chunk of it finished by the weekend. You are the best content creator in field of Data Analytics.
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.
If you're brave enough to learn Hindi, then your first mission, should you choose to accept it, is to pass this ultimate test: 🎶 Tunak tunak tun, tunak tunak tun, tunak tunak tun, da da da! 🎶 Good luck
hi, first of all i would like to express my gratitude for such good level content. I don't even an learn a lot of things during my college times compare to now i learnt everything from video. Could you please in order to create dashboard i need dataset and for that i tried to create dummy dataset using chatgpt but most of the time i stuck like they give me wrong calculated fields. so could you please suggest
Hi Barra. If possible could you please post some complex data project using SQL from end to end, like you have posted for Tabluea. Please please kindly consider this. No 1 like you can explain and teach. Please
@@DataWithBaraa Sir, Iam following from tableau course Your videos are very easy to understand and your teaching, content is so great could you please prepare a powerbi complete course like tableau for us ?
@@DataWithBaraa go with python bara u already have completed visualization too like tableau and ur the only one i think who can simplify python and which can increase the demand of this channel
f you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
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
people dont realize how valuable this channel is
Thankyou, Baraa. Aadesh is correct in Hindi. Lots of love from India❤❤❤
Before coming to this video I did not know the power and importance of the VIEWS. It is amazing
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 🎉
Another amazing lesson! I am always excited to study with your videos, thanks so much and keep up the hard work
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
Thank You Very Much Sir
I am following your tutorials and which has given so much clarity. Your "Aadesh" was so correct. Keep going
Thanks!
Thanks !!
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
im addicted to this channel more than netflix
Excellent narration and information. Thanks you.
Baraa, it is so easy to digest, bravo!
Thanks Baraa ☺
thanks baraa for providing this wonderful series
finally wait is over thanks baraaaa
Can't thank you enough. Another Great tutorial. Please make one for stored procedures, index etc.
Bro u r so kind in sharing ur information to us. Thanks as always.
Baraa Thank You 😍😊
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 :)
Thanks, Baraa for this tutorial on Views. It is clearer how to use it in real time.
Thank you for providing such useful content, Baraa, lots of love from India. ❤❤
Thanks and I am today in India what amazing people
When you say Analysis the way to say it. It makes me feel as if you are saying a naughty word :D Other than that you are doing a phenomenal job keep going bro.
Thanks Baraa!
Hello Baara, hope you are doing well. Once again thank you so much for this tutorial 😊
Hey bara, thank you so much!! Was waiting for your content!!
It would be very grateful of you if you cover topics like stored procedure and trigger and indexes.
These kind of advance topics also
You explain everything so smoothly and nicely.
The only valid comment is thank you very much
First Comment from India 😁
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
Is Baraa going to teach Python as well?
THANK YOU BARAA!!! :D :D :D
Your video is very good thank you for your efforts.
So nice of you
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.
Wow 10 days in a row, amazing 🤩 ! Yes sure I will do my best to include them in my next videos, I hope you will enjoy it 👍
@@DataWithBaraa yes I will be joining back on Monday and I am already starting your Tableau course tomorrow. Hoping to get major chunk of it finished by the weekend. You are the best content creator in field of Data Analytics.
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.
THE SQL SERIES IS DONE AND DUSTED AND I LOVED EVERY MINUTE OF IT.
BARAA NO WHAT ABOUT A PYTHON SERIES🙂?
After SQL 😂
Baraa, how's your coffee stays warm in every session 😀😀
hi,huge fan of your videos sir, your videos helped me alot.can u make full tutorial on powerbi
Please Hadoop and spark❤.
If you're brave enough to learn Hindi, then your first mission, should you choose to accept it, is to pass this ultimate test:
🎶 Tunak tunak tun, tunak tunak tun, tunak tunak tun, da da da! 🎶
Good luck
can you tell me the software you use for presentation
@@akar_excel procreate :)
bara when is the new video cominngg?
INSIDE 🙏🚀
Hello baraa thanks for the video, do you know when this course Will end? How many videos left?
Sir please make videos on triggers
hi, first of all i would like to express my gratitude for such good level content. I don't even an learn a lot of things during my college times compare to now i learnt everything from video. Could you please in order to create dashboard i need dataset and for that i tried to create dummy dataset using chatgpt but most of the time i stuck like they give me wrong calculated fields. so could you please suggest
Hi Barra. If possible could you please post some complex data project using SQL from end to end, like you have posted for Tabluea.
Please please kindly consider this. No 1 like you can explain and teach. Please
I will do as last chapter of this series
i have my exams this week, so wont be able to "TIME TO SIT AND STUDY"
Hello baraa after finishing this series whats ur next big plan ?
I am not sure yet, I have to decide between python and powerbi
@@DataWithBaraa Sir, Iam following from tableau course Your videos are very easy to understand and your teaching, content is so great could you please prepare a powerbi complete course like tableau for us ?
@@DataWithBaraa Power BI please
@@DataWithBaraa go with python bara u already have completed visualization too like tableau and ur the only one i think who can simplify python and which can increase the demand of this channel
@@DataWithBaraa please, powerbi
haven't uploaded any video this week
Bro recursive next time