Select Page

Data Keys

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.

Data 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.

Videos:

  • 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?

Contents:

An Interactive Presentation

7 Videos

60+ Questions

10+ Interactive Questions

3 Final Practice Tests – 30 questions over 30 minutes

Final Examination – 60 questions over 30 minutes

Certification

DQRB Certificate

 4 hours of learning materials to complete.

Valid for 24 months

Only £100.00 + VAT