Ref : DBD / 2 days
Context
MEGA Database Builder enables the modeling of information system data, and generation of the corresponding relational diagram and SQL script for database creation. The tool enables parallel management of conceptual objects (entities, associations, attributes) and logical objects (tables, columns, keys) to take account of developments and optimizations. MEGA also enables reverse documentation of an existing database from an extraction file or an ODBC driver, with reverse generation of the logical model and reverse design of the conceptual model.
Who should attend?
- Data administrators
- IS architects
- Database administrators
- Application managers
- Analysts Designers Developers
Expected Benefits
- Master database modeling concepts: conceptual and physical models.
- Learn how to use MEGA Database Builder effectively and make the best use of the MEGA repository.
- Optimize the structure of a relational database and generate the corresponding SQL script.
- Reverse engineer an existing relational database to obtain a conceptual schema.
Course Content
Introduction
- Presentation of MEGA
- Database design procedure
Data modeling
- Basic concepts
- Other concepts, rules and approach
Synchronization
- Database creation
- Conceptual and logical object mapping
- Transformation rules
- Relational diagram
- Synchronization configuration
Optimizations and developments
- Denormalization and mapping management
- Complements: views, tablespaces, triggers, etc.
Generation
- Configuring Generation
- Elements necessary for defining Database structure
Reverse generation
- Reverse Design Cycle
- Configuring Reverse Generation
- Extraction Utility
- Logical Model Creation
Synchronization (logical to conceptual)
- Synchronization Rules
- Synchronization Wizard
Making best use of the MEGA repository
- Producing project related documentation
- Generating HTML pages
- The Query tool
- Working as a team
Lab exercises
Over 2 days, training alternates theoretical presentations of data modeling and practical exercises covering all phases of the design of a data system and reverse documentation of an existing repository.
- Producing a data diagram from a real case
- Synchronization: management of logical objects obtained
- Exercises in modification and optimizations of models
- SQL script generation
- Reverse generation of an existing repository
- Exercises in repository use