Select Page

Data Models

The module explains the conceptual, logical and physical data models with industry examples of each given.

The relationship types between the attributes contained within a model is also explained.

The key roles of data modelling such as a database administrator (DBA) and data modeller are detailed in the module.

Data Models

Learning Objectives:

Learn what a conceptual data model is.

Learn what a logical data model is.

Learn what a physical data model is.

Learn what one to one (1:1), one to many (1:M) and many to many (M:M) relationships are.

Learn the role of a Database administrator (DBA).

Learn the role of a data modeller.

Who is Suitable?

Knowledge of what Data Modelling is would be advantageous.

This module would be useful for a wide range of data roles; including but not exclusive to data owners, data stewards, data architects and data lineage analysts.

As this is a data understanding module it is especially useful for data analysts and data modellers.

Videos:

  • Why do we have 3 types of models?
  • Can you give an example of a 1 to 1, 1 to M and M to M relationship?
  • In what order are the data models created and why?
  • What are Primary and foreign keys?
  • What does the DBA do?

Contents:

An Interactive Presentation

5 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