You are here: Home Data Modeling Tutorial
Data Modeling Tutorial:
Data Modeling Tutorial section aims at educating the reader with the importance and necessities of data modeling in today's Business Intelligence world. Included are the different types and representation of data models, how to create data models and the tools used to create and manage data models, in easy-to-understand manner.
Explanations and details are provided from a data modeler perspective, like how a data modeler creates objects, relationships, sets standards, creates reports/DDL scripts, creates versions and how the data model can be implemented in a database by using various tools like erwin, toad, xcase and visio.
This data modeling tutorial section is grouped into different categories like overview, types, tools etc., to help benefit the beginner or the experienced in exploring the topics they need the most. Browse through the various data modeling topics listed below to learn more.
Data Modeling Overview:
Data Modeling Overview |
Data Modeling Development Cycle |
Steps to Create a Data Model |
Data Modeler Role |
Data Modeling Standards |
Data Modeling Objects |
Data Model Repository |
Data Model Versioning |
Data Modeling Reports
Data Modeling Tools:
Data Modeling Tools |
DM Tools: What to Learn? |
DM Tools - Erwin |
DM Tools - Xcase |
Visio & Data Modeling |
Create Data Model in Visio
Data Modeling Relationships:
DM Relationships |
Create objects in Data Model |
Domains, Defaults & Check Constraints |
Cardinality & Non-Identifying |
Identifying Relationship |
Supertype & Subtype
Data Modeling Types:
Conceptual Data Modeling |
Enterprise Data Modeling |
Logical Data Modeling |
Physical Data Modeling |
Relational(OLTP) Data Modeling |
Dimensional Data Modeling
Comparison:
Logical vs Physical DM |
Relational(OLTP) vs Dimensional |
Compare Data Models
Physical Data Modeling:
DDL Scripts from Data Model |
Reverse Engineering a Data Model
Modeling DW and Data Mart:
Data Warehouse and Data Mart |
Dimensions |
Slowly Changing Dimensions |
Star Schema |
Snowflake Schema |
Fact Table
Data Modeling Interview Questions:
DM Interview Questions
Data Modeling Overview