Data Modeling and Relational Database Design using ERwin
4.2 (68 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
323 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Modeling and Relational Database Design using ERwin to your Wishlist.

Add to Wishlist

Data Modeling and Relational Database Design using ERwin

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs
4.2 (68 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
323 students enrolled
Created by Haris Kilikotu
Last updated 6/2017
English
Current price: $10 Original price: $50 Discount: 80% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Data Modelers
  • Data Architects
  • Database administrators
  • ETL developers
  • DWH/BI professionals
  • Software Engineers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
03:30:34
+
Introduction
5 Lectures 17:22



Download and Install ERwin software
03:06

ERwin workspace - Model, Subject Areas and Diagrams
04:28
+
Relationships
4 Lectures 26:53
Relationships - Identifying and Non Identifying
05:05

Relationships - Recursive relationships
05:10

Relationships - Super types and Sub types
03:06

Relationships - Sub types transformations
13:32
+
Data Modeling Exercise
1 Lecture 15:34
Data Modeling Exercise - Retail banking system
15:34
+
ERwin Core Features
10 Lectures 59:44
Diagrams - How to create diagrams with different display elements
09:17

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

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

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

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

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

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

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

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

Reporting and Publishing - HTML and PDF export with diagrams
10:18
+
Dimensional Modeling
4 Lectures 52:54

Creating a star schema - retail sales
18:25

Documenting Source to Target mappings and ETL rules
18:09

Publishing Source to Target mappings and ETL Rules
15:09
+
Normalization
6 Lectures 34:39
Normalization - Introduction
05:38

Normalization - First Normal Form Part1
04:08

Normalization - First Normal Form Part2
02:50

Normalization - Second Normal Form
06:30

Normalization - Third Normal Form
06:53

Normalization - BCNF
08:40
+
Student Exercises
2 Lectures 03:32
Logical data modeling practice - Public Library
00:26

Logical data modeling practice - Transportation services
03:06
About the Instructor
Haris Kilikotu
4.2 Average rating
67 Reviews
323 Students
1 Course
Developer | Architect | Product Manager

Expert in conceptual, logical and physical data modeling techniques to build sound relational database designs. More than a decade of experience with ERwin Data Modeler in various capacities (Developer, Architect, Development Manager, and Principal Product Manager)

A skilled practitioner who can understand business problems, conceptualize solutions, and translate them into powerful software with the help of both Waterfall and Agile delivery models.

Areas of interest: Software product design, development and research.

Extensive experience in delivering technology training to software engineers and data architects.