Loading...

Course Description

This course will introduce students to the various skills and techniques that are used to model relational databases. Also, students will learn data modelling techniques and methodologies that are used to build the conceptual, logical and physical schemas in a technology agnostic manner that will define the data elements along with the structures and relationships between them.


Course Details

Data modelling is a process used to define and analyze the data requirements in an IT project with the end result being a data model that can accurately describe the structure, manipulation and integrity aspects of the data stored within relational databases.

This course is for both business and IT professionals including business analysts, database developers and administrators, software developers, data warehouse and business intelligence developers, and project managers.


Course Level Learning Outcomes

By completion of this course, successful students will be able to:

  • Understand basics of the DAMA DM-BOK guidelines for Data Modelling
  • Create three distinct levels of data models
  • Apply data modelling skills to practical situations
  • Understand metadata and its purpose

Topics of Instruction

  • Introduction to the practice of data modelling
  • Reasons to create data models
  • The conceptual data model
  • The logical data model
  • The physical data model
  • Relationships & Data Integrity
  • Data model patterns & the normal forms
  • The dimensional data model

Applies Towards the Following Certificate(s)

Loading...

Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrolment. Please complete a course inquiry so that we may promptly notify you when enrolment opens.

Required fields are indicated by .