.jpg){kind=logo}
UOP-DSC530.AO1
Data Modeling
Self-paced · 1 year access
18 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 44 topics01 Data Modeling Concepts and Relational Model Component 8 topics · 4 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
- Conceptual and Logical Model Components
- Physical Model Components
4 LiveLab in this lesson — see the labs panel →
02 Data and Process Modeling and Organizing Database Project Work 7 topics · 1 LiveLab +
- Data Model Diagramming Alternatives
- Process Models
- Unified Modeling Language (UML)
- Relating Entities and Processes
- The Traditional Life Cycle
- Nontraditional Life Cycles
- The Project Triangle
1 LiveLab in this lesson — see the labs panel →
03 Conceptual Data Modeling and Logical Database Design Using Normalization 7 topics · 4 LiveLab +
- The Conceptual Modeling Process
- Creating the Model
- Evaluating the Model
- The Need for Normalization
- Applying the Normalization Process
- Denormalization
- Practice Problems
4 LiveLab in this lesson — see the labs panel →
04 Beyond Third Normal Form and Physical Database Design 9 topics · 5 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
05 Alternatives for Incorporating Business Rules and for Handling Temporal Data 7 topics · 2 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
- Temporal Data Structures
- Calendar Data Structures
- Business Rules for Temporal Data
2 LiveLab in this lesson — see the labs panel →
06 Modeling for Analytical Databases and Enterprise Data 6 topics · 2 LiveLab +
- Data Warehouses
- Data Marts
- Modeling Analytical Data Structures
- Loading Data into Analytical Databases
- Enterprise Data Management
- The Enterprise Data Model
2 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
18 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
- 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
- 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.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for Data Modeling
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 18 LiveLab included
- Certificate of completion
No credit card required