Certified Business Data Modeler

This course includes
Lessons
TestPrep
Hands-On Labs

The Certified Business Data Modeler course is designed to equip you with the knowledge and skills necessary to excel as a professional data modeler. The course covers a wide range of topics essential for understanding and implementing effective data models in the business environment. The course helps you gain a deep understanding of data modeling concepts, principles, and methodologies. It helps you to explore techniques for analyzing business processes, identifying stakeholder requirements, and translating business needs into data model specifications.

Lessons

4+ Lessons | 31+ Exercises | 8+ Flashcards | 8+ Glossary of terms

TestPrep

1+ Full Length Tests | 31+ Practice Test Questions

Hands-On Labs

7+ LiveLab | 00+ Minutes

Video Lessons

24+ Videos | 04:29+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: SECTION I

  • PROLOGUE
  • Introduction to Data Modeling
  • Data Entity Types
  • Structured Entities
  • Data Attributes
  • Sample Solution Exercises
  • Data Mapping
  • Sample Solutions Exercise 5 Manufacturing Co
  • Sample Solutions Exercise 6 Insurance Co

Lessons 2: SECTION II

  • Introduction to Business Normalization
  • Normalization & the Relational Model
  • First Business Normal Form (1BNF) – Introduction
  • First Business Normal Form Exercise
  • Second Business Normal Form Exercise
  • Third Business Normal Form
  • Exercise 10 + Exercise 11
  • Fourth Business Normal Form
  • Fifth Business Normal Form
  • Normalization Exercise Sample Solutions - Exercises 1-10
  • Bonus - Normalization Exercise Sample Solutions - Exercises 11-13

Lessons 3: Review: Data Modeling

  • Introduction
  • The Entity Relationship Diagram
  • Creating an Entity Relationship Diagram
  • Validating an Entity Relationship Diagram
  • LESSON REVIEW
  • QUESTIONS
  • EXERCISES
  • MINICASES
  • Inventory Order
  • APPENDIX 5A: NORMALIZING THE DATA MODEL

Lessons 4: Certification Test

  • Visible Analyst

Hands-on LAB Activities

SECTION I

  • Getting to Know Visible Analyst®
  • Building Requirements Statements in Visible Analyst®
  • Building Repository Entries in Visible Analyst®
  • Defining process models in Visible Analyst®
  • Defining data models in Visible Analyst®
  • Defining structure charts / Adding physical details to DFDs in Visible Analyst®
  • Adding Physical Details to ERDs in Visible Analyst®