TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

Oracle Data Modeling and Relational Database Design Ed 2.1

Schedule

Start End Duration Location Details

Course Details

Oracle Data Modeling and Relational Database Design

Duration: 4 Days

Course Code: ODMRDD2.1

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. 

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.

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.

Course Objective:

•    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
 
Intended Audience:

•    Analyst
•    Architect
•    Database Administrator
•    Developer
•    Systems Administrator    Course Outline:

•    Understanding What to Model
•    Using Oracle SQL Developer Data Modeler to Create Your Process Model (Data Flow Diagram)
•    Using Oracle SQL Developer Data Modeler to Create the Entity Relationship Diagram
•    Put It All Together
•    Defining Your Physical Model
•    Working in a Collaborative Environment
•    Documenting the Business Background
•    Validating Your Process Model (Data Flow Diagram)
•    Identify Relationships
•    Validating your Entity Relationship Diagram
•    Validating Relationships
•    Map Your Entity Relationship Diagram to a Relational Database Design
•    Generating Your Database
•    Building a Process Model (Data Flow Diagram)
•    Identifying Entities and Attributes
•    Assign Unique Identifiers
•    Normalizing your Data Model
•    Adding and Using Data Types
•    Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data Modeler
•    Altering an Existing Design