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
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.
GOAT 🐐Explanations and visuals ✨ Edit: Appreciate the use cases a lot especially the last one, i am an analyst and i usually get to access only via the views but you try to go slightly beyond the topic into its adjacencies like data warehouse which is a nice way for others to get familiarized with other terms and explore other opportunities in data if they find it interesting
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
I have never seen such a beautiful explanation for such a complex topics. This video should be on the top of its category. Hats off Baraa!!. Thank you so much for such a valuable contribution. I started the series, after completing SQL concepts, I will attend Power BI course and then I will go through Power BI dashboard projects. That's my new year resolution. 🙂
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
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.
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.
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.
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
You pronounced the word hindi correctly but here in india we speak multiple languages like tamil,telugu,Malayalam,kannada,urdu,bengali,marathi,hindi so on and on and on .. just fyi
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
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
Thanks!
Thanks !!
Before coming to this video I did not know the power and importance of the VIEWS. It is amazing
Thankyou, Baraa. Aadesh is correct in Hindi. Lots of love from India❤❤❤
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
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.
Wow, what a video! I've never seen an SQL video explained with such clarity. Thank you so much Baara for providing this. Love from India!❤
I am following your tutorials and which has given so much clarity. Your "Aadesh" was so correct. Keep going
GOAT 🐐Explanations and visuals ✨
Edit: Appreciate the use cases a lot especially the last one, i am an analyst and i usually get to access only via the views but you try to go slightly beyond the topic into its adjacencies like data warehouse which is a nice way for others to get familiarized with other terms and explore other opportunities in data if they find it interesting
Bro u r so kind in sharing ur information to us. Thanks as always.
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?
thanks baraa for providing this wonderful series
Excellent narration and information. Thanks you.
I have never seen such a beautiful explanation for such a complex topics. This video should be on the top of its category. Hats off Baraa!!.
Thank you so much for such a valuable contribution.
I started the series, after completing SQL concepts, I will attend Power BI course and then I will go through Power BI dashboard projects.
That's my new year resolution. 🙂
Thanks, Baraa for this tutorial on Views. It is clearer how to use it in real time.
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 :)
Another amazing lesson! I am always excited to study with your videos, thanks so much and keep up the hard work
Can't thank you enough. Another Great tutorial. Please make one for stored procedures, index etc.
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
Baraa, it is so easy to digest, bravo!
Thank you for providing such useful content, Baraa, lots of love from India. ❤❤
Thanks and I am today in India what amazing people
Thanks Baraa ☺
im addicted to this channel more than netflix
finally wait is over thanks baraaaa
amazing tutorial , i really like your presentation , which tool you used for images and writing notes
Thank You Very Much Sir
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.
Thanks Baraa!
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.
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.
Baraa Thank You 😍😊
Your video is very good thank you for your efforts.
So nice of you
Hello Baara, hope you are doing well. Once again thank you so much for this tutorial 😊
I have decided to comment on every one of your videos because those are real gems. I am glad that I found this treasure.
Wow, thank you!
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,huge fan of your videos sir, your videos helped me alot.can u make full tutorial on powerbi
Hello baraa thanks for the video, do you know when this course Will end? How many videos left?
THANK YOU BARAA!!! :D :D :D
The only valid comment is thank you very much
Your student 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 😂
Baraa, how's your coffee stays warm in every session 😀😀
Please Hadoop and spark❤.
can you tell me the software you use for presentation
@@akar_excel procreate :)
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
Sir please make videos on triggers
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
First Comment from India 😁
bara when is the new video cominngg?
You pronounced the word hindi correctly but here in india we speak multiple languages like tamil,telugu,Malayalam,kannada,urdu,bengali,marathi,hindi so on and on and on .. just fyi
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
i have my exams this week, so wont be able to "TIME TO SIT AND STUDY"
INSIDE 🙏🚀
haven't uploaded any video this week
Bro recursive next time