Erwin Data Modeler Training

Erwin Data Modeler Online Training

SQL Basics

  • Normalization
  • Relationships
  • Integrity constraints
  • Built in functions
  • Select statement
  • Joins
  • Sub Queries and concepts based on your need

T-SQL

  • Stored Procedures – examples with different scenarios
  • User defined functions – types – examples
  • Indexes – usage

Admin Related

Data Modeling

  • Conceptual data model
  • Logical data model – its rules
  • Physical data model – its rules
  • Forward Engineering
  • Reverse Engineering

Data Warehousing Concepts

  • Dimensions and its types
  • Facts and its types
  • Schemas
  • Terminology involved in data vault data model
  • hub
  • links
  • satellites

Case study discussion and implementation of it using ERWIN tool (installation)

  • sub types
  • super types

Generating SQL based on model and making DB Ready

  • Implementation of forward engineering
  • Implementation of reverse engineering

Dimension model case study discussion and implementation

Case studies 3 and 4 for assignment.

Hybrid data model and its use cases

Data vault data model and its use cases

Kimball vs. Inmon

Requirement gathering and data analysis

  • Data mapping document
  • ETL explanation with an example.

Interview questions on SQL and Data Modelling