Data Modeling and Relational Database Design using ERwin – Haris Kilikotu

Data Modeling and Relational Database Design using ERwin Description

Data Modeling and Relational Database Design using ERwin by Haris Kilikotu discusses various techniques that can instantly be applied to data and scenario modeling as well as the proper ways to prepare yourself as an effective data architect, ready to take up any data modeling challenges. The knowledge found within this course can also be used in OLTP & OLAP databases.

Here are what you will learn in this course:

• Introduction
  • What is data modeling
  • Entity Relationship Model
  • Notation – Information Engineering (IE) basic symbols
  • Download and Install ERwin software
  • ERwin workspace – Model, Subject Areas and Diagrams
• Relationships
  • Relationships – Identifying and Non Identifying
  • Relationships – Recursive relationships
  • Relationships – Supertypes and Subtypes
  • Relationships – Sub types transformations
• Data Modeling Exercise
  • Data Modeling Exercise – Retail banking system
• ERwin Core Features
  • Diagrams – How to create diagrams with different display elements
  • Domain Dictionary – How to use domain objects in a model
  • Bulk Editor – How to edit the definition of all entities/tables
  • Forward Engineering – How to generate a database schema from model
  • Reverse Engineering – Creating a data model from a database
  • Naming Standards – Name settings and attaching business glossary
  • Complete Compare – Compare models and import/export differences
  • Reporting and Publishing – How to export diagram images
  • Reporting and Publishing – Entity report using Report Designer
  • Reporting and Publishing – HTML and PDF export with diagrams
• Dimensional Modeling
  • What is dimensional modeling
  • Creating a star schema – retail sales
  • Documenting Source to Target mappings and ETL rules
  • Publishing Source to Target mappings and ETL Rules
• Normalization
  • Normalization – Introduction
  • Normalization – First Normal Form Part1
  • Normalization – First Normal Form Part2
  • Normalization – Second Normal Form
  • Normalization – Third Normal Form
  • Normalization – BCNF
• Student Exercises
  • Logical data modeling practice – Public Library
  • Public Library: Solution
  • Logical data modeling practice – Transportation services
  • Transportation Services: Solution