🇩🇪
Programm

  1. Understanding What to Model

  2. Documenting the Business Background

  3. Building a Process Model (Data Flow Diagram)

  4. Using Oracle SQL Developer Data Modeler to Create Your Process Model (Data Flow Diagram)

  5. Validating Your Process Model (Data Flow Diagram)

  6. Identifying Entities and Attributes

  7. Identify Relationships

  8. Assign Unique Identifiers

  9. Using Oracle SQL Developer Data Modeler to Create the Entity Relationship Diagram

  10. Validating your Entity Relationship Diagram

  11. Normalizing your Data Model

  12. Validating Relationships

  13. Adding and Using Data Types

  14. Put It All Together

  15. Map Your Entity Relationship Diagram to a Relational Database Design

  16. Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data Modeler

  17. Defining Your Physical Model

  18. Generating Your Database

  19. Altering an Existing Design

  20. Working in a Collaborative Environment


Ziele
This Oracle Data Modeling and Relational Database Design training covers the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle. Learn from expert Oracle University instructors through interactive instruction and hands-on exercisese.


Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:

  • Understanding What to Model

  • Documenting the Business Background

  • Building a Process Model (Data Flow Diagram)

  • Using Oracle SQL Developer Data Modeler to Create Your Process Model (Data Flow Diagram)

  • Validating Your Process Model (Data Flow Diagram)

  • Identifying Entities and Attributes

  • Identify Relationships

  • Assign Unique Identifiers

  • Using Oracle SQL Developer Data Modeler to Create the Entity Relationship Diagram

  • Validating your Entity Relationship Diagram

  • Normalizing your Data Model

  • Validating Relationships

  • Adding and Using Data Types

  • Put It All Together

  • Map Your Entity Relationship Diagram to a Relational Database Design

  • Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data Modeler

  • Defining Your Physical Model

  • Generating Your Database

  • Altering an Existing Design

  • Working in a Collaborative Environment
Voraussetzungen
Für dieses Seminar werden folgende Kenntnisse empfohlen:

  • Keine vorkenntnisse nötig.