Fall Hours • COVID-19 Update

The Silicon Valley Campus is open 4–9:30 p.m. on Monday–Friday and 8 a.m.–5 p.m. on Saturday.

All campus visitors must be vaccinated, wear a mask, & submit a COVID symptom check. Visit our COVID page for updates.


Data Modeling, Introduction | DBDA.X421

Data modeling defines and applies structure to the information systems in an enterprise. Data stored in various relational databases needs data modeling to depict the relationship between entities in the databases. The models provide pictorial views of how the data flows across the enterprise, departments, or business areas. Before creating a database for any application, you need well-constructed data models to maintain the integrity of data and improve query performance. This course provides in-depth knowledge and hands-on practice in data modeling and design.

After introducing the basic concepts and principles, the course addresses data modeling techniques and practices in four modeling areas: conceptual, logical, physical and dimensional. The course first addresses the collection of user requirements, followed by design approaches for logical and physical models. You will study real-world examples of data models for transactional systems, data marts and enterprise data warehouses. Expert instructors will share their practical experiences.

This is a hands-on course using an industry-leading data modeling tool in class. By the end of the course, you will be able to create data models for enterprise applications.

Learning Outcomes:
At the conclusion of the course, you should be able to:

  • Describe the various types and advantages of Data Modeling
  • Discuss the quantifiable values of Data Modeling
  • Explain the intricacies of Data Modeling
  • Identify the use cases for Data Modeling

Topics Include:

  • Overview of data modeling
  • Principles of data modeling
  • Types of data modeling: Conceptual, Logical, and Physical
  • Logical data modeling: Building data models; Cardinality rules; Transformation rules
  • Physical data modeling: Database standards; Domains and classwords; Roll-ups and roll-downs; Data model repository options
  • Dimensional data modeling: Star schema modeling; Snow flake modeling
  • Top ten mistakes to be avoided

Have a question about this course?
Speak to a student services representative.
Call (408) 861-3860
  • Save your seat and help us confirm course scheduling. Enroll at least seven days before your course starts.
  • ACCESSING CANVAS—Learn more about accessing your course on Canvas in our FAQ section.
This course is related to the following programs:


Sections Open for Enrollment:

Open Sections and Schedule
Start / End Date Units Cost Instructor
01-28-2022 to 03-18-2022 2.0 $740

Sivakumar Mallari



Date: Start Time: End Time: Meeting Type: Location:
Fri, 01-28-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 02-04-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 02-11-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 02-18-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 02-25-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 03-04-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 03-11-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE
Fri, 03-18-2022 6:30 p.m. 9:30 p.m. Live-Online REMOTE