Oracle Data Modeling and Relational Database Design Ed 2.1

This Oracle Data Modeling and Relational Database Design course covers the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle.

STUDENTS WILL 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.

 

Phone
Phone
Product
Oracle
Code
D67292GC21
Duration
4 Days
Price (baht)
73,800

About the course

COURSE TOPICS

Module 1 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

Module 2 : 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

Module 3 : 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

Module 4 : 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

Module 5 : Validating Your Process Model (Data Flow Diagram)

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

Module 6 : Identifying Entities and Attributes

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

Module 7 : 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

Module 8 : 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

Module 9 : 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 Sub view?
  • Creating a Sub view
  • What Is a Display?

Module 10 : Validating your Entity Relationship Diagram

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

Module 11 : Normalizing your Data Model

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

Module 12 : 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

Module 13 : 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

Module 14 : Put It All Together

  • Build an ERD from a Case Study

Module 15 : 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

Module 16 : Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data Mc

  • 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

Module 17 : 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

Module 18 : 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

Module 19 : 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

Module 20 : 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

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save