title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Data Modeling: Logical Database Design
Course Description
Overview
This course provides a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and real-world experience of the past 20-years of Sideris data design practitioners.The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms. They are also applicable to other database technologies, such as object databases and legacy IMS and IDMS databases. Finally, while we use the free Oracle SQL Developer Data Modeler product as a demonstration modeling tool, one can complete the exercises of this course and apply the techniques learned using any other popular data model diagramming tool, such as IBM InfoSphere Data Architect, CA ErWin Data Modeler, Embarcadero ER/Studio and others.
Objectives
- A review of model-based design, including process modeling, physical data modeling and other modeling techniques which relate to logical data modeling.
- A comparison of data modeling concepts and theories, including top-down data modeling, bottom-up data modeling, data normalization, object-oriented and semantic modeling.
- Hints, tips and guidelines in identifying entities, attributes and relationships which should appear within a data model.
- Review the popular commercial data modeling tools commonly in use today.
- The benefits of building a conceptual data model in advance of the logical model.
- Learn to find and fix well-known mistakes which can exist in relationship definitions, finding missing attributes and correcting erroneous attribute definitions.
- Review a recommended strategy for unique identifiers.
- Using semantic modeling constructs and techniques such as supertypes, subtypes, generalization, specialization, constraints, lattices and arcs.
- Using object-oriented modeling techniques such as domains, attribute classes, extended types and abstraction of attributes.
- Time-dependency and state-dependency within a data model.
- Explore classic structures and modeling patterns, including many-to-many recursion.
- Steps and available options for engineering a physical data model from a logical model.
- Reverse engineering and forward engineering of a physical data model into an implementation relational database.
Audience
- Business analysts
- Data modelers, data analysts and data architects
- Senior application designers and developers
- Database administrators
Prerequisites
- Basic knowledge of computer systems, business systems requirements and database technologies is helpful
Topics
- ABOUT MODEL-BASED DESIGN
- ABOUT DATA MODELING
- ABOUT DATA MODEL DIAGRAMS
- ADVANCED MODELING METHODOLOGIES
- PRINCIPLES OF DATA MODELING
- BUILDING THE MODEL
- IDENTIFYING ENTITIES
- IDENTIFYING ATTRIBUTES
- IDENTIFYING RELATIONSHIPS
- A SIMPLE MODELING SCENARIO
- ABOUT DATA MODELING TOOLS
- DRAWING A DATA MODEL DIAGRAM
- STARTING WITH A CONCEPTUAL MODEL
- SUPPLEMENTING THE REQUIREMENTS
- REFINING THE RELATIONSHIP DEFINITIONS
- CAPTURING MISSING ATTRIBUTE DETAILS
- CHARACTER
- NUMERIC
- DATE
- CORRECTING ATTRIBUTE DEFINITIONS
- UNIQUE IDENTIFIERS
- UNIT OF MEASURE ATTRIBUTES
- DEFINING SUPERTYPES & SUBTYPES
- ENTITY NAME PROBLEMS
- NAMING STANDARDS
- SPECIALIZATION & GENERALIZATION
- SUBTYPE CONSTRAINTS
- DEFINING RELATIONSHIP ARCS
- DEFINING DOMAINS
- DEFINING TYPES
- COLLECTION TYPES
- ABOUT TIME & STATE
- TIME-DEPENDENT SUB-MODEL
- PERSON / INDIVIDUAL ROLES SUB-MODEL
- MASTER-DETAIL-DETAIL
- M:N RECURSION (BILL-OF-MATERIALS)
- ORGANIZATION UNIT HIERARCHY
- ENTITY LOCATIONS
- ENTITY CONTACTS
- ABOUT PHYSICAL DATA MODELS
- PHYSICAL RELATIONAL TRANSFORMATION
- MODEL TRANSFORMATION EXAMPLE
- AUTOMATIC TRANSFORMATION
- SUPERTYPE TRANSFORMATION
- REVERSE ENGINEER A PHYSICAL MODEL
- ABOUT THE RELATIONAL DATABASE
- RELATIONAL DATABASE OBJECTS
- FORWARD ENGINEER A PHYSICAL MODEL
Related Courses
-
Oracle Database 11g R2 SQL Complete
DBOR-917- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
-
Oracle Database 11g: Advanced PL/SQL Programming & Tuning
DBOR-922- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
![self-paced](fynwyd/images/course-outline-self-paced-35x35.png)
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.