Data Modeling and ERD Mastery

Data Modeling Concepts → Normalization và Data Dictionary → Migration Planning và Data Quality → Bài 4 — Entities — Định nghĩa và Loại entity → Bài 5 — Attributes — Loại và Constraints → Bài 6 — Primary Keys — Natural, Surrogate, Composite → Bài 7 — Relationships — One-to-One, One-to-Many, Many-to-Many → Bài 8 — Cardinality Notation — Crow's Foot, Chen, UML → Bài 9 — Conceptual Data Model — High-level Business View → Bài 10 — Logical Data Model — Normalized Detailed Model → Bài 11 — Physical Data Model — DBMS-Specific Implementation → Bài 12 — Normalization — 1NF Cơ Bản → Bài 13 — Normalization — 2NF Partial Dependencies → Bài 14 — Normalization — 3NF Transitive Dependencies → Bài 15 — Denormalization — When and Why → Bài 16 — ERD Tools — Lucidchart, draw.io, dbdiagram → Bài 17 — Data Dictionary — Documenting Attributes → Bài 20 — Subtypes & Supertypes (Inheritance) → Bài 21 — Self-Referencing & Hierarchical Data → Bài 22 — Audit Tables & Temporal Data → Bài 23 — Indexes & Performance Tuning → Bài 24 — Constraints & Business Rules → Bài 25 — Data Modeling cho Vietnamese Addresses → Bài 26 — Data Modeling cho Vietnamese Names → Bài 27 — Money & Currency Data Modeling → Bài 28 — Dates, Times, Timezones → Bài 29 — JSON & Semi-structured Data → Bài 30 — Data Migration Modeling → Bài 31 — Data Warehouse & Star Schema → Bài 32 — Integration with Requirements Documentation → Bài 33 — Common Patterns — Inventory, Booking, Approval → Bài 34 — Database Design Best Practices → Bài 35 — Reviewing Existing Schemas → Bài 36 — Performance Considerations cho BA → Bài 37 — NoSQL & Polyglot Persistence → Bài 40 — Workshop Facilitation cho Data Modeling → Bài 41 — Anti-patterns trong Data Modeling → Bài 43 — Mermaid ERD as Code → Bài 44 — Schema Evolution & Migration Strategies → Bài 45 — Data Integration Patterns → Bài 46 — Data Quality Dimensions → Bài 47 — Privacy by Design — PDPL Compliance → Bài 48 — Reporting Database vs OLTP → Bài 49 — Capstone Project Setup → Bài 50 — Tổng kết Data Modeling → Bài 52 — Data Architect Career Path → Bài 53 — Data Governance Basics → Bài 54 — Common Interview Questions for Data BA → Bài 55 — Continuous Learning & Resources → Bài 59 — Industry Case Studies → Bài 60 — Course Wrap-up & Next Steps →

ERD cho Hệ Thống Ngân Hàng VN →

ERD cho E-commerce VN →

ERD cho Insurance VN →

ERD cho Education LMS →

Normalization Exercise →

SQL DDL Patterns →

Open Datasets →

AI-Assisted Data Modeling →

Final Submission Template →