Datamodeling Course

  1. Home
  2. Data-modeling
  3. Datamodeling Course

Tags: Data Modeling

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs

Last updated 2022-01-10 | 4.4

- 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

What you'll learn

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

* Requirements

* SQL RDBMS

Description

The data model is the one place where you can store all the relevant information about a data asset (definitions, structure, relationships, integration points etc) and deliver it in a visual and contextually appropriate format for stakeholders involved in the management and consumption of data.

The course will help you learn how to develop data models and maintain them with the help of popular data modeling tool ERWIN. We will discuss various data modeling techniques with the help of appropriate modeling scenarios and make you ready to take up complex data modeling challenges and become an effective data architect. The tools and techniques demonstrated in this course are equally applicable to OLTP & OLAP databases.

Who this course is for:

  • Data Modelers
  • Data Architects
  • Database administrators
  • ETL developers
  • DWH/BI professionals
  • Business Analysts

Course content

7 sections • 34 lectures

Introduction 5 lectures

What is data modeling? Preview 02:11

Entity Relationship Model Preview 05:35

Notation - Information Engineering(IE) basic symbols Preview 06:09

Download and Install ERwin software Preview 03:06

ERwin workspace - Model, Subject Areas and Diagrams Preview 04:28

Relationships 4 lectures

Relationships - Identifying and Non Identifying Preview 05:05

Relationships - Recursive relationships Preview 05:10

Relationships - Super types and Sub types Preview 03:06

Relationships - Sub types transformations Preview 13:32

Data Modeling Exercise 1 lectures

Data Modeling Exercise - Retail banking system Preview 15:34

ERwin Core Features 10 lectures

Diagrams - How to create diagrams with different display elements Preview 09:17

Domain Dictionary - How to use domain objects in model Preview 09:59

Bulk Editor - How to edit definition of all entities/tables Preview 03:28

Forward Engineering - How to generate database schema from model Preview 03:58

Reverse Engineering - Creating a data model from database Preview 03:00

Naming Standards - Name settings and attaching business glossary Preview 03:57

Complete Compare - Compare models and import/export differences Preview 06:22

Reporting and Publishing - How to export diagram images Preview 03:54

Reporting and Publishing - Entity report using Report Designer Preview 05:31

Reporting and Publishing - HTML and PDF export with diagrams Preview 10:18

Dimensional Modeling 4 lectures

What is dimensional modeling Preview 01:11

Creating a star schema - retail sales Preview 18:25

Documenting Source to Target mappings and ETL rules Preview 18:09

Publishing Source to Target mappings and ETL Rules Preview 15:09

Normalization 6 lectures

Normalization - Introduction Preview 05:38

Normalization - First Normal Form Part1 Preview 04:08

Normalization - First Normal Form Part2 Preview 02:50

Normalization - Second Normal Form Preview 06:30

Normalization - Third Normal Form Preview 06:53

Normalization - BCNF Preview 08:40

Student Exercises 4 lectures

Logical data modeling practice - Public Library Preview 00:26

Public Library : Solution Preview 00:28

Logical data modeling practice - Transportation services Preview 03:02

Transportation Services : Solution Preview 02:51