Course Search:
Request more details:


Print Page

Relational Database Design

Description:
This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. Major subject areas to be explored are: • Building a logical data model of increasing complexity and accuracy • Transforming a logical model into a physical model for a relational database • Using object oriented and semantic modeling techniques to refine a model • Identifying classic structures and patterns which may be reused among many different models. • Learn about star schemas, snowflake schemas and data warehouse models • Introduce the use of a data model diagramming tool and CASE tools • Consider the physical objects of a relational database and how they implement a logical model.

View other Oracle Courses available
  • Cost: Price on application
  • Duration: 3 days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
None
About Data Modeling & Relational Database Design:
• What Is Data Modeling?
• About System Design Methodologies
• More About Case Tools
Building A Simple Data Model :
• Identifying Entities
• Identifying Attributes
• A Simple Modeling Scenario
• Identifying Relationships
• A Simple Data Model Solution
Achieving A More Accurate Model:
• Supplementing The Requirements Specification
• Refining The Attribute Definitions
• Refining The Relationship Definitions
Transform Data Model Into Application Database Model :
• About Application Database Models
• Transformation To Relational Model
Semantic & Object Oriented Modeling:
• Defining Domains
• Defining Supertypes & Subtypes
• Defining Arcs
• Defining Lattices
Classic Structures & Patterns :
• Basic Classic Structures
• Advanced Classic Structures
Data Model Implementation Using Relational Databases :
• Relational Implementation
• Electronics Database Logical Model
• Electronics Database Physical Model
• Supertype & Arc Transformation Options
• More About A Relational Database
• Relational Database Objects
• Sql Ddl
Data Warehouse Models:
• What Is A Data Warehouse?
• About Warehouse Models & Terminology
• Star Schema Model
• Snowflake Schema Model
• Contrast Oltp & Warehouse Databases


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.