Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Data Modeling and Relational Database Design using ERwin

via Udemy

Overview

Save Over 40% with an Annual Subscription to Udemy Personal Plan.
Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs

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

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.

Taught by

Haris Kilikotu

Reviews

4.4 rating at Udemy based on 5986 ratings

Start your review of Data Modeling and Relational Database Design using ERwin

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.