8781  Reviews star_rate star_rate star_rate star_rate star_half
$4,000USD
Duration 4 days
Course Code DM-REL-DB-2-1
Available Formats Classroom, Virtual
Next Class: Aug 24, 2026

Upcoming Course Dates

Ask a Question Request Other Date Request On-site Course

Overview

Course Description

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.

Skills Gained

Learn to:

  • Identify the types of models.
  • Develop a process model (Data Flow Diagram).
  • Use advanced data modeling techniques.
  • Create the Physical Model, add several Physical Model objects, and generate the DDL.
  • Use several real life examples to document business requirements.
  • Work with design rules that can be applied to check and enforce the integrity and consistency of your designs.
  • Work in a collaborative environment using Subversion.

Prerequisites

Suggested:

  • Basic understanding of relational database concepts

Benefits to You

By taking this course, you will develop an understanding of the data modeling and database development process, as well as the models used in each phase of the development lifecycle. You'll develop the skills to model and understand the database development lifecycle based on real life examples, while mapping the objects and engineer the logical model to a relational model.

Validate Data Models

You will also learn techniques to validate these data models. Once the Relational Design has been validated, you can create physical models to add all physical properties and finally generate a DDL to create the database objects for your database. You will also better understand how you can work as a team on developing a model using Subversion.

Read Less
|
View Full Schedule

Course Details

Course Details

Understanding What to Model

  • Why Model?
  • Why Model: A Practical Example
  • Database and Application Development Life Cycle
  • Process Modeling
  • Logical Data Modeling
  • Database Design
  • Database Generation
  • Data Type Model

Documenting the Business Background

  • Documenting the Business Direction
  • Components of a Business Direction Statement
  • Business Objectives
  • Assumptions
  • Critical Success Factors
  • Key Performance Indicators
  • Problems
  • Devising Business Direction Objectives and Actions

Building a Process Model (Data Flow Diagram)

  • What Is a Process Model?
  • Why Create a DFD?
  • Components of a Data Flow Diagram
  • Events
  • Analyzing Event Responses

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

  • Downloading and Installing Oracle SQL Developer Data Modeler
  • Oracle SQL Developer Data Modeler Main Window Components
  • Building a Data Flow Diagram
  • Editing the Diagram Layout
  • Adding and Reusing Process Events
  • Saving Your Model
  • Opening a Saved Model

Validating Your Process Model (Data Flow Diagram)

  • DFD Rules
  • Design Rules in Oracle SQL Developer Data Modeler
  • Types of Processes
  • Process Decomposition
  • Decomposition Guidelines

Identifying Entities and Attributes

  • What Is a Logical Data Model?
  • Why Create an ERD?
  • Components of an Entity Relationship Diagram
  • Attributes
  • Attribute Characteristics

Identify Relationships

  • Relationships
  • Components of a Relationship
  • Relationships: Additional Examples
  • Relationship Types
  • Using a Relationship Matrix
  • Determining a Relationship’s Existence
  • Naming the Relationship
  • Determining the Relationship’s Cardinality

Assign Unique Identifiers

  • Unique Identifiers
  • Unique Identifier Examples
  • Identifying Relationships
  • Identifying Relationships with Multiple Entities
  • Non-Identifying Relationships
  • Primary and Secondary Unique Identifiers
  • Searching for Unique Identifiers

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

  • Building an Entity Relationship Diagram
  • Specifying Logical Model General Option
  • Modifying Model Properties
  • Notation Types
  • Editing a Diagram Layout
  • What Is a Subview?
  • Creating a Subview
  • What Is a Display?

Validating your Entity Relationship Diagram

  • ERD Checklist
  • Attribute Rules
  • Distinguishing Attributes and Entities
  • Attribute Optionality
  • Adding Additional Information to the ERD
  • Creating Reports

Normalizing your Data Model

  • What Is Normalization?
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Normalization Example

Validating Relationships

  • Resolving M:M Relationships
  • Modeling Hierarchical Data
  • Examining Recursive Relationships
  • Resolving a M:M Recursive Relationships
  • Modeling Exclusive Relationships
  • Creating an Exclusive Relationship in Oracle SQL Developer Data Modeler
  • Entity Type Hierarchies
  • Modeling Subtypes in Oracle SQL Developer Data Modeler

Adding and Using Data Types

  • Attribute Data Types
  • Logical Type
  • Types Administration
  • Domain
  • Adding a Check Constraint to a Domain
  • Adding Ranges or Value Lists to a Domain
  • Preferred Logical Types and Domains
  • Creating Domains from Logical Types

Put It All Together

  • Build an ERD from a Case Study

Map Your Entity Relationship Diagram to a Relational Database Design

  • Why Create a Relational Model?
  • Review: Database Design
  • Relational Database Overview
  • Terminology Mapping
  • Naming Conventions
  • Naming Restrictions with Oracle
  • Ensuring That Your Logical Data Model Is Complete
  • Mapping Simple Entities

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

  • Relational Model and Relational Model Diagram Preferences
  • Reviewing Table Properties
  • Previewing the DDL for a Table
  • Preferences: Classification Types
  • Assigning a Classification Type to One Table
  • Changing the Color for Classified Tables
  • Changing the Prefix for Classified Tables
  • Assigning Classification Types to Multiple Tables

Defining Your Physical Model

  • What Is a Physical Model?
  • Creating a Physical Model
  • RDBMS Administration
  • RDBMS Administration: Changing the Default RDBMS Sites
  • Creating Physical Model Objects
  • Adding a User
  • Adding Segment Templates (Storage)
  • Associating Physical Objects with Your Table

Generating Your Database

  • Database Generation
  • Generating DDL
  • DDL Preferences
  • DDL/Migration General Options
  • Design Rules
  • Working With Rule Sets
  • Working With Custom Rules
  • Working With Libraries

Altering an Existing Design

  • Approaches to Modeling
  • SUsing Import to Create a Model
  • Importing an Existing Database
  • Importing Domains
  • Creating a Logical Data Model from Your Relational Model
  • Reviewing and Making Changes to Your Logical Model
  • Checking the Design Rules
  • Forward Engineering to a New Relational Model

Working in a Collaborative Environment

  • The Benefits of Version Control
  • Working With Data Modeler and Subversion
  • Pending Changes
  • Basic Workflow: Using Subversion with a Design
  • Maintaining Versions

Schedule

3 options available

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

Great and very intuitive. Better than the traditional hit the wrong button/lose points.

It is very good and very simple instructions. almost to much hand holding.

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.

The tool provided to practice the course teachings is very functional and easy to use.