SQL Views Tutorial | 6 Top Use Cases for Views |

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ธ.ค. 2024

ความคิดเห็น • 65

  • @DataWithBaraa
    @DataWithBaraa  2 หลายเดือนก่อน +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 หลายเดือนก่อน +6

    people dont realize how valuable this channel is

  • @SAhmBal89
    @SAhmBal89 4 วันที่ผ่านมา +1

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

  • @ska5691
    @ska5691 หลายเดือนก่อน +3

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

  • @manjukb8696
    @manjukb8696 หลายเดือนก่อน +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

  • @A4O_TSL
    @A4O_TSL 2 หลายเดือนก่อน +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 🎉

  • @iparpankaj
    @iparpankaj 24 วันที่ผ่านมา +1

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

  • @Toyahan43
    @Toyahan43 หลายเดือนก่อน +1

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

  • @govardhanreddy690
    @govardhanreddy690 หลายเดือนก่อน +1

    Thank You Very Much Sir

  • @deepam.g4558
    @deepam.g4558 2 วันที่ผ่านมา +1

    Excellent narration and information. Thanks you.

  • @jbjsb
    @jbjsb หลายเดือนก่อน +1

    Thanks Baraa ☺

  • @rajshekar1362
    @rajshekar1362 2 หลายเดือนก่อน +1

    Baraa Thank You 😍😊

  • @mrsobhanku
    @mrsobhanku หลายเดือนก่อน

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

  • @piyushmahajan4422
    @piyushmahajan4422 2 หลายเดือนก่อน +2

    thanks baraa for providing this wonderful series

  • @barbmarques2022
    @barbmarques2022 หลายเดือนก่อน +1

    Thanks!

  • @nitinrawat-g6t
    @nitinrawat-g6t 2 หลายเดือนก่อน +1

    finally wait is over thanks baraaaa

  • @Jp-yx8od
    @Jp-yx8od 2 หลายเดือนก่อน +2

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

  • @micaelzekarias1537
    @micaelzekarias1537 2 หลายเดือนก่อน +2

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

  • @donatusohiaeriaku9343
    @donatusohiaeriaku9343 2 หลายเดือนก่อน +1

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

  • @ahmedshalaby9343
    @ahmedshalaby9343 2 หลายเดือนก่อน +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

  • @DivyYadav-hg2js
    @DivyYadav-hg2js หลายเดือนก่อน +2

    im addicted to this channel more than netflix

  • @oksanavorobiova8929
    @oksanavorobiova8929 หลายเดือนก่อน +1

    Baraa, it is so easy to digest, bravo!

  • @Datacodelab
    @Datacodelab 26 วันที่ผ่านมา +1

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

    • @DataWithBaraa
      @DataWithBaraa  26 วันที่ผ่านมา

      Thanks and I am today in India what amazing people

  • @egytal88
    @egytal88 13 วันที่ผ่านมา +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.

  • @RakshitDwivedi-pq8qc
    @RakshitDwivedi-pq8qc หลายเดือนก่อน +1

    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  หลายเดือนก่อน

      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 หลายเดือนก่อน

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

  • @ManjeeriG
    @ManjeeriG 2 หลายเดือนก่อน +1

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

  • @Traveling_Rohitindia
    @Traveling_Rohitindia หลายเดือนก่อน +1

    Your video is very good thank you for your efforts.

  • @CuocSongQuanhTa204
    @CuocSongQuanhTa204 2 หลายเดือนก่อน +1

    Thanks Baraa!

  • @poojabihani-m9d
    @poojabihani-m9d 2 หลายเดือนก่อน +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.

  • @donyelldf
    @donyelldf 2 หลายเดือนก่อน +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.

  • @MamadouCellouDiallo-u9v
    @MamadouCellouDiallo-u9v 2 หลายเดือนก่อน +2

    The only valid comment is thank you very much

  • @satyamonika915
    @satyamonika915 2 หลายเดือนก่อน +1

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

  • @juancruz7836
    @juancruz7836 2 หลายเดือนก่อน +1

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

  • @MALIK_AR7
    @MALIK_AR7 2 หลายเดือนก่อน +1

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

  • @deep_line_official1
    @deep_line_official1 2 หลายเดือนก่อน +1

    First Comment from India 😁

  • @DivyYadav-hg2js
    @DivyYadav-hg2js หลายเดือนก่อน +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 หลายเดือนก่อน

      Is Baraa going to teach Python as well?

  • @aliozdemonis2462
    @aliozdemonis2462 2 หลายเดือนก่อน +1

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

  • @makarsh29
    @makarsh29 2 หลายเดือนก่อน +2

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

  • @sagaraggarwal1927
    @sagaraggarwal1927 2 หลายเดือนก่อน +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 23 วันที่ผ่านมา +1

    can you tell me the software you use for presentation

    • @DataWithBaraa
      @DataWithBaraa  23 วันที่ผ่านมา

      @@akar_excel procreate :)

  • @DivyYadav-hg2js
    @DivyYadav-hg2js หลายเดือนก่อน +2

    bara when is the new video cominngg?

  • @cretive549
    @cretive549 2 หลายเดือนก่อน +2

    Please Hadoop and spark❤.

  • @FunTime-play
    @FunTime-play 2 หลายเดือนก่อน

    Sir please make videos on triggers

  • @PhaswanaLedwaba
    @PhaswanaLedwaba 2 หลายเดือนก่อน

    INSIDE 🙏🚀

  • @sindhiyadevit6820
    @sindhiyadevit6820 2 หลายเดือนก่อน +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  2 หลายเดือนก่อน

      I will do as last chapter of this series

  • @rishabh-d1s
    @rishabh-d1s 2 หลายเดือนก่อน +1

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

    • @DataWithBaraa
      @DataWithBaraa  2 หลายเดือนก่อน

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

    • @AkashPabbisetti
      @AkashPabbisetti 2 หลายเดือนก่อน +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 2 หลายเดือนก่อน

      @@DataWithBaraa Power BI please

    • @DivyYadav-hg2js
      @DivyYadav-hg2js หลายเดือนก่อน

      @@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 หลายเดือนก่อน

      @@DataWithBaraa please, powerbi

  • @OPTIMUSPRIME-q8x
    @OPTIMUSPRIME-q8x 2 หลายเดือนก่อน +3

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

  • @road2heaven007
    @road2heaven007 2 หลายเดือนก่อน +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

  • @NavinSinghFartyal
    @NavinSinghFartyal 2 หลายเดือนก่อน +1

    haven't uploaded any video this week

  • @nayazmohammad7599
    @nayazmohammad7599 2 หลายเดือนก่อน +1

    Bro recursive next time