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
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
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 🎉
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 :)
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
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.
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.
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.
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
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
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 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
Before coming to this video I did not know the power and importance of the VIEWS. It is amazing
Excellent narration and information. Thanks you.
Thankyou, Baraa. Aadesh is correct in Hindi. Lots of love from India❤❤❤
Thanks!
Thanks !!
Another amazing lesson! I am always excited to study with your videos, thanks so much and keep up the hard work
Thank You Very Much Sir
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
Thanks Baraa ☺
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 🎉
I am following your tutorials and which has given so much clarity. Your "Aadesh" was so correct. Keep going
im addicted to this channel more than netflix
Baraa, it is so easy to digest, bravo!
thanks baraa for providing this wonderful series
Can't thank you enough. Another Great tutorial. Please make one for stored procedures, index etc.
Baraa Thank You 😍😊
finally wait is over thanks baraaaa
Bro u r so kind in sharing ur information to us. Thanks as always.
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
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 :)
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
The only valid comment is thank you very much
Thanks Baraa!
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.
Your video is very good thank you for your efforts.
So nice of you
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.
Hello Baara, hope you are doing well. Once again thank you so much for this tutorial 😊
THANK YOU BARAA!!! :D :D :D
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.
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.
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?
hi,huge fan of your videos sir, your videos helped me alot.can u make full tutorial on powerbi
Please Hadoop and spark❤.
First Comment from India 😁
THE SQL SERIES IS DONE AND DUSTED AND I LOVED EVERY MINUTE OF IT.
BARAA NO WHAT ABOUT A PYTHON SERIES🙂?
After SQL 😂
Hello baraa thanks for the video, do you know when this course Will end? How many videos left?
Baraa, how's your coffee stays warm in every session 😀😀
bara when is the new video cominngg?
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
Sir please make videos on triggers
can you tell me the software you use for presentation
@@akar_excel procreate :)
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
INSIDE 🙏🚀
i have my exams this week, so wont be able to "TIME TO SIT AND STUDY"
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
haven't uploaded any video this week
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
Bro recursive next time