COMN0: Modeling NoSQL and SQL with COMN Learning Plan
In the Modeling NoSQL and SQL with COMN Learning Plan, instructor Ted Hills identifies the goals of Data Modeling and prepares you for new concepts using Concept and Object Modeling Notations (COMN). Within the six-course program, you will learn how to represent real-world models based on COMN, model objects within a computer’s memory or storage, and dive into modeling requirements and their expressions in data. By the end of this program, you will understand the differences between SQL and NoSQL and between different transaction processing models (ACID/BASE), as well as how to model each in a data-centric organization, whether using a document database or data warehouse. If all six courses are completed, a certificate of completion will be issued.
Learning Plan Price: $489
Individual Course Prices: $79 - $99
Learning Plan CEUs: 4.5 hours
Each Course Includes:
- A 22- to 71-minute educational training video
- A 16- to 28-question exam
- Materials made available for download once the exam has been completed
- Self-paced and on-demand e-learning
- Unlimited course access
Courses within the COMN Learning Plan:
- Setting the Stage for Modeling Notations
- Modeling the Real World
- Modeling Things Inside the Computer
- Data Modeling
- NoSQL and SQL Physical Data Modeling
- The Common Coffee Shop
We offer several bulk licensing options for corporate and group use.
Contact us for a follow-up discussion!
THIS LEARNING PLAN IS IN PART RECORDED FROM A LIVE SEMINAR
Modeling NoSQL and SQL with COMN
COMN 1: Setting the Stage
- Goals and Introductions
- Theory and Practice
- Why Model?
- NoSQL Databases are Schema-on-Read, so Why Model?
- Potential NoSQL Dead Ends
- Big Data Turns Modeling on Its Head!
- What are Analysis and Design?
- Logical design
- Physical design
- Stepwise Refinement—the Agile Way
- The Terminology Problem
- The vocabulary of data is large and complex
- Overloaded words (too many meanings)
- Contradictory meanings
- New system of terminology replaces the old
COMN 2: Modeling the Real World
- Objects and Composition
- Varieties of Composites
- Collection and Containment
- Concepts and Their Representations
- Representations and Instances
- Components of Concepts
- Shared Concepts
COMN 3: Modeling Things Inside the Computer
- States and Representation
- The Old North Church (example)
- The Flashlight (example)
- Normal Representation Relationships
- Definitions
- Logical Data Design
- Physical Data Design
- Representations of Representations
- What’s the Type?
- Representation Type
- Representations of Objects
- A value can represent an object
- The states of multiple objects can represent the same value
- The collection of records, not the key type, represents the real-world class.
COMN 4: Contextual and Logical Data Modeling
- Modeling the Problem Space: Subtypes
- Subtyping a Deck of Cards
- Subtyping: The Pentagon Symbol
- Modeling the Solution Space: Entities and Roles
- Modeling the Solution Space: Data Attribute Roles
- Representing Self-Referencing Data Relationships
COMN 5: NoSQL and SQL Physical Data Modeling
- NoSQL and SQL DBMSs: What’s Different?
- ACID: The Traditional Approach
- The CAP Theorem and BASE
- How do you choose?
- Modeling Various NoSQL Database Types
- Key/Value
- Graph
- Document
- Columnar
- Tabular
- Containers and Indexes
COMN 6: The Common Coffee Shop
- Contextual Model
- The Context: The Common Coffee Shop
- Objects and Concepts
- Order Real-World Model
- Product Class Model
- Logical Data Model
- Physical Data Models
- COMN Quick Reference
- COMN Polygons
- Non-Composition Relationship Lines
- Restriction (Subtyping) and Extension
- Composite Entities Showing Components
Milestone
Complete All Six COMN Courses
1. COMN1: Setting the Stage for COMN
required
Course
In this course, we will review the general goals of Data Modeling and prepare our minds to accept the concepts on which the notation rests. After completing this course, you will understand why we bother to model data, and will be able to explain the difference between analysis, logical design, and physical design, thus preparing you to tackle the terminology problem that comes with utilizing the Concept and Object Modeling Notation (COMN).
View Details2. COMN2: Modeling the Real World
required
Course
In this course, you will learn how to use COMN graphical symbols to represent the concepts and objects that exist in the real world, which will help you to describe the context for any set of requirements. You’ll learn what collection and containment are, how they differ, and how to model the representations in COMN. When the course is completed, you’ll understand objects and their modes of composition, as well as how to represent them using COMN symbols.
View Details3. COMN3: Modeling Things Inside the Computer
required
Course
In this course, you will use Concept and Object Modeling Notations to visualize and model the objects within a computer’s memory or storage. Instructor Hills discusses how to represent concepts and objects in the real world, and will build on your understanding of how the physical state of the objects are represented, and how to model those representations. You will complete the course with an understanding of representations, how they can represent themselves, and how objects are represented in data.
View Details4. COMN4: Data Modeling
required
Course
In this course, you will study practical examples of modeling requirements and their expression in data. You’ll gain a thorough understanding of model subtypes, entities, their roles, and how data attributes play a role too.
View Details5. COMN5: NoSQL and SQL Physical Data Modeling
required
Course
Explore the differences between NoSQL and SQL, ACID and BASE, and CAP Theorem, and discover the performance trade-offs of each. Throughout this course, you’ll learn how to model data containers and indexes, as well as key/value, columnar, document, graph, and tabular data models.
View Details6. COMN6: The Common Coffee Shop
required
Course
In this course, you’ll work through an example of modeling an order capture document database and analytical data warehouse. You will learn how to apply COMN to a realistic problem found in NoSQL and SQL databases; examine COMN models for requirements, logical data, and physical databases; and identify how the unifying notation enables traceability of requirements in two unique database implementations.
View DetailsSubscription Purchase Options
Become a DATAVERSITY Insider when you subscribe and gain access to a host of special content.
Share This
Whats Included
Access your courses anytime, anywhere, with a computer, tablet or smartphone
Videos, quizzes and interactive content designed for a proven learning experience
Unlimited access. Take your courses at your time and pace
© 2026 DATAVERSITY Digital, LLC.