Programm
- 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
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:
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.