Data Modeling and Relational Database Design using ERwin
3,357 students enrolled
Data Modeling and Relational Database Design using ERwin
Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs
3,357 students enrolled
Current price: $34.99
Original price: $49.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 3.5 hours on-demand video
- 4 articles
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
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
Expand all
34 lectures
03:38:01
+
–
Introduction
5 lectures
21:29
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
4 lectures
06:47
Logical data modeling practice - Public Library
00:26
Public Library : Solution
00:28
Logical data modeling practice - Transportation services
03:02
Transportation Services : Solution
02:51