Public Training Schedule
Free EA Executive Overview
Home EA BPMN UML SysML ArchiMate Feedback Resources Pricing Partners Contact
 Home > EA or UML > EA for Data Modelling

EA for Data Modelling

This course is aimed at data architects and software designers who wish to use Enterprise Architect to capture logical and physical data models. The course teaches delegates how to create domain models using UML class diagrams and how to use the database builder environment for relational database models.
Duration: 1 day

Prerequisites: No prior Enterprise Architect experience is required.
Delegates should have knowledge of class diagrams and relational database design.
Equipment: For on-site delivery the customer should provide a suitable training room with a screen or projector to connect to our trainer's laptop and a whiteboard or flipchart. All delegates require a PC or laptop running Enterprise Architect (corporate edition or higher).
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:
A trial version of Enterprise Architect is fine for training and can be downloaded from Sparx Systems website: 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 a hands-on exercise to allow delegates to apply the theory and become confident using Enterprise Architect.
Delegate Handouts: Each delegate receives a folder containing all the course slides and comprehensive theory notes which form excellent reference material. Folders also contain exercises and suggested solutions. Following successful completion of the course each delegate receives a certificate.
Module Key: Teaches concepts and notation

  Teaches practical use of Enterprise Architect
             Covers BPMN, UML, SysML and/or ArchiMate

Course Outline

      Includes paper exercises, EA hands-on sessions

Course Modules: HIPPO 00    Introduction   hour          
  HIPPO 60  EA Essentials  2 hours      
  HIPPO 77  EA UML Domain Models  1 hours  

  HIPPO 28  UML Map to Relational Databases   hour  

  HIPPO 99  EA Relational Databases  2 hours                   

Course Details:

HIPPO 00  Introduction

  Delegate background and objectives

  Timetable and course outline

HIPPO 60  EA Essentials

   1 hour  

 EA Hands-On Exercises  1 hours  

  Introduction to EA

  Navigate the EA user interface

  Create project models in EA

  Create diagrams in EA

  Understand the structure of EA projects

  Create and delete elements in EA

  Search for elements in EA

HIPPO 77  EA UML Domain Models


 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

HIPPO 28  UML Map to Relational Databases


  Persistence and relational databases

  Wrapper classes and factories

  Store classes and attributes

  Record associations

  Many to many relationships

  Mapping inheritance


HIPPO 99  EA Relational Databases

   1 hour  

 EA Hands-On Exercises  1 hour  

  Create relational database diagrams 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

  Use database builder in EA

  Use patterns to create database structure in EA

  Generate DDL from EA to live database

+44 (0)1506 202164

    Hippo Software Limited 2021.
    Enterprise Architect and Prolaborate are trademarks of Sparx Systems
    BPMN is a trademark, UML and SysML are registered trademarks of the Object Management Group
    ArchiMate is a registered trademark of The Open Group