uCertify

Data Modeling

(UOP-DSC530.AO1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Data Modeling Concepts and Relational Model Component

  • 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
  • Conceptual and Logical Model Components
  • Physical Model Components
2

Data and Process Modeling and Organizing Database Project Work

  • Data Model Diagramming Alternatives
  • Process Models
  • Unified Modeling Language (UML)
  • Relating Entities and Processes
  • The Traditional Life Cycle
  • Nontraditional Life Cycles
  • The Project Triangle
3

Conceptual Data Modeling and Logical Database Design Using Normalization

  • The Conceptual Modeling Process
  • Creating the Model
  • Evaluating the Model
  • The Need for Normalization
  • Applying the Normalization Process
  • Denormalization
  • Practice Problems
4

Beyond Third Normal Form and Physical Database Design

  • Advanced Normalization
  • Resolving Supertypes and Subtypes
  • Generalizing Attributes
  • Alternatives for Reference Data
  • The Physical Design Process
  • Designing Tables
  • Integrating Business Rules and Data Integrity
  • Adding Indexes for Performance
  • Designing Views
5

Alternatives for Incorporating Business Rules and for Handling Temporal Data

  • 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
  • Temporal Data Structures
  • Calendar Data Structures
  • Business Rules for Temporal Data
6

Modeling for Analytical Databases and Enterprise Data

  • Data Warehouses
  • Data Marts
  • Modeling Analytical Data Structures
  • Loading Data into Analytical Databases
  • Enterprise Data Management
  • The Enterprise Data Model

1

Data Modeling Concepts and Relational Model Component

  • Creating a Conceptual Model
  • Creating a Physical Data Model
  • Creating a Logical Data Model
  • Modifying a Conceptual Model
2

Data and Process Modeling and Organizing Database Project Work

  • Drawing of a Conceptual Model with Nested Subtypes
3

Conceptual Data Modeling and Logical Database Design Using Normalization

  • Creating a Conceptual Model for the Employee Management System
  • Analyzing Normalization in Academic Tracking Database
  • Creating a Data Model in Second Normal Form
  • Creating a Data Model in First Normal Form
4

Beyond Third Normal Form and Physical Database Design

  • Creating a Data Model in Fourth Normal Form
  • Creating a Complex Logical Data Model
  • Converting a Logical Data Model into a Physical Data Model
  • Creating a Physical Data Model ERD
  • Creating a Data Model in Third Normal Form
5

Alternatives for Incorporating Business Rules and for Handling Temporal Data

  • Modeling Business Rules in a Logical Data Model
  • Adding History to Data Models
6

Modeling for Analytical Databases and Enterprise Data

  • Designing a Star Schema Fact Table
  • Developing an Enterprise Conceptual Model

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More