Oracle Data Modeling and Relational Database Design


Oracle Data Modeling and Relational Database Design training course is designed to learn the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle. In this training class, you will learn how to identify the types of models, how to develop a process model (Data Flow Diagram), how to Create the Physical Model, add several Physical Model objects, and generate the DDL and more.

Target Audience:

  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Systems Administrator
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 4 Days
Fee : India : $2,200 , Dubai : $3,000

08-11 (Dubai)
12-15 (Dubai)
11-14 (Dubai)

Enquire Now

Input symbols

  • Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set of requirements
  • Normalize the Entity Relationship Diagram to third Normal form
  • Enhance the Entity Relationship Diagram to utilize several data modeling techniques
  • Create a Data Flow Diagram by identifying processes, external agents, information stores and information flows that show how the information flows and how it is being transformed
  • Engineer the Entity Relationship Model into an initial relational database design
  • Optimize the Relational Database Design
  • Complete the Physical Model and generate the DDL
  • Use Oracle SQL Developer Data Modeler to document all the concepts learned throughout the course