DATA-MODEL.AO1
Data Modeling
Learn the fundamentals of Data Modeling and take your career to new heights.
- Practice in 21 Hands-On Labs — nothing to install
- 13 Interactive Lessons and 46 topics mapped to the official exam objectives
- 315 Practice Test Questions
Intermediate Self-paced · 1 year access 4.6/5 (77 Reviews)
21 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
13Interactive Lessons
46Topics
21LiveLab
315Practice Test Questions
107Flashcards
107Glossary of terms
01 / Skills you'll get
What you will be able to do
It is a comprehensive Data Modeling course that focuses on data-centric design principles, relational modeling components, and the process of creating conceptual, logical, and physical data models. You’ll learn how to create various data models using diagramming alternatives like flowcharts, data flow diagrams, and fishbone diagrams. Discover the components of a relational database model, including conceptual, logical, and physical models. By the end of this online Data Modeling training course, you’ll have the essential skills and expertise to design and implement effective data structures for various applications.
- Knowledge of data-centric design principles
- Create various data models: conceptual, logical, and physical
- Expertise in using diagramming techniques
- Knowledge of relational database models
- Handling temporal data
- Apply normalization techniques
- Understanding of Unified Data Model (UNL)
- Understanding of enterprise data modeling
Course Highlights
-
13 Structured Lessons Comprehensive coverage of core course objectives
-
21 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
315 Practice Questions Assessment tests with detailed answer rationales
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
13 Interactive Lessons · 46 topics01 Introduction 2 topics +
- Who Should Read This Course
- What the Course Covers
02 Introduction to Data Modeling 6 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
03 Relational Model Components 2 topics · 1 LiveLab +
- Conceptual and Logical Model Components
- Physical Model Components
1 LiveLab in this lesson — see the labs panel →
04 Data and Process Modeling 4 topics · 1 LiveLab +
- Data Model Diagramming Alternatives
- Process Models
- Unified Modeling Language (UML)
- Relating Entities and Processes
1 LiveLab in this lesson — see the labs panel →
05 Organizing Database Project Work 3 topics · 3 LiveLab +
- The Traditional Life Cycle
- Nontraditional Life Cycles
- The Project Triangle
3 LiveLab in this lesson — see the labs panel →
06 Conceptual Data Modeling 3 topics · 1 LiveLab +
- The Conceptual Modeling Process
- Creating the Model
- Evaluating the Model
1 LiveLab in this lesson — see the labs panel →
07 Logical Database Design Using Normalization 4 topics · 3 LiveLab +
- The Need for Normalization
- Applying the Normalization Process
- Denormalization
- Practice Problems
3 LiveLab in this lesson — see the labs panel →
08 Beyond Third Normal Form 4 topics · 2 LiveLab +
- Advanced Normalization
- Resolving Supertypes and Subtypes
- Generalizing Attributes
- Alternatives for Reference Data
2 LiveLab in this lesson — see the labs panel →
09 Physical Database Design 5 topics · 3 LiveLab +
- The Physical Design Process
- Designing Tables
- Integrating Business Rules and Data Integrity
- Adding Indexes for Performance
- Designing Views
3 LiveLab in this lesson — see the labs panel →
10 Alternatives for Incorporating Business Rules 4 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
11 Alternatives for Handling Temporal Data 3 topics · 1 LiveLab +
- Temporal Data Structures
- Calendar Data Structures
- Business Rules for Temporal Data
1 LiveLab in this lesson — see the labs panel →
12 Modeling for Analytical Databases 4 topics · 1 LiveLab +
- Data Warehouses
- Data Marts
- Modeling Analytical Data Structures
- Loading Data into Analytical Databases
1 LiveLab in this lesson — see the labs panel →
13 Enterprise Data Modeling 2 topics · 1 LiveLab +
- Enterprise Data Management
- The Enterprise Data Model
1 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
21 LiveLabs- Creating a Conceptual Model
- Creating a Physical Data Model
- Creating a Logical Data Model
- Modifying a Conceptual Model
- Drawing of a Conceptual Model with Nested Subtypes
- Discussing the Traditional Life Cycle and Requirements Gathering
- Testing the Knowledge of Project Database Management Tasks
- Discussing Nontraditional Life Cycles and the Project Triangle
- Creating a Conceptual Model for the Employee Management System
- Creating a Data Model in Second Normal Form
- Creating a Data Model in First Normal Form
- Analyzing Normalization in Academic Tracking Database
- 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
- Modeling Business Rules in a Logical Data Model
- Adding History to Data Models
- Designing a Star Schema Fact Table
- Developing an Enterprise Conceptual Model
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
What is this Data Modeling online course about?+
It is an intermediary level course that focuses on design and implementation of effective data structure models for various applications.
What are the various data modeling techniques I will learn here?+
This Data Modeling Certification course introduces you to an array of modeling techniques including:
- Entity-Relationship (ER) Modeling
- Data Flow Diagrams (DFDs)
- Unified Modeling Language (UML)
- Normalization & Denormalization Processes
- Data Warehousing & Data Marts
- Enterprise Data Modeling
Will I get a certification on completing this data modeling course?+
Yes, you’ll be awarded a certificate of completion.
What kind of resources are available for learning data modeling?+
There’s plenty of interactive study material available with this course including hands-on Labs, video lessons, gamified test-prets, glossary, flashcards, quizzes, and pre and post assessments.
Will there be any exams with this Data Modeling course?+
Yes, there are pre and post assessments included with the course.
How will I practice Data Modeling concepts?+
No need to worry about your practice. This course is fully equipped with hands-on-Labs that enables you to practice your learning in a safe environment.
Explore The Fascinating World Of Data Modeling!
Gain the practical skills and knowledge required for creating functional Data Models.
- 1 year of full access
- 21 LiveLab included
- Certificate of completion