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.
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)
- Certificate in Business Analysis : Optional Courses
- Certificate in Business Intelligence and Analytics : Optional Courses
- Certificate in IT Fundamentals : Core Courses