Relational Data Modeling

Develop practical data modeling experience in using structured analysis techniques and standard (Oracle) notation for entity-relationship diagramming to document enterprise-wide data requirements. This class focuses on the skills of data analysis and data modeling, and is not a tools class. Data modeling problems of increasing complexity are given in class exercises and workshops, and modeled with pen and paper. Lectures are followed by training workshops, with hands-on (paper-based) data modeling exercises.
Before taking this course, students should possess previous data analysis experience.
3 Days/Lecture & Lab
This course is designed for business analysts, subject matter experts, data analysts, and modelers seeking hands-on training in using basic data modeling techniques.
  • Introduction to Data Analysis and Data Modeling
  • Standards for Drawing Entity-Relationship Diagrams
  • Hands-on Relational Data Modeling Training Exercises
  • Workshop on Analysis of Divergent Models
  • Workshop on Model Convergence Ideas
  • Subtype vs. Arc Implementation Options
  • Quality Assurance Tips
  • Workshop on Quality Assurance of Selected Models

Related Scheduled Courses