SQL Views Tutorial | 6 Top Use Cases for Views |

Поділитися
Вставка
  • Опубліковано 16 січ 2025

КОМЕНТАРІ • 77

  • @DataWithBaraa
    @DataWithBaraa  3 місяці тому +3

    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

  • @DivyYadav-hg2js
    @DivyYadav-hg2js 2 місяці тому +10

    people dont realize how valuable this channel is

  • @SAhmBal89
    @SAhmBal89 Місяць тому +3

    Before coming to this video I did not know the power and importance of the VIEWS. It is amazing

  • @barbmarques2022
    @barbmarques2022 2 місяці тому +3

    Thanks!

  • @A4O_TSL
    @A4O_TSL 3 місяці тому +2

    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 🎉

  • @shahbazfareedchishti
    @shahbazfareedchishti День тому +1

    this channel is like Netflix for coders, everything is so clean and all videos are well planned, like some professional documentary

    • @DataWithBaraa
      @DataWithBaraa  День тому

      Thanks for nice words glad it is not boring 👍

  • @varshapriyadarshini9822
    @varshapriyadarshini9822 Місяць тому +1

    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!❤

  • @ska5691
    @ska5691 2 місяці тому +4

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

  • @manjukb8696
    @manjukb8696 3 місяці тому +1

    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

  • @iparpankaj
    @iparpankaj 2 місяці тому +2

    I am following your tutorials and which has given so much clarity. Your "Aadesh" was so correct. Keep going

  • @oksanavorobiova8929
    @oksanavorobiova8929 3 місяці тому +1

    Baraa, it is so easy to digest, bravo!

  • @piyushmahajan4422
    @piyushmahajan4422 3 місяці тому +2

    thanks baraa for providing this wonderful series

  • @deepam.g4558
    @deepam.g4558 Місяць тому +1

    Excellent narration and information. Thanks you.

  • @micaelzekarias1537
    @micaelzekarias1537 3 місяці тому +2

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

  • @nitinrawat-g6t
    @nitinrawat-g6t 3 місяці тому +1

    finally wait is over thanks baraaaa

  • @ahmedshalaby9343
    @ahmedshalaby9343 3 місяці тому +1

    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

  • @Toyahan43
    @Toyahan43 3 місяці тому +1

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

  • @RakshitDwivedi-pq8qc
    @RakshitDwivedi-pq8qc 3 місяці тому +2

    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
      @DataWithBaraa  3 місяці тому

      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 👍

    • @RakshitDwivedi-pq8qc
      @RakshitDwivedi-pq8qc 3 місяці тому

      @@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.

  • @donatusohiaeriaku9343
    @donatusohiaeriaku9343 3 місяці тому +1

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

  • @krishnakantkumar946
    @krishnakantkumar946 12 хвилин тому

    Thank you for providing such valuable content! The explanations, animation, and presentation are excellent. Sending lots of love from India ❤❤❤

  • @daayush6654
    @daayush6654 18 днів тому +1

    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

  • @Jp-yx8od
    @Jp-yx8od 3 місяці тому +2

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

  • @jbjsb
    @jbjsb 3 місяці тому +1

    Thanks Baraa ☺

  • @nikhilchaturvedi4823
    @nikhilchaturvedi4823 22 дні тому

    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. 🙂

  • @govardhanreddy690
    @govardhanreddy690 2 місяці тому +1

    Thank You Very Much Sir

  • @Datacodelab
    @Datacodelab 2 місяці тому +1

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

    • @DataWithBaraa
      @DataWithBaraa  2 місяці тому

      Thanks and I am today in India what amazing people

  • @rajshekar1362
    @rajshekar1362 3 місяці тому +1

    Baraa Thank You 😍😊

  • @CuocSongQuanhTa204
    @CuocSongQuanhTa204 3 місяці тому +1

    Thanks Baraa!

  • @DivyYadav-hg2js
    @DivyYadav-hg2js 2 місяці тому +2

    im addicted to this channel more than netflix

  • @mrsobhanku
    @mrsobhanku 3 місяці тому

    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 :)

  • @prashantkanaujia7324
    @prashantkanaujia7324 29 днів тому +1

    amazing tutorial , i really like your presentation , which tool you used for images and writing notes

  • @poojabihani-m9d
    @poojabihani-m9d 3 місяці тому +1

    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.

  • @DivyYadav-hg2js
    @DivyYadav-hg2js 2 місяці тому +2

    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

    • @ska5691
      @ska5691 2 місяці тому

      Is Baraa going to teach Python as well?

  • @Traveling_Rohitindia
    @Traveling_Rohitindia 3 місяці тому +1

    Your video is very good thank you for your efforts.

  • @rajeshrana6481
    @rajeshrana6481 13 годин тому +1

    NICE HINDI BRO, I AM FROM INDIA ,ALWAYS LIKE YOUR VIDEO :)

  • @donyelldf
    @donyelldf 3 місяці тому +1

    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.

  • @karthitonystark9900
    @karthitonystark9900 3 дні тому +1

    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

  • @ManjeeriG
    @ManjeeriG 3 місяці тому +1

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

  • @juancruz7836
    @juancruz7836 3 місяці тому +1

    THANK YOU BARAA!!! :D :D :D

  • @egytal88
    @egytal88 Місяць тому +1

    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.

  • @aliozdemonis2462
    @aliozdemonis2462 3 місяці тому +1

    Hello baraa thanks for the video, do you know when this course Will end? How many videos left?

  • @MamadouCellouDiallo-u9v
    @MamadouCellouDiallo-u9v 3 місяці тому +2

    The only valid comment is thank you very much

  • @cretive549
    @cretive549 3 місяці тому +2

    Please Hadoop and spark❤.

  • @gowthamiheroorsrikanth5018
    @gowthamiheroorsrikanth5018 6 днів тому +1

    I have decided to comment on every one of your videos because those are real gems. I am glad that I found this treasure.

  • @satyamonika915
    @satyamonika915 3 місяці тому +1

    hi,huge fan of your videos sir, your videos helped me alot.can u make full tutorial on powerbi

  • @sagaraggarwal1927
    @sagaraggarwal1927 3 місяці тому +1

    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

  • @akar_excel
    @akar_excel 2 місяці тому +1

    can you tell me the software you use for presentation

  • @DivyYadav-hg2js
    @DivyYadav-hg2js 2 місяці тому +2

    bara when is the new video cominngg?

  • @riyazbabashaik6371
    @riyazbabashaik6371 Місяць тому +1

    Your student from India 😊

  • @MALIK_AR7
    @MALIK_AR7 3 місяці тому +1

    THE SQL SERIES IS DONE AND DUSTED AND I LOVED EVERY MINUTE OF IT.
    BARAA NO WHAT ABOUT A PYTHON SERIES🙂?

  • @makarsh29
    @makarsh29 3 місяці тому +2

    Baraa, how's your coffee stays warm in every session 😀😀

  • @FunTime-play
    @FunTime-play 3 місяці тому

    Sir please make videos on triggers

  • @deep_line_official1
    @deep_line_official1 3 місяці тому +1

    First Comment from India 😁

  • @rishabh-d1s
    @rishabh-d1s 3 місяці тому +1

    Hello baraa after finishing this series whats ur next big plan ?

    • @DataWithBaraa
      @DataWithBaraa  3 місяці тому

      I am not sure yet, I have to decide between python and powerbi

    • @AkashPabbisetti
      @AkashPabbisetti 3 місяці тому +2

      @@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 ?

    • @pujaganthakoru5228
      @pujaganthakoru5228 3 місяці тому

      @@DataWithBaraa Power BI please

    • @DivyYadav-hg2js
      @DivyYadav-hg2js 2 місяці тому

      @@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

    • @aritizya3335
      @aritizya3335 2 місяці тому

      @@DataWithBaraa please, powerbi

  • @OPTIMUSPRIME-q8x
    @OPTIMUSPRIME-q8x 3 місяці тому +3

    i have my exams this week, so wont be able to "TIME TO SIT AND STUDY"

  • @sindhiyadevit6820
    @sindhiyadevit6820 3 місяці тому +1

    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
      @DataWithBaraa  3 місяці тому

      I will do as last chapter of this series

  • @NavinSinghFartyal
    @NavinSinghFartyal 3 місяці тому +1

    haven't uploaded any video this week

  • @PhaswanaLedwaba
    @PhaswanaLedwaba 3 місяці тому

    INSIDE 🙏🚀

  • @road2heaven007
    @road2heaven007 3 місяці тому +2

    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

  • @nayazmohammad7599
    @nayazmohammad7599 3 місяці тому +1

    Bro recursive next time