Это видео недоступно.
Сожалеем об этом.

Lec-112: View in Database | Oracle, SQL Server Views | Types of Views

Поделиться
HTML-код
  • Опубликовано: 19 авг 2021
  • 👉Subscribe to our new channel: / @varunainashots
    ► Database Management System(Complete Playlist):
    • DBMS (Database Managem...
    Other subject-wise playlist Links:
    --------------------------------------------------------------------------------------------------------------------------------------
    ►Design and Analysis of algorithms (DAA):
    • Design and Analysis of...
    ►Computer Architecture (Complete Playlist):
    • Computer Organization ...
    ► Theory of Computation
    • TOC(Theory of Computat...
    ►Artificial Intelligence:
    • Artificial Intelligenc...
    ►Computer Networks (Complete Playlist):
    • Computer Networks (Com...
    ►Operating System:
    • Operating System (Comp...
    ►Structured Query Language (SQL):
    • Structured Query Langu...
    ►Discrete Mathematics:
    • Discrete Mathematics
    ►Compiler Design:
    • Compiler Design (Compl...
    ►Number System:
    • Number system
    ►Cloud Computing & BIG Data:
    • Cloud Computing & BIG ...
    ►Software Engineering:
    • Software Engineering
    ►Data Structure:
    • Data Structure
    ►Graph Theory:
    • Graph Theory
    ►Programming in C:
    • C Programming
    ►Digital Logic:
    • Digital Logic (Complet...
    ---------------------------------------------------------------------------------------------------------------------------------------
    Our social media Links:
    ► Subscribe to us on RUclips: / gatesmashers
    ►Subscribe to our new channel: / @varunainashots
    ► Like our page on Facebook: / gatesmashers
    ► Follow us on Instagram: / gate.smashers
    ► Follow us on Instagram: / varunainashots
    ► Follow us on Telegram: t.me/gatesmash...
    ► Follow us on Threads: www.threads.ne...
    --------------------------------------------------------------------------------------------------------------------------------------
    ►For Any Query, Suggestion or notes contribution:
    Email us at: gatesmashers2018@gmail.com

Комментарии • 233

  • @choclatixxsana9815
    @choclatixxsana9815 3 года назад +197

    I'm from Pakistan.. like your lecture, main ny sari preparation APK lectures sy ki .. too much easier in understanding. Love from Pakistan ❤️❤️

  • @ritwikabandyopadhyay9239
    @ritwikabandyopadhyay9239 2 года назад +82

    I never have commented in any RUclips videos till yet, just broke the streak lol.
    Sir your operating system playlist and DBMS playlist are simply amazing. Even though I'm from non cs background these are really helping me. It's very very commendable of you that we're getting such quality and quantity content for free.
    May you always stay happy and healthy, Sir!

    • @111rhishishranjan2
      @111rhishishranjan2 Год назад +3

      no no , he did not solved any questions in views, its not good way of teaching , if interview ask u to write query, u won't be able to do that .

  • @prashantraj6366
    @prashantraj6366 2 года назад +17

    I have gone through all your 112 lec and I feel it was worth it and I hope it's sufficient.
    Happy Teacher's Day🙏

  • @viru23singh
    @viru23singh 3 года назад +7

    finally aaj dbms ki saari playlist complete ker li. fully enjoyed. thanks sir ji

  • @saudaminideshmukh2272
    @saudaminideshmukh2272 2 года назад +3

    greate explanation sir, actully im doing paid class after attending my paid class lecture i was in total conundrum.. and after attending your lecture i fell like its simple concept..ty sir..

  • @saddamsidddique9105
    @saddamsidddique9105 Год назад +1

    I dnt have words to say the way you explain,best sql videos ever seen in youtube.

  • @akshitjasrotia9579
    @akshitjasrotia9579 2 года назад +1

    bohat videos dekhi but aapke jesa koe bhi nhi samjaata sir.....Thanks

  • @kamalrautela797
    @kamalrautela797 2 года назад +2

    amazing, 5 saal se aaj samajh me aaya :D

  • @NitishKumar-ur9sw
    @NitishKumar-ur9sw 2 года назад +1

    Sir... Maine ye pura playlist dekha ...or iss mere job interview me bahut help mila... Or aaj mai placed ho chuka hu.... aapko dhanyawad bolna tha... ❤️

  • @user-sf7nu7ip3v
    @user-sf7nu7ip3v Год назад +4

    INSERT, DELETE & UPDATE are DML Languages, Not DDL Language.

  • @Naveed_Ahmed5
    @Naveed_Ahmed5 2 года назад +14

    The way you explain just mind blowing. Thanks a lot sir you helped me a lot in this course. My DBMS exam is on 8 september. Truly appreciated content. Love & support from Pakistan.

    • @afnankhan1278
      @afnankhan1278 2 года назад +1

      brother could you provide lilter bit guidence????

    • @shubhampalri97
      @shubhampalri97 Год назад +2

      bomb banane wali playlist share kriye bhai

    • @swanand454
      @swanand454 Месяц назад

      😂😂​@@shubhampalri97

  • @priangshumukherjee
    @priangshumukherjee 7 месяцев назад +8

    Bhai me college 2 year me hu mujhe nhi pta tha ki view ka matlab virtual table hota he kya ye society mujhe accept karegi🙂

    • @ARSAGAMING69
      @ARSAGAMING69 3 месяца назад +1

      Tension na le , Hume bhi nhi pta tha 😅

    • @jaisleenkaur6464
      @jaisleenkaur6464 2 месяца назад

      Mujhe be nhi pta tha 😊

  • @mansist4882
    @mansist4882 2 года назад +3

    Sir your explanation is much better than others. I request you to explain DBMS in detail and RDBMS. I don't know anything sir and now I'm going to appear for exam. Your videos will surely help me to understand. Plz it's a request...........

  • @rabindra66
    @rabindra66 2 месяца назад

    00:09 Understanding the concept of views in a database
    03:34 Views in database are virtual tables with no physical existence.
    05:20 Views in database and their impact on base table
    07:02 Read-only views and materialized views are important for data warehousing and data mining.
    08:43 Views in database allow for data retrieval from one or multiple tables.
    10:27 Views in databases provide a way to restrict access and simplify complex queries.
    12:06 Views provide data independence and different access privileges based on roles.

  • @AJCHARY545
    @AJCHARY545 3 года назад +1

    Hi sir I’m jagadeeshwar from Hyderabad your voice and subject is very impressive high level
    I’m follow last year

  • @aasimmemon6783
    @aasimmemon6783 3 года назад +4

    Love From Pakistan. Thank u Sir. May Allah bless u

    • @avinashyadav8598
      @avinashyadav8598 3 года назад +4

      Bhai kaha SQL phad rhe ho,, 🤣🤣🤣 ja kar bomb aur gun making wala video dheko,, jo tumare syllabus m hai 🤣🤣🤣🤣

  • @ayushigorai7500
    @ayushigorai7500 3 года назад +4

    Just completed the playlist...thank you so much sir.

  • @jyotirani8232
    @jyotirani8232 3 года назад +5

    good evening sir.

  • @praveshgaming2374
    @praveshgaming2374 2 года назад +2

    This man making my future bright 🥺❤️
    Thanku so much for your efforts ❤️💯

  • @thatfact2840
    @thatfact2840 2 года назад +5

    Thank u sir ,just completed this beautiful playlist

  • @govindlal2253
    @govindlal2253 Год назад

    Yesterday I attended SQL view class, could not understand anything. After seeing your video now its clear. Thanks.

  • @thatfact2840
    @thatfact2840 2 года назад +2

    Finally completed this playlist ..thank you sir ..

  • @tulsilukhi6106
    @tulsilukhi6106 2 года назад +1

    I just completed playlist .Thanks for providing this mush valuable content .

  • @abdulmazid8365
    @abdulmazid8365 2 года назад +3

    thank you so much for a nice and productive explanation sir i was asked questions on views but couldn't answer accordingly thanks a ton

  • @waseemakram9258
    @waseemakram9258 2 года назад +2

    Thank you sir g very helpful and very acknowledge video as always.
    Love you sir from all pakistanies viewers. ❣️

    • @shubhampalri97
      @shubhampalri97 Год назад +1

      bomb banane wali playlist share kriye bhai

  • @dhritisinha8377
    @dhritisinha8377 2 года назад

    Cleared all the concepts
    Ap bhagwan ho 🙏🙏🙏

  • @focusreflect8223
    @focusreflect8223 Год назад

    Sir your explanation is awesome than the usual college faculties.❣️❣️❣️❣️❤️❣️❣️❤️❣️❣️

  • @ashwinighatol1859
    @ashwinighatol1859 3 года назад +6

    Sir,I request you to upload videos of python,it is highly recommended nowadays....

  • @dippal5805
    @dippal5805 8 месяцев назад +1

    00:09 Understanding the concept of views in a database
    03:34 Views in database are virtual tables with no physical existence.
    05:20 Views in database and their impact on base table
    07:02 Read-only views and materialized views are important for data warehousing and data mining.
    08:43 Views in database allow for data retrieval from one or multiple tables.
    10:27 Views in databases provide a way to restrict access and simplify complex queries.
    12:06 Views provide data independence and different access privileges based on roles.
    Crafted by Merlin AI.t

  • @algalande
    @algalande 2 года назад +3

    TEACHERS LIKE YOU ARE HELPING A LOT.

  • @sumanthbijapur9325
    @sumanthbijapur9325 2 года назад +1

    Sir thank You For Wonder Full Lecture

  • @malaikss8772
    @malaikss8772 2 года назад

    i m also from Pakistan,
    your way of talk is so awesome apka smjhny ka andz boht Acha ha
    keep going sir🌼💎

  • @parikramacollege31
    @parikramacollege31 11 месяцев назад +2

    Engineering Savior ❤

  • @dipayandas665
    @dipayandas665 3 года назад +4

    Excellent video sir...plz make video on stored procedures

  • @dundappafulari9208
    @dundappafulari9208 Год назад

    I like your teaching style sir, Thanku very much 🎉🎉🎉🎉🎊🎊🎊

  • @raviprakashgupta3736
    @raviprakashgupta3736 3 года назад +1

    Interview phod denge aab 🤩

  • @Shubhamdhanda111
    @Shubhamdhanda111 8 месяцев назад +1

    Thanks a ton!

  • @DataJunctiontrain
    @DataJunctiontrain Год назад +1

    Nice sir easy to understand 👍

  • @keepguessing1234
    @keepguessing1234 Год назад +2

    you are great but I would like to suggest that plz mention all video summary points in short in description or in pinned comment

  • @everydayisspecial8616
    @everydayisspecial8616 3 года назад +1

    wonderful illustration and presentation 👍.. Thank you...

  • @sugandhapandey148
    @sugandhapandey148 2 года назад +1

    Amazing explanations sir. makes my all doubts clear. Thanks

  • @rahulgadekar8509
    @rahulgadekar8509 Год назад +1

    what is diffrence in
    select* from table name;
    select table name.*,😞😦

  • @willturner3440
    @willturner3440 2 года назад

    Bhot vadhiya sir ji , mja aa gya

  • @sherymalik8501
    @sherymalik8501 3 года назад

    Thank u for coming back to this playlist....

  • @AD-ok8mj
    @AD-ok8mj 2 года назад

    From board to computer... U updated

  • @nasirakram8215
    @nasirakram8215 2 года назад +1

    I understand your lectures dear sir

    • @nasirakram8215
      @nasirakram8215 2 года назад

      Dear sir one video make about final project about databases such as library and shop etc.

  • @vasiminamdar4476
    @vasiminamdar4476 7 месяцев назад

    GREAT EXPLANATION

  • @niazullah9351
    @niazullah9351 2 года назад +1

    singla sir , love from pakistan ...
    i completed all but it will enough for database or still more videos coming in this playlist ....
    wait for your answee.💙💙

  • @sonukumar-jn6vt
    @sonukumar-jn6vt 9 месяцев назад +1

    Hello Varun sir kya koi pratice book h jisme DBMS data structures and computer networks and os ka only questions bank ho for only practice

  • @savithamaradi7836
    @savithamaradi7836 Год назад

    Thank so much sir for nice lectures

  • @mr.gamertech9
    @mr.gamertech9 Год назад

    ASSALAM.U.ALAIKUM THANK SIR ALLAH PAK AP KI HAR DUA KABOOL KARE AMEEN

  • @TejpalSingh-rq6pu
    @TejpalSingh-rq6pu 2 года назад

    Bhoot Bhoot dhanyawad 🙏🙏 sir

  • @fairystar4869
    @fairystar4869 3 года назад

    U r great..,God bless u

  • @deepshikhakhatri3338
    @deepshikhakhatri3338 2 года назад

    just wow.... nicely explained

  • @bajiravkhatale879
    @bajiravkhatale879 Год назад +1

    sir who is steven smith ?

  • @GadoonVines
    @GadoonVines 3 года назад

    weldon sir.. informative...

  • @hsharan100
    @hsharan100 Год назад

    Amazing explanation

  • @user-tu1hr1qk4p
    @user-tu1hr1qk4p 10 месяцев назад

    Suupperbb class sir❤

  • @ayushsrivastav9068
    @ayushsrivastav9068 3 года назад +2

    ❤️❤️ from Patna Bihar

  • @ishraq4685
    @ishraq4685 2 года назад

    You for sharing your knowledge

  • @biswashdevkota
    @biswashdevkota 6 месяцев назад

    Thank you

  • @sigmarules8824
    @sigmarules8824 2 года назад

    Nam myoho renge kyo... plzz clear my database exam Buddha..ty sir

  • @kuldeepmishra1206
    @kuldeepmishra1206 3 года назад +1

    sir pz make a video on gate 2022 ..after selecting paper 1 shoud we opt for paper 2 if yes wt are advantages ex - paper-1-cs if anyone from paper-2 ec,ge,ma,st advantages disadvantages

  • @swekshasrivastava3137
    @swekshasrivastava3137 Год назад +1

    I am not able to find second video of this Topic ?

  • @lakshaykamboj4966
    @lakshaykamboj4966 2 года назад +1

    Sir please upload vedio on views in data base pratical vedio on live SQL

  • @vishnujatav6329
    @vishnujatav6329 2 года назад

    Very much interesting

  • @sumairkhan9536
    @sumairkhan9536 Год назад

    great explanation brother.

  • @gautam4696
    @gautam4696 2 года назад +1

    sir is the playlist completed now or more lectures will be added kindly reply? '

  • @Code_JAVA268
    @Code_JAVA268 2 года назад

    Very nice playlist loved it!

  • @nitinmahajan8687
    @nitinmahajan8687 2 года назад

    Excellent ✨✨✨

  • @pivotprogrammer5602
    @pivotprogrammer5602 3 года назад +1

    Sir please complete playlist of digital logic 🙏🙏

  • @ahsanmehmood517
    @ahsanmehmood517 Год назад

    Best one

  • @prince_gaming1520
    @prince_gaming1520 Год назад

    Very good

  • @MetronMafia
    @MetronMafia 10 месяцев назад

    That line touched my heart subscribe from other devices 😂😂😂

  • @monaliwaikar7050
    @monaliwaikar7050 2 года назад

    Wonderful explanation

  • @saraswatisolpure8905
    @saraswatisolpure8905 2 года назад +2

    Sir please make more lecture on view's

    • @asquareacademy2310
      @asquareacademy2310 Год назад +1

      ruclips.net/video/r3YxWMHYCsk/видео.html you can watch view demonstration on this link thank you

  • @larabyacine3397
    @larabyacine3397 11 месяцев назад

    شكرا على الدرس

  • @abdulazeemahmed1048
    @abdulazeemahmed1048 2 года назад +1

    As a cricket fan Steve to Steve Smith.

  • @AakashYadav-kb2qn
    @AakashYadav-kb2qn 2 месяца назад

    6:52 ..insert,update,delete is an dml commad not ddl.

  • @user-zg9et5ff8r
    @user-zg9et5ff8r 6 месяцев назад

    Sir function, or stored procedure pr bhi video bnayea .plzz

  • @pujabiswas6613
    @pujabiswas6613 3 года назад +1

    Sir plz complete the playlist of discrete mathematics,engineering mathematics and also data structure..

    • @ganeshsagar302
      @ganeshsagar302 3 года назад

      Watch code with Harry for data structures

  • @AnjaliGupta-op1hr
    @AnjaliGupta-op1hr 3 года назад +1

    thank you sir 😊❤️

  • @prashantraj6366
    @prashantraj6366 2 года назад

    Thank you, sir upload videos asap

  • @vaishnavipatil3319
    @vaishnavipatil3319 Год назад

    Thank you for the video. Pls provide link for practical session.

  • @manemanoj3068
    @manemanoj3068 3 года назад +1

    Sir Make videos on Full course of DSA..

  • @talhakhaliq3491
    @talhakhaliq3491 3 года назад +1

    sir kindly make videos on plsql topics

  • @arvindSingh-iu6ue
    @arvindSingh-iu6ue Год назад

    Best example is
    Any physical object and shadow of that object

  • @muzamilahmed3127
    @muzamilahmed3127 Месяц назад

    love from Pakistan

  • @rahulrahul6259
    @rahulrahul6259 Год назад

    Wow thanks

  • @sumitbidari2706
    @sumitbidari2706 Год назад

    bro, insert update delete is a DML command not a DDL command. you have said wrong in 6.52. Thank you

  • @shashank2757
    @shashank2757 2 года назад

    I am not getting link of the next video of implementation of views. Can any one help

  • @unemployedcse3514
    @unemployedcse3514 3 года назад

    Awesome 💞

  • @Upendrareddy07
    @Upendrareddy07 3 года назад

    Good evening sir
    Pls sir provide complete software engineering class sir

  • @ayushsrivastav9068
    @ayushsrivastav9068 3 года назад

    Helpful video ❤️❤️

  • @premnath3864
    @premnath3864 2 года назад +1

    sir what is your next video on views??

  • @_PremKharat
    @_PremKharat 2 года назад

    Does anyone know in which video practical implementationof views are done??? Tell as early as possible

  • @zulfiqarali1804
    @zulfiqarali1804 Месяц назад

    😮

  • @creps7729
    @creps7729 Год назад

    Hi sir ,
    Database sikhne ke liye kon kon se language Ani chahiye

  • @yashgarg3027
    @yashgarg3027 3 года назад

    bhaiya i am in delhi university and i want to know jo apna dbms series ma jasa explanation btai hui hain usi ko same hum likh de toh marks mil jaye ge kya exams mein in university collage ya jo books ki language me hi likhna hoga please reply bhaiya

  • @targetsubconscious3003
    @targetsubconscious3003 2 года назад

    sir has said we cant use ddl commands on updatable view