Data Modeling for Databases and Data Warehouses

This course provides participants with the skills necessary to design models for efficient and effective databases. Students learn to create Conceptual, Logical, Dimensional and Physical Models after gathering and defining the data requirements of an organization. Data element analysis, standardization, identifying candidate keys and recommended practices are included in this course. Normalization will be covered in detail as well as other major topics that include how to fully populate attributes to be implemented and define those attributes in terms of their domains or logical data types. ERWin modeling tool will be used for the labs and demos.The physical database can be DB2, Sybase, Oracle or SQL Server. (Note current outline is for Oracle).
Prior to taking this course, students should have basic database knowledge.
3 Days/Lecture & Lab
This course is designed for Business Analysts, Project Managers, DBAs and SQL Programmers who need to understand how to design models for efficient and effective databases.
  • Data Modeling
  • Business Requirements
  • Conceptual Modeling
  • Logical Modeling
  • Relationships
  • Normalization
  • Dimensional Data
  • Conceptual Dimensional Model
  • Logical Dimensional Model
  • Physical Modeling Oracle
  • Baseline Tables
  • Physical Dimensional Model
  • Other Techniques
  • reFactor / reDesign

Related Scheduled Courses