Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key

17759
32
415
17.01.2021
Tech Coach

Tech Coach

2473518
29900
178
27.12.2014
IN
Описание видео:

There are way too many keys in DBMS and at times it is confusing to differentiate them on a high level. This video clarifies all your doubts related to keys. The video is part of the normalization series, Please watch these videos as well for better understanding on the entire concept. The video is the 5th video in the video series of Normalization. Here is the link to the 1st Video - normalization 🤍🤍youtube.com/watch?v=oDZUV... Here is the link to the 2nd Video - 1st Normal form 🤍🤍youtube.com/watch?v=RyqhX... The 2nd Normal focus on No Partial Dependency. Here is the link to the 3rd Video - 2nd Normal form 🤍youtu.be/ShNshBTtrYc The 3rd Normal focus on the transitive dependency. 🤍🤍youtube.com/watch?v=tJtZLJ-EFrE #Keys #NormalizationSeries #TechCoach

Кадры из видео
Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key
Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key
Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key
Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key
Тэги из видео
Комментарии пользователей:
TOP5
2022-12-10 03:49:17

Wow nice 👍

Kamran Khan
2022-06-25 21:42:44

You sir are outstanding with the explanations. Thank you

Michał Fabich
2022-06-16 11:56:45

best explanation of topic I've ever came across

Late Developer
2022-06-07 15:16:11

1obYexonVDo&t=3m00s 3:00 Super key definition - just what I came for and much better than my lecturer's explanation. Thanks.

John williams
2022-02-02 19:51:03

Thanks for using a databse table as an example to explain the topic.

Sheetal Jaiswal
2021-12-22 20:33:51

very nicely explained

KA
2021-10-17 21:27:33

Best explanation thank you so much! My professor should learn from you.

Suraj Patil
2021-10-14 03:43:50

For validations of scd2 {historical records} what will be the query/ approach?

shreya diwaker
2021-10-07 09:48:47

what is the difference between natural and candidate key ? both of them are used to uniquely identify record in table and there can be more than 1 natural and candidate key.

Jyoti Kothari
2021-09-24 15:31:26

Good explaination..

Tanushree Nagar
2021-09-21 07:29:15

Thank you 😊

aditi shree
2021-07-30 11:30:52

very understanding video. can you please give the answer of the table you dropped for normalizing.

TechnicalLearning_Npandit
2021-06-26 11:11:28

Super explained bro
.

dhaval pandya
2021-02-15 16:24:18

Hello sir,
Could you please explain us on explain plan for a complex query that have some with cluase and all. actually for small query I can understand the plan but if the query is too complex how we can start understanding the explain plan ?
Thank you

Что ищут прямо сейчас
PGPS 4 soundpad cracked zaari abdelkader Mo five Obb service is running problem Смена Imei Arizona RP Mesa Realme c31 pubg laxmi Bhandar form fill up hevc video player android games mod fbo Rbl bank share review Symfony CRUD Медведева Азамат 靜豬 фигурное катание Женя Медведева flask crud app 萬仞
Похожие видео
17.01.2021
Normalization Practice Exercise | Third Normal Form| Denormalization

Normalization Practice Exercise | Third Normal Form| Denormalization

21.11.2021
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

18.09.2022
Super Key vs Candidate Key vs Primary Key. Understand the difference.

Super Key vs Candidate Key vs Primary Key. Understand the difference.

21.11.2019
Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS

Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS

01.11.2019
Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc

Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc

03.01.2023
To Surrogate Key or Not...

To Surrogate Key or Not...

24.08.2022
TYPES OF KEYS IN DBMS || SUPER KEY || CANDIDATE KEY || PRIMARY KEY || FOREIGN KEY || ALTERNATE KEY

TYPES OF KEYS IN DBMS || SUPER KEY || CANDIDATE KEY || PRIMARY KEY || FOREIGN KEY || ALTERNATE KEY

06.05.2020
Primary key and Surrogate key in DATABASE

Primary key and Surrogate key in DATABASE

25.07.2014
Database Design 25 - Surrogate Key and Natural Key

Database Design 25 - Surrogate Key and Natural Key

24.03.2022
Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More

Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More

12.03.2016
Candidate Key in DBMS (Candidate key, Primary Key, Foreign Key, Alternate Key, Super Key)

Candidate Key in DBMS (Candidate key, Primary Key, Foreign Key, Alternate Key, Super Key)

15.05.2021
What is Surrogate Key | Data Warehouse Tutorial For Beginners | Data Warehouse Concepts (13/30)

What is Surrogate Key | Data Warehouse Tutorial For Beginners | Data Warehouse Concepts (13/30)

25.07.2021
keys in SQL | DBMS Keys | Super keys | Candidate key | Primary key | Alternate key | Foreign key

keys in SQL | DBMS Keys | Super keys | Candidate key | Primary key | Alternate key | Foreign key

27.07.2019
Relational Database

Relational Database

14.10.2017
Why Surrogate Keys are used in Data Warehouse

Why Surrogate Keys are used in Data Warehouse