top of page
programming-background-with-person-working-with-codes-computer.jpg

Datamodellering

Behärska de tekniker som behövs för att bygga datamodeller för din organisation.

Tillämpa viktiga designprinciper för datamodellering genom både klassisk entitetsrelationsnotation och "kråkafotsnotation". Bygg semantiskt korrekta datamodeller bestående av entiteter, attribut, relationer, hierarkier och andra modelleringskonstruktioner.

  • Creating a Data Model in visio

  • Create logical data model in ER studio

  • Identifying and Non-identifying ER Studio

  • Naming Standards ER Studio

  • Create Physical Model in ER studio

  • Creationg Objects and Data Modeling Relationships

  • DM Relationships

  • Identifying Relationships

  • Create Objects in Data Model

  • Cardinality & Non-identifying

  • Supertype and subtype

  • Data Modeling Types

  • Concept Data Modeling

  • Enterprise Data Modeling

  • Logical Data Modeling

  • Physical Data Modeling

  • Relationship(OLTP)Data Modeling

  • Dimensional Data Modeling

  • Logical vs Physical Data Modeling

  • Relational(OLTP) vs Dimensional

  • Compare Data Models and 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

  • Snowflakes schema

  • Fact table

bottom of page