S Data Modelling and Design
This course covers the data modeling and design principles with primary focus on entity-relationship, normalization, and how to design and implement data models.
STUDENTS WILL LEARN TO
- Introduce Data Modeling
- Create the Entity-Relationship Model
- Perform Normalization
- Design and Implement Data Models

Phone
|
Phone
|
---|---|
Product
|
Oracle
|
Code
|
D1101174GC10
|
Duration
|
2 Days
|
Price (baht)
|
36,900
|
About the course
COURSE OUTLINE
MODULE 01 Introduction to Modeling
- Introduction to Modeling
- Why Model?
- Project Phases and Model Transitions
- Function Model Terminology
- Practice 1-1: Identify Key Business Information
- Practice 1-2: Identify Candidate Entities and Attributes
MODULE 02 Create the Entity-Relationship Model
- Create the Entity-Relationship Model
- Identifying Entities
- Identifying Relationships
- Relationship Types
- Uniquely Identifying Entity Instances
- Refactoring Attributes as Entities
- Supertype-Subtype Entities
- Validating Unique Identifiers
- Master-Detail, Classification, and Basket Patterns
- Practice 2-1: Create the Initial ER Model
- Practice 2-2: Verify and Improve the ER Model (Part 01)
- Practice 2-2: Verify and Improve the ER Model (Part 02)
MODULE 03 Normalization
- Normalization
- Relational Database Principles
- ONF to 1NF Transition
- Practices for Lesson 3
MODULE 04 Design and Implement Data Models
- Design and Implement Data Models
- From Analysis to Design to Implementation
- Entity to Table Model Transition
- Single Table Subtype-Supertype Implementation
- Denormalization
- Entity to Unified Modeling Language (UML) Class Model Transition
- Practices for Lesson 4
Register for Training
Schedule
Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
---|