Database Fundamentals

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ก.ย. 2024

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

  • @automationsolution
    @automationsolution 7 ปีที่แล้ว +15

    the greatest database tutorial i ever saw!

  • @Mike_MB
    @Mike_MB 5 ปีที่แล้ว +8

    Perhaps the most clear and concise explanation I have found on TH-cam for the given content. Great job.

    • @vipulverma5972
      @vipulverma5972 2 ปีที่แล้ว

      I wanted to comment same thing, but after viewing this, I changed my mind

  • @rkolb2567
    @rkolb2567 13 ปีที่แล้ว +1

    You could easily teach a child this stuff. Everything about your videos are perfect. Keep it up. I'd love to see some more database stuff

  • @montemendoza
    @montemendoza 14 ปีที่แล้ว +1

    I love the graphics and fonts that you used in this video. Your voice-over is great. I wish that you had 1001 videos instead of just one. I hope I can find more videos that are as good as yours.

  • @ZeratulHONOR
    @ZeratulHONOR 11 ปีที่แล้ว +1

    Thank you, Prof. Brown! So much knowledge, concentrated in only a few minutes and so easy to understand.

  • @adrianmario4991
    @adrianmario4991 2 ปีที่แล้ว

    This is hands-down the best explanation and introduction to databases!

  • @hi_arav
    @hi_arav 9 ปีที่แล้ว +4

    This was a very informative crash course on database fundamentals. It serves as a fantastic reviewing video as well, and the visuals enhanced the video to the quality it is at. Thank you very much, and great job.

  • @areyesilva
    @areyesilva 10 ปีที่แล้ว +1

    Why I hadn't found this such a great video at the start of my semester :(

  • @RohanZohan21
    @RohanZohan21 11 ปีที่แล้ว

    Thank you , better than any lectures ive attended , 7 mins = 1 year of my lectures !

  • @the3watt
    @the3watt 11 ปีที่แล้ว

    Hands down best db lesson I've seen so far.

  • @beejay210
    @beejay210 13 ปีที่แล้ว

    After watching about 20 other database videos, this one finally made sense...thank you. I'm in Business Management Tools class and we are on database and this helped out a lot.

  • @emmieroark9769
    @emmieroark9769 8 ปีที่แล้ว +1

    Very easy to understand. Thanks for presenting it like this!

  • @hectorg362
    @hectorg362 3 ปีที่แล้ว

    I like this video! Excellent and straight forward! Thanks!

  • @floor-seats
    @floor-seats 13 ปีที่แล้ว

    Thank you very much for posting this video. It is very helpful and I learned a lot. Thanks.

  • @WOGI5M
    @WOGI5M 14 ปีที่แล้ว

    thanks for this. i just realised that i have been doing mY assignment wrong thanks to this.

  • @nonceprogrammer
    @nonceprogrammer 13 ปีที่แล้ว

    What a good tutorial!!!!!!!! I am subscribing right now.

  • @nesh1877
    @nesh1877 8 ปีที่แล้ว +1

    thank you. this is the best explanation everybody can ever have.

  • @DragonSolidSnakeNY
    @DragonSolidSnakeNY 12 ปีที่แล้ว

    this is one of the best videos I have every seen for educational purposes, sooo clear and not boring haha. I wish you had more on databases and theory of computation!!

  • @sadeyestt
    @sadeyestt 14 ปีที่แล้ว

    @profbbrown That'd be great! Can't wait to see your other videos!

  • @TheKiriru
    @TheKiriru 8 ปีที่แล้ว +1

    Best explanation I've come across!

  • @assyriaaaaa
    @assyriaaaaa 12 ปีที่แล้ว

    Thanks very much for this super-easy-to-understand video!!! You are a good explainer!

  • @shaolin113
    @shaolin113 13 ปีที่แล้ว

    excellent tutorial prof. Nice clear info, clear examples, clear visual aids and audible, concise language. quick delivery but not over the heads of those of us that are not brain dead.
    well done :)

  • @auslife143
    @auslife143 12 ปีที่แล้ว

    i really loved this video, so simple to understand, it makes sense, i wish i could get more videos lke this, plz someone help me m studying database, if anyone haave such nice and easy videoss to share , it will be a great help......
    thanx to the uploader, plz share some more videos lil bit more advanced i mean next step....

  • @Aloysius1966
    @Aloysius1966 13 ปีที่แล้ว

    Thanks for the response.
    RE: Database - I meant the latter in your response -- the actual tables, views, etc.
    I don't have a visual representation for the schema, other than it looks like an organization chart, like I do for the instance and database, I can see them and their relationship.
    Using the Russian Doll analogy .... tables, views, etc., inside a schema, a schema inside of a database and a database inside an instance?

  • @zblackz8992
    @zblackz8992 6 ปีที่แล้ว

    i was struggling in database since my lecturer is bad at lecturing,but ur video hlp me to understand this subject well,thank you

  • @tobe_or_notbe
    @tobe_or_notbe 3 ปีที่แล้ว

    such a great video, really helped me understand the topic right away! thankyou :)

  • @SahaAlankarkolkata
    @SahaAlankarkolkata 11 ปีที่แล้ว

    I'm very thankful for your great tutorial on dbms basics

  • @iamxieqi
    @iamxieqi 12 ปีที่แล้ว

    very good analysis of the basic of database. it's clearly represented and well understandable

  • @abubruno
    @abubruno 13 ปีที่แล้ว

    Please Mister,
    Would it be possible for you to post a video with more Database explanation??? I found your material very didactic and it falls into a very easy understanding....

  • @profbbrown
    @profbbrown  11 ปีที่แล้ว +1

    Thanks! I'm going to try to do more this summer.

  • @maurohenriquefidelix2526
    @maurohenriquefidelix2526 4 ปีที่แล้ว

    Very helpful. Thank you.

  • @JakeMcCredieEire09
    @JakeMcCredieEire09 9 ปีที่แล้ว +5

    Thank you very much for this very helpful video. Straight to the point, Very good presentation. Would be excellent if you did more videos on Database Terminology, such as Database structures, Database schema, logical and physical views,

    • @profbbrown
      @profbbrown  9 ปีที่แล้ว

      Jake McCredie I have more videos about databases. Take a look around my channel.

    • @MattElphinstoneMedia
      @MattElphinstoneMedia 9 ปีที่แล้ว

      Barry Brown OMG YOUR SO GOOD I LOVE YOUR CONTENT DM ME PLS BRO :)))))))))

    • @dane5820
      @dane5820 9 ปีที่แล้ว

      MattElphinstone Media I agree nice work barry brown, a true inspiration

    • @yoyo699sChannel
      @yoyo699sChannel 9 ปีที่แล้ว

      MattElphinstone Media OMG!! THIS IS MINT
      I LOVE YOUR VIDS MAN
      SOOOOOO GREAT

    • @MattElphinstoneMedia
      @MattElphinstoneMedia 9 ปีที่แล้ว

      Danye CSGO Thank you, some one who shares my love for a big strong man who can take care of a big complicated computer like Barry!! luv u :)) xx

  • @ajaytimalsina2964
    @ajaytimalsina2964 11 ปีที่แล้ว

    Thankyou, for providing fundamental concepts of database.It was really a great explanation.

  • @Thezizoubear
    @Thezizoubear 6 ปีที่แล้ว

    Very well done thank you

  • @ginakrieb387
    @ginakrieb387 10 ปีที่แล้ว

    This was super helpful! You made it all very easy to understand. Thanks so much!

  • @wonsuk307
    @wonsuk307 11 ปีที่แล้ว

    Sir thank you so much for this video.... extremely clarity and entertaining presentation!

  • @christinebullard2161
    @christinebullard2161 9 ปีที่แล้ว

    Great video, very straight forward! thanks so much.

  • @brazwen
    @brazwen 11 ปีที่แล้ว

    This was super helpful. I feel confident that I can pass this Database course now. :D

  • @TheRoxas13th
    @TheRoxas13th 11 ปีที่แล้ว

    Great teaching and clear explanation. Thanks Mr. Barry :D

  • @bhaavamritdhaara
    @bhaavamritdhaara 11 ปีที่แล้ว

    your style of presentation is really commendable!!

  • @shanegrief52
    @shanegrief52 8 ปีที่แล้ว

    Thank you, you make this so easy to understand!

  • @clausewitzschultz7161
    @clausewitzschultz7161 8 ปีที่แล้ว

    Well Done Sir. Incredible Explanation. Thank You

  • @ابراهيمالنفيسي-ص4و
    @ابراهيمالنفيسي-ص4و 6 ปีที่แล้ว

    !Excellent

  • @AmitRoy-oy4ch
    @AmitRoy-oy4ch 8 ปีที่แล้ว

    Well done Sir, Described it so beautifully.

  • @carltonseymour869
    @carltonseymour869 8 ปีที่แล้ว

    Incredible explanation!! Thanks You Barry

  • @satkartarsingh94
    @satkartarsingh94 11 ปีที่แล้ว

    sir great explanation,really very easy to understand need more videos on candidate key,super key,etc...

  • @waleedkhalid3021
    @waleedkhalid3021 6 ปีที่แล้ว

    Best videos.

  • @jiggasnap
    @jiggasnap 8 ปีที่แล้ว

    Real good man.

  • @FutureProofNothing
    @FutureProofNothing 10 ปีที่แล้ว

    thank you a lot for such simple explanation.

  • @SashaClaudeee
    @SashaClaudeee 10 ปีที่แล้ว

    Very clear, very helpful. Is the distinction between "identifying" and "non-identifying" relationships covered in a later video?

  • @fon267
    @fon267 9 ปีที่แล้ว

    At last! a good tutorial on db basics...

  • @sadeyestt
    @sadeyestt 14 ปีที่แล้ว

    Loved it! Think my students may enjoy it also!

  • @Aloysius1966
    @Aloysius1966 13 ปีที่แล้ว

    Thank's for the video.
    What's the difference between a database and a schema?

  • @peacemanzach
    @peacemanzach 9 ปีที่แล้ว

    Well done. Thank you.

    • @profbbrown
      @profbbrown  9 ปีที่แล้ว

      +Zach Schultz Thanks!

  • @yamenedel3628
    @yamenedel3628 7 ปีที่แล้ว

    Thanks a lot for your perfect explanation and tutorial

  • @surjge
    @surjge 11 ปีที่แล้ว

    thanks for me this was a refresher I had forgotten some of this information

  • @auslife143
    @auslife143 12 ปีที่แล้ว

    plz uploader ....share some more videos one by one, step by step....plz
    and thanx a lot

  • @hamza98888
    @hamza98888 13 ปีที่แล้ว

    perfect work

  • @revman99
    @revman99 11 ปีที่แล้ว

    Great video but question: why wouldn't you create another table for car make and models with a primary key and then have a third table, 'people and cars', that just had the two foreign keys; ownerID and carID? This way you don't duplicate car data because more than one person could own the same car.

  • @Oaulakh1
    @Oaulakh1 8 ปีที่แล้ว

    so simple and to the point, superb man and thanks for this :)

  • @faheemboy
    @faheemboy 13 ปีที่แล้ว

    thank you 4 the effort

  • @gaiabenaglia7595
    @gaiabenaglia7595 11 ปีที่แล้ว

    this one killed my doubts on databases :)

  • @Prishea
    @Prishea 11 ปีที่แล้ว

    This video is extremely helpful, thanks!!

  • @alexcianelson
    @alexcianelson 3 ปีที่แล้ว

    Thank you for this

  • @TheProid
    @TheProid 13 ปีที่แล้ว

    more tutorials! please, Your a great teacher.

  • @diegonhathanielagrielabalc2504
    @diegonhathanielagrielabalc2504 4 ปีที่แล้ว

    Dude that was perfect

  • @seosimba
    @seosimba 9 ปีที่แล้ว +1

    Excellent.

  • @chris.scott510
    @chris.scott510 9 ปีที่แล้ว

    Great video.

  • @sideshow557
    @sideshow557 13 ปีที่แล้ว

    How then would you create a primary key for the car table or can the table existe without a primary key? (Great vid. BTW)

  • @chandrakanthm1161
    @chandrakanthm1161 10 ปีที่แล้ว +1

    its very nice sir........

  • @DONOChannel
    @DONOChannel 4 ปีที่แล้ว

    Tod owns some nice cars.

  • @shreekant2753
    @shreekant2753 2 ปีที่แล้ว

    Sir, please continue subject database

  • @mzbebe82
    @mzbebe82 10 ปีที่แล้ว +1

    super helpful thank you

  • @kb112937
    @kb112937 13 ปีที่แล้ว

    am I able to copy some of your presentation slides like samples of the databases?

  • @erickahmc
    @erickahmc 12 ปีที่แล้ว

    you are a life-saver! :) x

  • @mzbebe82
    @mzbebe82 10 ปีที่แล้ว

    is there meant to be sound for this video or just images?

  • @princessteeana8834
    @princessteeana8834 8 ปีที่แล้ว

    Thanks you so much for this!!

  • @sumanthmungari
    @sumanthmungari 11 ปีที่แล้ว

    Thank you dude....:-)
    You're great dude...

  • @nelu114
    @nelu114 12 ปีที่แล้ว

    Thank you so much for this! :)

  • @TheWheelchairGuy
    @TheWheelchairGuy 7 ปีที่แล้ว

    My teacher does not teach shit. Thank you for this tutorial.

  • @johnaldrichleigh657
    @johnaldrichleigh657 7 ปีที่แล้ว

    very nice (y)

  • @datanewt6938
    @datanewt6938 8 ปีที่แล้ว

    Why doesn't the cars table have a primary key? Shouldn't every table have a primary key? Is a foreign key sufficient?

    • @profbbrown
      @profbbrown  8 ปีที่แล้ว

      +Data Newt Yes, every table should have a PK. However, it doesn't need to be explicitly listed. A PK is simply a set of attributes that can be used to uniquely identify each record. In this example, the PK could be the set of all attributes.

    • @mallemang
      @mallemang 7 ปีที่แล้ว

      there should be a unique identifier for the car table no? how about a VIN number?

  • @elephiant8696
    @elephiant8696 11 ปีที่แล้ว

    Great video! :D

  • @skandhachinta1572
    @skandhachinta1572 7 ปีที่แล้ว

    What if Bob also owns a 2005 Toyota Prius (which is similar to what Alice owns)?

    • @profbbrown
      @profbbrown  7 ปีที่แล้ว +1

      That's not a problem in these tables. Since the ownerID is different, the two records in the Cars table would be distinguishable.

  • @anguswright5848
    @anguswright5848 7 ปีที่แล้ว

    What happens if more than one person owns the same car? how do we show that on the table

    • @profbbrown
      @profbbrown  7 ปีที่แล้ว +1

      That's a many-to-many relationship: each person can own more than one car and each car can be owned by more than one person. To implement that, you'll need what's called a "resolution table": a third table that resolves the one many-to-many into a couple of one-to-many relationships.

    • @anguswright5848
      @anguswright5848 7 ปีที่แล้ว

      Thank you

    • @mallemang
      @mallemang 7 ปีที่แล้ว

      that's true but I don't think (in real life) that any state or province would allow a car to be owned by more than one entity.

  • @suzuki140291
    @suzuki140291 12 ปีที่แล้ว

    the sound is little bit low :(

  • @TenzLekden
    @TenzLekden 11 ปีที่แล้ว

    What happens when there is two people that own the same car?

  • @learnwriting3242
    @learnwriting3242 8 ปีที่แล้ว

    why not just put all the cars into an array instead of another table ?

    • @YinundYoung
      @YinundYoung 7 ปีที่แล้ว

      isnt an array a kind of table?

    • @profbbrown
      @profbbrown  7 ปีที่แล้ว +1

      Yes, an array is a kind of table. The primary difference is an array has an index (usually a sequential ID number) and single associated value. A table can have an index that could be non-numeric and it can have several values, such as make/model/year.

  • @mikesvacationgearguncigarr3774
    @mikesvacationgearguncigarr3774 7 ปีที่แล้ว

    this was a cool video, but yoyr sound editing os really off. somehow you have your volume turned down to 50 or 75%. this makes your video really difficult to watch on a smart phone.

    • @profbbrown
      @profbbrown  7 ปีที่แล้ว

      Sorry. This was one of the first videos I ever made. I have better equipment and techniques now. :)

    • @mikesvacationgearguncigarr3774
      @mikesvacationgearguncigarr3774 7 ปีที่แล้ว

      Barry Brown your welcome sir!!👍👍✔✔☺

  • @duqan9060
    @duqan9060 6 ปีที่แล้ว

    What if Bob doesn't look 19?

  • @diegonhathanielagrielabalc2504
    @diegonhathanielagrielabalc2504 4 ปีที่แล้ว

    Dude that was perfect