Data Modeling and Relational Database Design using ERwin
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
Loading charts...
Comidoc Review
Our Verdict
While this course on Data Modeling and Relational Database Design using ERwin delivers valuable content, there's room for refinement. The curriculum boasts deep dives into Entity Relationship Diagrams, normalization techniques, and optimization tactics tailored to various requirements. These strong points make it a compelling choice for those interested in sound data modeling practices and the ERwin Data Modeler. However, certain aspects could benefit from improvement. Occasionally lacking sufficient elaboration on specific topics such as higher normal forms or terms like 'surrogate key' may create confusion during the learning process. Also, minor discrepancies between course materials and current versions of ERwin might require extra effort to reconcile. Moreover, providing more hands-on exercises, pre-built models, and consistent pacing would make a substantial difference in improving learner experience. Overall, this course is a good starting point for data modeling using ERwin, but it has the potential to be even better with some fine-tuning of its content and delivery.
What We Liked
- Comprehensive coverage of ERwin Data Modeler with a strong focus on creating and maintaining sound relational database designs
- In-depth explanations of Entity Relationship Diagrams, normalization, and data modeling techniques
- Valuable insights into optimizing relational database designs for various requirements
- Actionable tips for working with database change requests and maintaining existing databases using tools
Potential Drawbacks
- Some concepts could be more elaborated, such as higher normal forms and specific terms like 'surrogate key'
- Minor discrepancies between the course material and the latest version of ERwin may cause confusion
- Lack of prepared models/exercises for hands-on practice throughout the course
- Occasionally faster speech in early lessons might be challenging for some learners to follow