Basics of Oracle Data Modelling (22D)


Oracle Data Modelling Training is a fundamentals course that covers the basic topics that beginners should know. You will first learn what a “model” is, and then how to create a process model with SQL Developer Modeler. Additionally, one can learn how to recognize entities, attributes, and relationships. By the end of the course, you will comprehend how to assign, develop, and validate entity relationship diagrams, as well as how to normalize your data model.
In This Module We Will Learn :
- 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