What is data modeling?

Haris Kilikotu
A free video tutorial from Haris Kilikotu
Developer | Architect | Product Manager
4.3 instructor rating • 1 course • 7,770 students

Learn more from the full course

Data Modeling and Relational Database Design using ERwin

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

03:31:13 of on-demand video • Updated October 2017

  • 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
English [Auto] My name is how it is called. It's my great pleasure to welcome you to this course. Diskos introduces you to the most important concepts of data modeling and how to implement them using Romeyn data model. In this lesson we will discuss what does that modeling and the specific job rules that would benefit from discourse course. Or does that modeling from information engineering perspective that modeling is a process that analyze and define that requirements needed to support the business process within the scope of an information system that models are extremely useful because their data model is a conceptual representation of structure and behavior of data that are really useful in expressing and communicating business rules because we'll will teach you how to create indeed the relationship diagrams by identifying entities attributes relationships and constraints from a set of requirements that they help solve ended the relationship diagrams how to normalize a data model to a third normal form by applying proven better modeling techniques how to develop its own database design. We will also learn how to forward engineer a model to a database how to reverse engineer a database back to a model how to optimize your relational database design for various functional and nonfunctional requirements. You'll also learn how to work with the database changes. If we have an existing database and sporting that more than how to make a change in the data model and apply that change in the database in addition to that we'll explore other functionalities of oven that are useful for that smaller and data architect to be more efficient and productive. The intended audience for this course our data more lose data architects anyone with ease or will want to be a data model or data architect database designer or better because professional database administrators system analyst software engineers and other floors that are important to develop an information system can also benefit from this course. I wish you good luck.