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

Enrol Now - Select a section to enrol in

Type
Class
Days
Th
Time
6:00PM to 9:00PM
Dates
Sep 19, 2019 to Nov 21, 2019
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook
No Required Textbook
Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course

Type
Online Synchronous
Days
T
Time
6:00PM to 9:00PM
Dates
Jan 14, 2020 to Mar 17, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook
No Required Textbook
Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, a headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Required fields are indicated by .