Primary Key and Foreign Key Tutorial in MySQL | What is Primary Key and Foreign Key DBMS | Edureka

๐Ÿ”ฅ ๐„๐๐ฎ๐ซ๐ž๐ค๐š ๐๐ฎ๐ฌ๐ข๐ง๐ž๐ฌ๐ฌ ๐ˆ๐ง๐ญ๐ž๐ฅ๐ฅ๐ข๐ ๐ž๐ง๐œ๐ž ๐Œ๐š๐ฌ๐ญ๐ž๐ซ๐ฌ ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž Visit: www.edureka.co/masters-progra... (Use Code "๐˜๐Ž๐”๐“๐”๐๐„๐Ÿ๐ŸŽ")
This Edureka video on "Primary Key and Foreign Key in MySQL '' will introduce you to the concept of Primary Key and Foreign Key with a hands-on demo on MySQL Workbench. We will discuss the Syntax with examples and understand how to create a table with Primary Key and Foreign Key restrictions. If you have any queries, please mention in the comment section below and let us know if you have any more points to add in this video.
Following pointers are covered in this Primary Key and Foreign Key in MySQL video:
00:00 Introduction
00:26 Agenda
00:42 What is Primary Key?
01:03 Example of Primary Key
02:00 Syntax
02:49 What is Foreign Key?
03:08 Example of Foreign Key
04:07 Syntax
04:53 Hands-on Tutorial on Primary Key and Foreign Key
๐Ÿ”ดSubscribe to our channel to get video updates. Hit the subscribe button above: goo.gl/6ohpTV
--------๐„๐๐ฎ๐ซ๐ž๐ค๐š ๐Ž๐ง๐ฅ๐ข๐ง๐ž ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  ๐š๐ง๐ ๐‚๐ž๐ซ๐ญ๐ข๐Ÿ๐ข๐œ๐š๐ญ๐ข๐จ๐ง--------
๐Ÿ”ต DevOps Online Training: bit.ly/3lSnPe5
๐ŸŒ• AWS Online Training: bit.ly/336fsVt
๐Ÿ”ต Data Science Online Training: bit.ly/33iRHtz
๐ŸŒ• Tableau Online Training: bit.ly/3lVbrK2
๐Ÿ”ต Power BI Online Training: bit.ly/3s2nM3e
๐ŸŒ• Selenium Online Training: bit.ly/3dF0lo6
๐Ÿ”ต PMP Online Training: bit.ly/3EK1XsC
๐ŸŒ• Salesforce Online Training: bit.ly/3DUaxUm
๐Ÿ”ต Cybersecurity Online Training: bit.ly/3yjFhwS
๐ŸŒ• Java Online Training: bit.ly/3ybYe4s
๐Ÿ”ต Big Data Online Training: bit.ly/3yfbZiV
๐ŸŒ• RPA Online Training: bit.ly/3rRMDq6
๐Ÿ”ต Python Online Training: bit.ly/3GwDmrB
๐ŸŒ• Azure Online Training: bit.ly/3GvMIUG
๐Ÿ”ต GCP Online Training: bit.ly/3ELEVl7
๐ŸŒ• Microservices Online Training: bit.ly/3INZJuw
--------๐„๐๐ฎ๐ซ๐ž๐ค๐š ๐‘๐จ๐ฅ๐ž-๐๐š๐ฌ๐ž๐ ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž๐ฌ--------
๐Ÿ”ต DevOps Engineer Masters Program: bit.ly/3EIRzRL
๐ŸŒ• Cloud Architect Masters Program: bit.ly/3pNruuu
๐Ÿ”ต Data Scientist Masters Program: bit.ly/3lS75Uf
๐ŸŒ• Big Data Architect Masters Program: bit.ly/3ycCLIT
๐Ÿ”ต Machine Learning Engineer Masters Program: bit.ly/3yc8xFU
๐ŸŒ• Business Intelligence Masters Program: bit.ly/3yhQbU2
๐Ÿ”ต Python Developer Masters Program: bit.ly/3EK3IpI
๐ŸŒ• RPA Developer Masters Program: bit.ly/3dKGVxX
๐Ÿ”ต Web Development Masters Program: bit.ly/3lP5zBZ
๐ŸŒ• Computer Science Bootcamp Program : bit.ly/3oQa2ql
๐Ÿ”ต Cyber Security Masters Program: bit.ly/3yaJu64
๐ŸŒ• Full Stack Developer Masters Program : bit.ly/3DOtCra
๐Ÿ”ต Automation Testing Engineer Masters Program : bit.ly/3qasDgf
๐ŸŒ• Python Developer Masters Program : bit.ly/3EK3IpI
๐Ÿ”ต Azure Cloud Engineer Masters Program: bit.ly/3s2aFz4
-------๐„๐๐ฎ๐ซ๐ž๐ค๐š ๐๐—ผ๐˜€๐˜ ๐—š๐—ฟ๐—ฎ๐—ฑ๐˜‚๐—ฎ๐˜๐—ฒ ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž๐ฌ-------
๐Ÿ”ต Artificial and Machine Learning PGD with E & ICT Academy NIT Warangal: bit.ly/3oFXamf
๐ŸŒ• Post Graduate Program in DevOps with Purdue University: bit.ly/31KHDsZ
#SQL #SQLSERVER #MYSQL #Edureka #MYSQLWORKBENCH #CREATETABLE #CREATETABLEINMYSQL #SQLTUTORIAL #MYSQLTUTORIAL
๐Ÿ“ข๐Ÿ“ข ๐“๐จ๐ฉ ๐Ÿ๐ŸŽ ๐“๐ซ๐ž๐ง๐๐ข๐ง๐  ๐“๐ž๐œ๐ก๐ง๐จ๐ฅ๐จ๐ ๐ข๐ž๐ฌ ๐ญ๐จ ๐‹๐ž๐š๐ซ๐ง ๐ข๐ง ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ ๐’๐ž๐ซ๐ข๐ž๐ฌ ๐Ÿ“ข๐Ÿ“ข
โฉ๐“๐จ๐ฉ ๐Ÿ๐ŸŽ ๐“๐ž๐œ๐ก๐ง๐จ๐ฅ๐จ๐ ๐ข๐ž๐ฌ ๐ญ๐จ ๐‹๐ž๐š๐ซ๐ง ๐ข๐ง ๐Ÿ๐ŸŽ๐Ÿ๐Ÿฎ: bit.ly/3yhEs7S
โฉ๐“๐จ๐ฉ ๐Ÿ๐ŸŽ ๐‡๐ข๐ ๐ก๐ž๐ฌ๐ญ ๐๐š๐ฒ๐ข๐ง๐  ๐‰๐จ๐›๐ฌ ๐…๐จ๐ซ ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ: bit.ly/3HcpPG6
โฉ๐“๐จ๐ฉ ๐Ÿ๐ŸŽ ๐๐ซ๐จ๐ ๐ซ๐š๐ฆ๐ฆ๐ข๐ง๐  ๐‹๐š๐ง๐ ๐ฎ๐š๐ ๐ž๐ฌ ๐Ÿ๐จ๐ซ ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ: bit.ly/3FW6F69
โฉ๐“๐จ๐ฉ ๐Ÿ๐ŸŽ ๐‚๐ž๐ซ๐ญ๐ข๐Ÿ๐ข๐œ๐š๐ญ๐ข๐จ๐ง๐ฌ ๐Ÿ๐จ๐ซ ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ: bit.ly/3gH57mr
๐Ÿ“Œ๐“๐ž๐ฅ๐ž๐ ๐ซ๐š๐ฆ: t.me/edurekaupdates
๐Ÿ“Œ๐“๐ฐ๐ข๐ญ๐ญ๐ž๐ซ: / edurekain
๐Ÿ“Œ๐‹๐ข๐ง๐ค๐ž๐๐ˆ๐ง: / edureka
๐Ÿ“Œ๐ˆ๐ง๐ฌ๐ญ๐š๐ ๐ซ๐š๐ฆ: / edureka_learning
๐Ÿ“Œ๐…๐š๐œ๐ž๐›๐จ๐จ๐ค: / edurekain
๐Ÿ“Œ๐’๐ฅ๐ข๐๐ž๐’๐ก๐š๐ซ๐ž: www.slideshare.net/EdurekaIN
๐Ÿ“Œ๐‚๐š๐ฌ๐ญ๐›๐จ๐ฑ: castbox.fm/networks/505?count...
๐Ÿ“Œ๐Œ๐ž๐ž๐ญ๐ฎ๐ฉ: www.meetup.com/edureka/
๐Ÿ“Œ๐‚๐จ๐ฆ๐ฆ๐ฎ๐ง๐ข๐ญ๐ฒ: www.edureka.co/community/
Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.

