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.
