Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More
An easy-to-follow tutorial covering the whole gamut of RDBMS keys: primary keys, candidate keys, superkeys, alternate keys, foreign keys, surrogate keys, natural keys, simple keys, composite keys, compound keys, and intelligent keys. Featuring lots of examples and a focus on the design process.
👉📘Download the FREE PDF (Decomplexify Quick Reference Guide), with cheat sheets covering 1st, 2nd, and 3rd Normal Form, plus Entity Relationship Diagram (ERD) conventions:
https://decomplexify.myflodesk.com/wm...
🔥🎥 Got a database schema that feels ‘off’? Send it in—I might feature it in a video where I pick it apart and show how I’d redesign it. (On my channel page, click on “More about this channel” → “View email address”.)
CONTENTS
0:00 Introduction
0:53 Primary Keys
3:29 Candidate Keys
6:09 Superkeys
7:57 Alternate Keys
8:49 Foreign Keys
10:39 Surrogate vs. Natural Keys
16:55 Composite vs. Simple Keys
18:02 Compound Keys
19:01 Intelligent Keys