Premium Features

Previous Buy now to get complete version Next
  • Home
uCertify Logo
  • login
  • Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Data Modeling

(DATA-MODEL.AO1) / ISBN: 9781644593011
This course includes
Lessons
TestPrep
LiveLab
DATA-MODEL.AO1 : Data Modeling
Try this course Pre-Assessment and first two Lessons free No credit card required
Are you an instructor? Teach using uCertify products
Request a free evaluation copy

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.
Here's what you will get

Lessons
  • 13+ Lessons
  • 101+ Exercises
  • 178+ Quizzes
  • 107+ Flashcards
  • 107+ Glossary of terms
TestPrep
  • 52+ Pre Assessment Questions
  • 52+ Post Assessment Questions
LiveLab
  • 21+ LiveLab
  • 18+ Video tutorials
Here's what you will learn
Download Course Outline
Lesson 1: Introduction
  • Who Should Read This Course
  • What the Course Covers
Lesson 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
Lesson 3: Relational Model Components
  • Conceptual and Logical Model Components
  • Physical Model Components
Lesson 4: Data and Process Modeling
  • Data Model Diagramming Alternatives
  • Process Models
  • Unified Modeling Language (UML)
  • Relating Entities and Processes
Lesson 5: Organizing Database Project Work
  • The Traditional Life Cycle
  • Nontraditional Life Cycles
  • The Project Triangle
Lesson 6: Conceptual Data Modeling
  • The Conceptual Modeling Process
  • Creating the Model
  • Evaluating the Model
Lesson 7: Logical Database Design Using Normalization
  • The Need for Normalization
  • Applying the Normalization Process
  • Denormalization
  • Practice Problems
Lesson 8: Beyond Third Normal Form
  • Advanced Normalization
  • Resolving Supertypes and Subtypes
  • Generalizing Attributes
  • Alternatives for Reference Data
Lesson 9: Physical Database Design
  • The Physical Design Process
  • Designing Tables
  • Integrating Business Rules and Data Integrity
  • Adding Indexes for Performance
  • Designing Views
Lesson 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
Lesson 11: Alternatives for Handling Temporal Data
  • Temporal Data Structures
  • Calendar Data Structures
  • Business Rules for Temporal Data
Lesson 12: Modeling for Analytical Databases
  • Data Warehouses
  • Data Marts
  • Modeling Analytical Data Structures
  • Loading Data into Analytical Databases
Lesson 13: Enterprise Data Modeling
  • Enterprise Data Management
  • The Enterprise Data Model

Hands on Activities (Live Labs)

Introduction to Data Modeling

  • Creating a Conceptual model
  • Creating a Physical Data Model
  • Creating a Logical Data Model

Relational Model Components

  • Modifying a Conceptual Model

Data and Process Modeling

  • Drawing of a Conceptual Model with Nested Subtypes

Organizing Database Project Work

  • Discussing the Traditional Life Cycle and Requirements Gathering
  • Testing the Knowledge of Project Database Management Tasks
  • Discussing Nontraditional Life Cycles and the Project Triangle

Conceptual Data Modeling

  • Creating a Conceptual Model for the Employee Management System

Logical Database Design Using Normalization

  • Creating a Data Model in Second Normal Form
  • Creating a Data Model in First Normal Form
  • Analyzing Normalization in Academic Tracking Database

Beyond Third Normal Form

  • Creating a Data Model in Fourth Normal Form
  • Creating a Complex Logical Data Model

Physical Database Design

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

Alternatives for Incorporating Business Rules

  • Modeling Business Rules in a Logical Data Model

Alternatives for Handling Temporal Data

  • Adding History to Data Models

Modeling for Analytical Databases

  • Designing a Star Schema Fact Table

Enterprise Data Modeling

  • Developing an Enterprise Conceptual Model
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept