IIRF Online > Business > Business Analytics & Intelligence > Data Modeling > Data Modeling and Relational Database Design using ERwin
Data Modeling and Relational Database Design using ERwin by Udemy
Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs
Course Highlights
- Create Entity Relationship Diagrams by identifying entities, attributes, relationships and constraints from a set of requirements
- Normalize the Entity Relationship Diagram to third Normal form
- Develop sound database designs by applying proven data modeling techniques
- Engineer/Re-engineer the data Models into and from relational database designs
- Optimize the Relational Database Design for various functional/non functional requirements
- Work with database change requests and maintain existing databases with the help of tools.
- Develop data models using ERwin Data Modeler
Skills you will learn!
Curriculum
5 Topics
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
4 Topics
Relationships - Identifying and Non Identifying
Relationships - Recursive relationships
Relationships - Super types and Sub types
Relationships - Sub types transformations
1 Topic
Data Modeling Exercise - Retail banking system
10 Topics
Diagrams - How to create diagrams with different display elements
Domain Dictionary - How to use domain objects in model
Bulk Editor - How to edit definition of all entities/tables
Forward Engineering - How to generate database schema from model
Reverse Engineering - Creating a data model from 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
4 Topics
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
6 Topics
Normalization - Introduction
Normalization - First Normal Form Part1
Normalization - First Normal Form Part2
Normalization - Second Normal Form
Normalization - Third Normal Form
Normalization - BCNF
4 Topics
Logical data modeling practice - Public Library
Public Library : Solution
Logical data modeling practice - Transportation services
Transportation Services : Solution
Data Modeling and Relational Database Design using ERwin
Related Data Modeling Courses
Thank You!
Your review has been submitted successfully.