| 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
Domains, Defaults & Check Constraints
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
|
|
| Creating Objects & Data Modeling Relationships |
|
DM Relationships
Create objects in Data Model
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 & create DDL scripts
|
|
| Physical Data Modeling |
|
DDL Scripts from Data Model
|
|
|
Reverse Engineering a Data Model
|
|
| Modeling Data Warehouse and Data Mart |
|
Data Warehouse and Data Mart
Dimensions
Slowly Changing Dimensions
|
|
|
Star Schema
Snowflake Schema
Fact Table
|
|
| Interview Questions |
|
|
|