Public Webinar

EA and Data Models

Course Description:

This course is designed for data modellers who wish to learn UML class notation and how to create logical and physical data models in Enterprise Architect. Delegates are taught how to create logical class diagrams and physical relational database models within Enterprise Architect. This course is highly practical with many hands-on exercises.

Enterprise Architect
UML

Prerequisites:

No prior knowledge of UML class diagrams is required. Basic Enterprise Architect experience is expected. If new to Enterprise Architect consider attending our “EA Fundamentals” course first.

Equipment:

Webinar
Enterprise Architect

For webinar delivery delegates require a PC or laptop running Enterprise Architect with an Internet connection (a headset can be helpful). If you wish to test your environment join a test WebEx meeting: www.webex.com/test-meeting.html

A trial version of Enterprise Architect is fine for training and can be downloaded from Sparx Systems website: www.sparxsystems.com/products/ea/trial.html. It is also helpful to have a mouse as this makes creating diagrams much easier.

Course Style:

50% theory, 50% practical
Each module is accompanied by paper and hands-on exercises to allow delegates to apply the theory and become confident using UML class diagrams and Enterprise Architect.

Delegate Handouts:

Each delegate receives a booklet containing all the course slides and comprehensive theory notes which form excellent reference material. Booklets also contain exercises and suggested solutions. Following successful completion of the course each delegate receives a certificate.

Course Modules:

  • Delegate background and objectives
  • Timetable and course outline

EA Teaching – 0.5 hour

Paper Exercises – 1 hour

EA Hands-On Exercises – 1 hour

  • Create domain models in EA
  • Model business classes in EA
  • Add key attributes in EA
  • Define analysis attribute types in EA
  • Add associations and define multiplicity in EA
  • Model aggregation in EA
  • Create inheritance hierarchies in EA

EA Teaching – 1 hour

EA Hands-On Exercises – 1 hour

  • Create relational database diagrams in EA
  • Use patterns to create database structure in EA
  • Use database builder in EA
  • Create database tables in EA
  • Add columns and primary key in EA
  • Add constraints for indexes and triggers in EA
  • Document foreign keys in EA
  • Add queries, views and stored procedures in EA
  • Generate DDL from EA to live database