MySQL in 25 Minutes | Primary and Foreign Keys | Database Terminology for Beginners

Поділитися
Вставка
  • Опубліковано 13 жов 2024

КОМЕНТАРІ • 57

  • @365DataScience
    @365DataScience  4 роки тому +3

    🚀Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sGBk7a

  • @tomatocultivator2456
    @tomatocultivator2456 3 роки тому +16

    Can't believe that I finally understood this lesson. Your channel is such a big help!

  • @stolensentience
    @stolensentience 4 роки тому +9

    needs way more views. explained in 20 minutes what i couldnt figure out all day from all the top hits that came back when i searched primary/foreign keys

  • @젤린-t2u
    @젤린-t2u 3 роки тому +5

    I'm not a native English speaker
    Usually don't leave comments
    This is just perfect Crystal clear

  • @davidlp3019
    @davidlp3019 3 роки тому +6

    From a computer science student here in Sydney Australia. Thank you for making this video. It was extremely helpful. Combined with the lectures from uni I now understand what a primary/foreign key is.

  • @miriamlira8653
    @miriamlira8653 3 роки тому +9

    3 months in 25 minutes . Thank you !!!! I LOVE YOUR VIDEOS

  • @robertue1
    @robertue1 3 роки тому +3

    Great video! Really well explained. The only part where I got a little bit lost was you explained about the symbols use to express the relation between the tables and the specified directions by the end of the video.

  • @MrJrhzues
    @MrJrhzues Рік тому

    THANK YOU, HUMBLED BY THIS KNOWLEDGE, I'M JUST EMBARKING ON MY NEW CAREER PATH AND AM LEARNING THIS GROUND UP.

  • @dariaverkhovykh5138
    @dariaverkhovykh5138 Рік тому

    GREAT!Easy to understand. Thank you

  • @MrPlamor
    @MrPlamor 2 роки тому +2

    i am in love with sql video oh lawrdy

  • @nyoreachoja2068
    @nyoreachoja2068 3 роки тому +1

    This video is perfection! Thanks for making everything clear and simple.

  • @forestsunrise26
    @forestsunrise26 3 роки тому +3

    woow excellent explanation!!! Thank you so much!

  • @elenaeftimita5494
    @elenaeftimita5494 2 роки тому

    One of the best explanation I have seen after whole day of searching for someone to explain SQL for very biginners. Thank you very much!

  • @chutimonnamboonlue5063
    @chutimonnamboonlue5063 2 роки тому

    This video really helps me a lot! Thank you!

  • @reemdabees3516
    @reemdabees3516 2 роки тому

    This video is very much helpful, clear and simple thank you a lot .

  • @mohamadmoradi9350
    @mohamadmoradi9350 3 роки тому

    it was the best explanation I ever see! thank you.

  • @agar.iodestiny8677
    @agar.iodestiny8677 3 роки тому

    Extremely useful video!!
    Thank you!!

  • @attiqurrehman4142
    @attiqurrehman4142 2 роки тому

    Easily keep quiet catch your words there is no doubt P.key & F.key related is the best video in the whole youtube. hats off you sir 🥰

  • @ninadias8083
    @ninadias8083 4 роки тому +3

    Amazing explanation!

  • @cyberplayer1484
    @cyberplayer1484 2 роки тому

    Very detailed and awesome teaching method I enjoyed watching it :)

  • @pranavkulkarni4307
    @pranavkulkarni4307 2 роки тому

    Very informative thank you!!!

  • @mastinasgaci8819
    @mastinasgaci8819 4 роки тому +1

    thank you

  • @ayda1708
    @ayda1708 3 роки тому +1

    this is amazng!

  • @societedhistoiredelabaie-j2839
    @societedhistoiredelabaie-j2839 2 роки тому

    very clear

  • @merrrymonroe218
    @merrrymonroe218 2 роки тому

    thank you for such great video

  • @AusticHardOfHearingSinger
    @AusticHardOfHearingSinger 4 роки тому +1

    Great info and explanations. Please tell me more about Cardinality Constraints.

  • @Daniel14Mejia
    @Daniel14Mejia 3 роки тому +2

    16:37 !!!!!! Why is it possible not to register who made a purchase on the sales table? how can we leave the customer_id space in blank? if we dont have the customer_id on the sales table would the system know where to send the package? i dont get that part sorry guys

  • @danilo-arantzibia
    @danilo-arantzibia 3 роки тому

    Thank you!

  • @vovaka440
    @vovaka440 3 роки тому

    Great work! Thank you for this! :)

  • @mahibalay
    @mahibalay 3 роки тому +1

    Fabulous

  • @truetreasuretalks
    @truetreasuretalks 3 роки тому

    Bravo!!!thank you

  • @Cell4TR
    @Cell4TR 4 роки тому +1

    That was clear.

  • @shamaelsaigal1173
    @shamaelsaigal1173 5 років тому +3

    never thought i could understand data

  • @AhmedRayyan284
    @AhmedRayyan284 3 роки тому

    thanks a lot

  • @lazivietboiz
    @lazivietboiz 4 роки тому

    Thank you very much!

  • @sunira464
    @sunira464 5 років тому

    lovely teaching...

  • @heatherrobbins6240
    @heatherrobbins6240 4 роки тому

    Very helpful, thank you

  • @tassiblezilundu7602
    @tassiblezilundu7602 3 роки тому

    I got the point but the thing is how do those foreign key get to access values from it's primary key table in the prepared statement

    • @daughterofzion3884
      @daughterofzion3884 3 роки тому

      The FK gets access because they have a "common" key, which opens the way to get multiple info when INPUTING column names(from both sides) in select statements. It will show up the results , because you used the PK, in addition to both tables in your select stat.

  • @testa3014
    @testa3014 3 роки тому

    is it possible to change the pk name of one table when writing it in the next table

    • @daughterofzion3884
      @daughterofzion3884 3 роки тому

      No, because if you do that the primary key ID will not match, which will mean you'll get an error in your syntax.

  • @danablum7653
    @danablum7653 2 роки тому

    How do we see the answers? :)

  • @andreranulfo-dev8607
    @andreranulfo-dev8607 4 роки тому

    24:20 Great!

  • @hereigoagain5050
    @hereigoagain5050 2 роки тому

    "Please don't worry. We will not bother you with math." :)

  • @smacdsmaccers
    @smacdsmaccers 2 роки тому

    Dammnit
    I got distracted again
    All i saw was green mickey mouse