Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Data Modeling

The Data Modeling course and lab cover the entire field of how to create data models that allow complex data to be analyzed, manipulated, extracted, and reported upon accurately. The labs are cloud-based, device-enabled, and can easily be integrated with an LMS. The computer architecture course and lab also provide knowledge on the areas such as I/O functions and structures, RISC, and parallel processors with real-world examples enhancing the text for reader interest.
NameBuy
Data Modeling
Test Prep
52+ Pre Assessment Questions | 52+ Post Assessment Questions |
Features
21+ LiveLab | 18+ Video tutorials | 00+ Minutes

Why choose TOPTALENT?

Outline

Lessons 1:
Introduction

  • Who Should Read This Course
  • What the Course Covers

Lessons 2:
Introduction to Data Modeling

  • Data-Centric Design
  • Anatomy of a Data Model
  • Importance of Data Modeling
  • Measures of a Good Data Model
  • How Data Models Fit Into Application Development
  • Data Modeling Participants

Lessons 3:
Relational Model Components

  • Conceptual and Logical Model Components
  • Physical Model Components

Lessons 4:
Data and Process Modeling

  • Data Model Diagramming Alternatives
  • Process Models
  • Unified Modeling Language (UML)
  • Relating Entities and Processes

Lessons 5:
Organizing Database Project Work

  • The Traditional Life Cycle
  • Nontraditional Life Cycles
  • The Project Triangle

Lessons 6:
Conceptual Data Modeling

  • The Conceptual Modeling Process
  • Creating the Model
  • Evaluating the Model

Lessons 7:
Logical Database Design Using Normalization

  • The Need for Normalization
  • Applying the Normalization Process
  • Denormalization
  • Practice Problems

Lessons 8:
Beyond Third Normal Form

  • Advanced Normalization
  • Resolving Supertypes and Subtypes
  • Generalizing Attributes
  • Alternatives for Reference Data

Lessons 9:
Physical Database Design

  • The Physical Design Process
  • Designing Tables
  • Integrating Business Rules and Data Integrity
  • Adding Indexes for Performance
  • Designing Views

Lessons 10:
Alternatives for Incorporating Business Rules

  • The Anatomy of a Business Rule
  • Implementing Business Rules in Data Models
  • Limitations on Implementing Business Rules in Data Models
  • Functional Classification of Business Rules

Lessons 11:
Alternatives for Handling Temporal Data

  • Temporal Data Structures
  • Calendar Data Structures
  • Business Rules for Temporal Data

Lessons 12:
Modeling for Analytical Databases

  • Data Warehouses
  • Data Marts
  • Modeling Analytical Data Structures
  • Loading Data into Analytical Databases

Lessons 13:
Enterprise Data Modeling

  • Enterprise Data Management
  • The Enterprise Data Model