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 course delivery the customer should provide a suitable training room with a projector to connect to our trainer's laptop and a whiteboard or flipchart. All delegates require access to a PC or laptop running Enterprise Architect.
 

For webinar training sessions delegates need access to a PC or laptop running Enterprise Architect with Internet connection and VoIP (a headset can be helpful for privacy in an office environment).

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

Course Style: 55% theory, 45% 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

Download
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
      hour  
 

  Delegate background and objectives

  Timetable and course outline

 
HIPPO 60  EA Essentials

   1 hour  

 EA Hands-On Exercises  1 hour  
 

  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

    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

 
HIPPO 28  UML Map to Relational Databases

       hour  
 

  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

hippo@hippo-software.co.uk

+44 (0)1506 202164

    Hippo Software Limited 2018. All registered trademarks acknowledged.