Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video,
log in, then visit the video's
detail page and click "download". This is a subscriber-only video so a
subscription is required.
Note: You must have the TSCC codec installed to view this video
Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constraint