Curso de modelamiento de datos con Power Designer

Objetivos del curso

• Create and manage conceptual data models
• Generate and manage physical data models
• Generate database creation scripts
• Produce implementation details, such as triggers, procedures, and views
• Reverse engineer an existing database to create physical, conceptual, and object-oriented models
• Compare and merge models
• Synchronize physical data models with databases
• Manage large models and multiple designers using MetaWorks
• Create effective reports on you PowerDesigner models

Temas del curso

• Introduction to data modeling with PowerDesigner
• Using the PowerDesigner modeling environment
• Creating and managing a conceptual data model
• Defining business rules
• Creating data items, entities, and entity attributes
• Creating and defining relationships - Cardinality, Dependency, Roles, Existence
• Defining and using domains and inheritance
• Generating a physical data model
• Transforming CDM objects to PDM objects
• Customizing the physical data model
• Creating views, alternate keys, and indexes
• Creating the database script
• Protecting data through triggers, procedures, views, and business rules
• Reverse engineering databases
• Model management techniques
• Physical data model synchronization
• Working with packages and diagrams
• Working with the Enterprise Repository
• Creating reports

Más detalles click en este enlace

Será que hoy dia soy capaz de hacer esto con Power Designer?