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

Notes

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

Applies Towards the Following Program(s)

Loading...

Thank you for your interest...

Unfortunately, this course is not currently open for enrolment.

If you have a Professional and Continuing Education account, take note of the course number and submit a course inquiry to be notified if new sections become available.

Questions?

Required fields are indicated by .