MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Learning Data Modeling

Course Summary

A step by step guide to data modeling concepts and best practices underpinning sound database design.


  • +

    Course Syllabus

    • Getting Started
      • Important - Download These First - Working Files
      • About The Course
      • What Is A Database?
      • What Is A Data Model?
      • How To Access Your Working Files
    • Data Model Development Process
      • Data Model Inputs And Outputs
      • Data Model Notations
      • UML Versus IE - Conceptual, Logical And Physical
    • Basic Data Modeling
      • Class And Attribute
      • Operation
      • Domain
      • Association
      • IE Entity Type And Relationship Type
      • Association Name
      • Association End
      • Multiplicity - UML
      • Multiplicity - IE
      • Generalization - UML
      • Generalization - IE
      • Abstract Versus Concrete Superclass
      • Practical Tips
      • Self Assessment Test
    • Advanced Data Modeling
      • Identity
      • Derived Data
      • Current Versus Historical Data
      • Association Class
      • Ordered Association
      • Qualified Association - UML
      • Qualified Association - IE
      • Large Taxonomies
      • Package
      • Abridged UML Metamodel
      • Abridged IE Metamodel
      • Modeling Pitfalls
      • Practical Tips
      • Self Assessment Test
    • Create A UML Data Model
      • Problem Statement
      • Finding Classes
      • Finding Associations - Part 1
      • Finding Associations - Part 2
      • Finding Generalizations
      • Iterating And Refining The Model - Part 1
      • Iterating And Refining The Model - Part 2
      • Adding Attributes
      • Cleaning Up Layout
      • Simplifying The Model
      • Evolving A Model - Part 1
      • Evolving A Model - Part 2
      • Enterprise Architect Techniques - Part 1
      • Enterprise Architect Techniques - Part 2
      • Enterprise Architect Techniques - Part 3
    • Translate A UML Data Model Into An IE Data Model
      • Creating Subject Areas
      • Creating Entity Types
      • Creating Domains
      • Adding Attributes - Part 1
      • Adding Attributes - Part 2
      • Creating Relationship Types - Part 1
      • Creating Relationship Types - Part 2
      • Creating Relationship Types - Part 3
      • Subtyping
      • Adding Alternate Keys
      • Cleaning Up The Layout
      • ERwin Techniques - Part 1
      • ERwin Techniques - Part 2
    • Model Quality
      • Model Quality
      • Normal Forms
      • Constraints
      • Hillard Graph Complexity
      • Hoberman Data Model Scorecard
    • Kinds Of Data Models
      • Operational Data Models
      • Enterprise Data Models
      • Data Warehouses - Part 1
      • Data Warehouses - Part 2
      • Data Warehouses - Part 3
      • Master Data Models
    • Database Design
      • Schema Adjustments
      • Attribute Details - Part 1
      • Attribute Details - Part 2
      • Attribute Details - Part 3
      • Primary And Alternate Keys
      • Indexes
      • Referential Integrity - Part 1
      • Referential Integrity - Part 2
      • Check Constraints - Part 1
      • Check Constraints - Part 2
      • Views
      • Other Aspects Of Design
      • Self Assessment Test
    • Create A SQL Server Database
      • Creating A New Database
      • Executing Schema
      • Inspecting Metadata
      • Loading Sample Data
      • Querying Sample Data
    • Create An MS-Access Database
      • Generating An ERwin Schema
      • Creating Tables
      • Creating Indexes
      • Creating Constraints And Default Values
      • Defining Foreign Keys
      • Creating Views
      • Loading Sample Data
      • Querying Sample Data
    • Software Engineering
      • Development Frameworks
      • Agile Data Modelling
      • Documenting A Model - Part 1
      • Documenting A Model - Part 2
      • Presenting A Model
    • Data Modeling Patterns
      • Overview
      • Tree - Hardcoded
      • Tree - Simple
      • Tree - Structured
      • Tree - Overlapping
      • Tree - Changing Over Time
      • Tree - Degenerate Node and Edge
    • Database Reverse Engineering
      • Motives
      • Comparison With Forward Engineering
      • Outputs
      • Inputs
      • Process
      • Principles
      • Example - Part 1
      • Example - Part 2
    • Conclusion
      • Wrap-Up


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top