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
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
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 :)
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
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.
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
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
@@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
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
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
Before coming to this video I did not know the power and importance of the VIEWS. It is amazing
Thanks!
Thanks !!
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 🎉
this channel is like Netflix for coders, everything is so clean and all videos are well planned, like some professional documentary
Thanks for nice words glad it is not boring 👍
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!❤
Thankyou, Baraa. Aadesh is correct in Hindi. Lots of love from India❤❤❤
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
I am following your tutorials and which has given so much clarity. Your "Aadesh" was so correct. Keep going
Baraa, it is so easy to digest, bravo!
thanks baraa for providing this wonderful series
Excellent narration and information. Thanks you.
Bro u r so kind in sharing ur information to us. Thanks as always.
finally wait is over thanks baraaaa
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
Another amazing lesson! I am always excited to study with your videos, thanks so much and keep up the hard work
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.
Thanks, Baraa for this tutorial on Views. It is clearer how to use it in real time.
Thank you for providing such valuable content! The explanations, animation, and presentation are excellent. Sending lots of love from India ❤❤❤
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
Can't thank you enough. Another Great tutorial. Please make one for stored procedures, index etc.
Thanks Baraa ☺
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. 🙂
Thank You Very Much Sir
Thank you for providing such useful content, Baraa, lots of love from India. ❤❤
Thanks and I am today in India what amazing people
Baraa Thank You 😍😊
Thanks Baraa!
im addicted to this channel more than netflix
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 :)
amazing tutorial , i really like your presentation , which tool you used for images and writing notes
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
Is Baraa going to teach Python as well?
Your video is very good thank you for your efforts.
So nice of you
NICE HINDI BRO, I AM FROM INDIA ,ALWAYS LIKE YOUR VIDEO :)
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.
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
Hello Baara, hope you are doing well. Once again thank you so much for this tutorial 😊
THANK YOU BARAA!!! :D :D :D
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.
Hello baraa thanks for the video, do you know when this course Will end? How many videos left?
The only valid comment is thank you very much
Please Hadoop and spark❤.
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,huge fan of your videos sir, your videos helped me alot.can u make full tutorial on powerbi
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
can you tell me the software you use for presentation
@@akar_excel procreate :)
bara when is the new video cominngg?
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 😀😀
Sir please make videos on triggers
First Comment from India 😁
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
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
INSIDE 🙏🚀
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
Bro recursive next time