Mastering Data Modeling Fundamentals

Entity-Relationship Techniques and Best Practices

Created by: Alan Simon
Thought leader in business intelligence and enterprise data

What Will I Learn?

• Master the techniques needed to build data models for your organization.
• Apply key data modeling design principles through both classic entity-relationship notation and the “crow’s foot” notation.
• Build semantically accurate data models consisting of entities, attributes, relationships, hierarchies, and other modeling constructs.
• Convert conceptual data models to logical and physical data models through forward engineering.

Requirements

• Students only need a basic understanding of data management concepts and constructs such as relational database tables and how different pieces of data logically relate to one another. The course content builds on these rudimentary ideas; no other prerequisites are needed.

Target audience

• A business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data modeling, who desires to build a personal toolbox of data modeling best practices and techniques.
• After completing this course, you will be ready to begin working on real-world data modeling projects, either with expanded responsibilities as part of an existing role or to find a new position involving data modeling. Example positions include database designer, conceptual data modeler, database engineer, and business analyst with an emphasis on data requirements.