Training

All new methodology
Course description
Course outline

All new methodology

NoSQL data modeling methodology

Agile Query-Driven Data Modeling for NoSQL

At the request of many of our enterprise customers, we have developed a comprehensive course on data modeling for NoSQL databases. The course is mostly vendor-neutral, with only the last 20% focused on advanced features of Hackolade.

Data modeling has been under pressure in the context of Agile development and NoSQL, with modelers sometimes feeling left out of the process. It is necessary to re-invent data modeling to make it relevant again!

Read our blogpost Data Modeling is Dead... Long Live Schema Design!.

Testimonials

"Thank you, Pascal, for inspiring and leading the way to instantiate a thoughtful modeling approach within NoSQL space. I enjoyed your class and look forward to implementing the concepts in every-day-work." Natalia Clower, Data Management Services, Microsoft

"Thank you so much for delivering the course and the great disruptive messages! Your provoking perspectives really help! We are changing the culture with the new Agile/DDD/modernization path that my organization has committed to. Your class helps us greatly not only in NoSQL modeling principles, but building and forming the new culture that aligns with the new direction."
Lead Information Architect, Fortune 100 insurance company

Course description

The JSON-based dynamic-schema nature (aka schema-less nature) of document NoSQL databases is a fantastic opportunity for application developers: ability to start storing and accessing data with minimal effort and setup, flexibility, fast and easy evolution. But moving to NoSQL requires a mind-shift, a new methodology, and new tools to leverage new capabilities such as: polymorphism, embedding, denormalization, and sharding. This data modeling course highlights the differences in the lifecycle, purpose, roles, and approach for data modeling for NoSQL in an Agile development environment. It covers in depth the design patterns and modeling techniques for various representative use cases and illustrates the patterns and best practices, including specific aspects of different NoSQL database vendors.

Learning objectives

  • This class is a complete data modeling course for NoSQL, containing practical techniques for producing NoSQL physical data models.
  • Participants will learn NoSQL schema design patterns applied to different illustrative use cases, including the migration from relational SQL schemas to denormalized schemas optimized to leverage the capabilities of NoSQL technology.
  • Participants will learn not only how to build a NoSQL physical data model, but how to build it well, taking into account the differences with traditional SQL data modeling, as well as taking into account NoSQL vendor-specific aspects.
  • The course also includes hands-on training for the Hackolade application, including exercises with general as well as advanced features.

Length

2-day course

Target audience

Anyone with one or more of these terms in their job title: "data", "information", "analyst", "architect", "developer", "database", "DBA", and "modeler"

Course outline

The course assumes some prior experience in data modeling for relational databases, but assumes no prior in-depth knowledge of NoSQL databases.
Most topics are illustrated by hands-on exercises and quizzes. The course is not a programming course!

  • Introduction

  • Data Modeling Basics

  • Why NoSQL?

  • NoSQL Data Modeling

    • Why re-invent Data Modeling?

    • The Hackolade methodology

    • Step-by-Step process

    • Domain-Driven Design

      • Workflow design
      • UX/UI design
      • Patterns & constraints
  • Data Modeling with Hackolade

    • Application overview
    • Modeling philosophy
    • Terminology
    • UI fundamentals
    • Advanced features
  • NoSQL Physical Data Modeling

    • JSON: embracing the document model

    • Document databases

      • Guiding principles & key levers
      • Schema design patterns
      • Physical document design and style guide
      • Vendor-specific aspects
      • Optimization
    • Property graph databases

      • Graphs are Everywhere!
      • Physical Schema Design
    • Column-Family databases

      • HBase

      • Cassandra 

        • Features
        • Use cases
        • Data modeling principles
        • Best practices
    • Big Data storage formats

      • Avro

        • Overview
        • Schema evolution
        • Styling guide
        • Guiding principles & key levers
      • Parquet

        • Overview
        • Schema evolution
        • Best practices
    • Big Data Analytics

      • Hive table design

        • Overview
        • Data modeling
        • Table design best practices
      • Snowflake

        • Overview
        • Best practices
    • Swagger/OpenAPI contract design

      • APIs and API documentation
      • Code-first or Contract-first
      • Components of an API documentation
      • Styling guide
      • Model-Driven API generation

Contact us at info@hackolade.com for more information