Database Design Self-Study Course

Database Design Self-Study Course

Oracle University
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Database Design will define and discuss the purpose of database design and how to use modeling to represent real-world concepts.
Audience
  • Database Administrators
  • Business Analysts
  • Database Designers

Course Topics Data Modeling: Create Basic Models
  • Introduction to Relational Data Modeling
  • Creating a Basic Entity Relationship Model
  • Adding Detail to the Model
Data Modeling: Develop Depth to Your Models
  • Adding Complexity to an Entity Relationship (ER) Model
  • The Technique of Normalization
  • Combining Normalization and ER Modeling
Process and Function Modeling
  • Introduction to Process Modeling
  • Building a Basic Process Model
  • Refining the Process Model
  • Developing the Application Function …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Two Dimensional Design (2D Design), Data Warehouse, SQL & MySQL, Business Intelligence (BI), and PL/SQL.

Database Design will define and discuss the purpose of database design and how to use modeling to represent real-world concepts.
Audience
  • Database Administrators
  • Business Analysts
  • Database Designers

Course Topics Data Modeling: Create Basic Models
  • Introduction to Relational Data Modeling
  • Creating a Basic Entity Relationship Model
  • Adding Detail to the Model
Data Modeling: Develop Depth to Your Models
  • Adding Complexity to an Entity Relationship (ER) Model
  • The Technique of Normalization
  • Combining Normalization and ER Modeling
Process and Function Modeling
  • Introduction to Process Modeling
  • Building a Basic Process Model
  • Refining the Process Model
  • Developing the Application Function Hierarchy
  • Cross Referencing the Models

Course Objectives
  • Recognize and use patterns in models
  • Apply various techniques to optimize the design in an Oracle environment for performance and maintainability
  • Transfer ER models into an initial relational database design
  • Read, improve, create, use and judge Entity Relationship Models
  • Capture business rules and constraints

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.