COURSE OBJECTIVE:
• To help understand data modeling methodologies.
• To help comprehend how statistical designs and analyses work.
• To help teach the application of data models.
• To help comprehend different data model styles.
• To explain how different data designs and models may be utilized for business problems and scenarios.
• To explain how System Development Lifecycle works.
TARGET AUDIENCE:
• Business Intelligence & Data Warehouse developers & architects
• Data Modellers
• Developers
• Data & Enterprise Architects
• Data Analysts
• Solution Architects
• Application Architects
• Information Architects
• Business Analysts
• Database Administrators
• Project / Programme Managers
• IT Consultants
• Data Governance Managers
• Data Quality Managers
• Information Quality Practitioners
COURSE PREREQUISITES:
DAMA DMBoK Data Management Fundamentals
COURSE CONTENT:
• Database Design and Data Modeling
• CDMP Breakdown
• Explanation of Data Design and Modeling
• Comprehension of SDLC and Lifecycle
• Understanding the Development of Data
• Explanation of a Data Model
• Representations of Data Models
• Significance of Data Modeling
• Reasons for the Production of a Data Model
• Data Model Levels
• Symbols of Entity Relationships
• Notations and Cardinality
• Enterprise Data Model
• Physical Data Model
• Logical Data Models
• Conceptual Data Models
• Subject Area Models
• Independent and Dependent Entities
• Significance of Comprehending Entities
• Types of Relationships
• Recursive Relationships
• Many to Many Relationships
• Entity Subtypes
• Role Name Usage
• Physical and Conceptual Terms
• Primary Keys
• Entity Keys
• Alternate Keys
• Benefits and Drawbacks of Natural versus Surrogate Keys
• Data Model and Process Relationships
• Components of a Logical Data Model
• Normalization Rules
• Normalization Approaches
• Normalization Definition
• Principles of Database Design
• Best Practices of a Physical Database Design
• Comprehension of Partitioning
• Transformation of Logical to Physical Data Model
• ACID Test
• Classification of Modeling Tools
• The Alternative to ACID
FOLLOW ON COURSES:
Not available. Please contact.