Data Modeling and Relational Database Design using ERwin (Udemy.com)

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

Created by: Haris Kilikotu

Produced in 2017

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 82 / 100

icon
Course 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 coursewill 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 ModelersData ArchitectsDatabase administratorsETL developersDWH/BI professionalsBusiness Analysts

icon
Instructor Details

Haris Kilikotu

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

A skilledpractitionerwho canunderstand 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.

icon
More other courses

Aprende matemticas desde cero - Aritmtica

$11.99

Unofficial Udemy Student Guide: Courses Free or Dirt Cheap

$11.99

Poi Dancing: The Beginner Series

$11.99

Professional Advanced Angelic Healing Practitioner Course

$11.99

Professional Accredited Earth Angel Course

$11.99

Cours signe bb tout le vocabulaire autour du bb

$11.99

icon
Reviews

4.1

173 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Sankar on 11/22/2020

very well articulated and explained. All aspects of the tool usage are covered,

By Edward Adeshina on 11/15/2020

Super clear

By Palchandar S on 11/8/2020

Able to understand clearly

By Bharath Balaji on 10/25/2020

Too much content in a very short time. Not much of an introduction to the software or background of the topic.

By THARUN SAI C R on 10/22/2020

The one who is explaining not what I expected.feels boring and sleepy

By Girija Unnibhavi unnibhavi on 10/21/2020

good

By Peet on 10/19/2020

Very clear and like that it starts very basic

By Vasanthakumar.s . on 10/18/2020

Nice Course

By Potluri Adithya vishnu teja on 10/15/2020

Good.

By Rama K Manne on 10/9/2020

Explanation was pretty neat and instructor was right on the points that were important. I think it would have been more a complete Data Modeling by taking few more examples (This is a pure suggestion to the instructor).

By PERAM PAVAN KALYAN on 10/7/2020

Good

By Yamini Ramineni on 10/6/2020

nice