The module describes what foreign and primary keys are, and why they are needed.
Illustrated industry examples of how data keys are used along with the concept of referential integrity are shown.
The module explains how composite keys can be used and the challenges that surround unique keys.
What are the benefits?
Learn what data keys are.
Learn why data keys are useful.
Learn about the following types of keys:
- Primary Key
- Foreign Key
- Composite Key
- Alternative Key
- Surrogate Key
- Natural Key
Who is Suitable?
No prior knowledge is required so all Data Practitioners can undertake the course.
As this is a data governance module the content is especially useful for data owners and stewards but would also be a useful for a wide spectrum of data roles; including but not exclusive to data analysts, data modellers, data architects and data lineage analysts.
- Why does a data table need at least one primary key?
- Why can a table have more than one foreign key?
- Can you explain referential integrity?
- What is auto-generation?
- What is the benefit to being able to join tables?
- What is meant by a “Primary Key”?
- How can data profiling help to identify primary keys?
An Interactive Presentation
10+ Interactive Questions
3 Final Practice Tests – 30 questions over 30 minutes
Final Examination – 60 questions over 30 minutes