ะŸั–ะบั–ั€ะปะตั€: 24

  • @edurekaIN
    @edurekaIN2 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Got a question on the topic? Please share it in the comment section below. For Edurekaโ€™s BI Masters Certification Training, Please Visit our Website bit.ly/3kfHR1G Use code "KZread20" to get Flat 20% off on this training.

  • @hasanmougharbel8030
    @hasanmougharbel8030 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Hey there, kudos to your great efforts. I have a simple enquiry as an newbie sql learner. Why cant i have more than one primary key in a single table? Thanks for taking care of this.

  • @sazidabdul7471
    @sazidabdul7471 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    I was searching for this and checked several videos your explanation was simple n superb.

  • @edurekaIN

    @edurekaIN

    ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Thank you so much ๐Ÿ™‚ Glad it was helpful!

  • @shaktidev1965
    @shaktidev1965 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    As a beginner to sql i can this is the best video for understanding foreign key and primary key.

  • @edurekaIN

    @edurekaIN

    ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )

  • @sachinkumarg8885
    @sachinkumarg88852 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Thanks a lot.

  • @nanda9395
    @nanda9395 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    This video is helpful to beginners in DB.

  • @edurekaIN

    @edurekaIN

    ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Thank you ๐Ÿ˜Š Glad it was helpful!! Keep learning with us

  • @bestofmusicc__
    @bestofmusicc__ ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Hi thnks for this video, please provide its second video where you were about to tell about how to join those tables.

  • @edurekaIN

    @edurekaIN

    ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update

  • @siege26
    @siege26 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    ๐Ÿ”ฅthanks

  • @fernandai.b.140
    @fernandai.b.1402 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Thanks! a useful video

  • @edurekaIN

    @edurekaIN

    2 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Glad it helped you :)

  • @sundharkumar1
    @sundharkumar1 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    i am a beginner, Could you please tell me what's the use of foreign key and primary key??

  • @ravindrawaghela6129
    @ravindrawaghela61297 ะฐะน ะฑาฑั€ั‹ะฝ

    Nicely explained. ! Helped me a lot

  • @edurekaIN

    @edurekaIN

    7 ะฐะน ะฑาฑั€ั‹ะฝ

    Glad it helped

  • @sriramch3128
    @sriramch31282 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Always edurekha

  • @adwjunk1adwjunk15
    @adwjunk1adwjunk152 ะถั‹ะป ะฑาฑั€ั‹ะฝ

    Which one is better: one single surrogate key, or multiple primary key?

  • @muhammedriyas2107
    @muhammedriyas2107 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    ๐Ÿ‘

  • @Sidra--
    @Sidra--7 ะฐะน ะฑาฑั€ั‹ะฝ

    thank you

  • @edurekaIN

    @edurekaIN

    7 ะฐะน ะฑาฑั€ั‹ะฝ

    You're welcome

  • @kajal_2501
    @kajal_2501 ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    Thanks mam ๐Ÿ˜Š

  • @edurekaIN

    @edurekaIN

    ะ–ั‹ะป ะฑาฑั€ั‹ะฝ

    You're Welcome ๐Ÿ˜Š Glad it was helpful!!

ะšะตะปะตัั–