The publication takes a student from Entry level to Senior Data modeler in less than 8 weeks.
Breaks down the different phases of Data modeling (Conceptual, Logical, and Physical (Database Design) and scripts generation.
It's a great place to lift people from learners to producers, team contributors or data analysts in Application and or Analytics Development teams.
Quick Course to Data Modeling Expertise
- What is Data Modeling?
The relational model is widely used in relational databases in transactional systems, while the dimensional model is prevalent in data warehouses or decision support systems. This document will focus on transactional systems. A relational database consists of a set of relations
Data modeling is a process of graphically representing the data structures of a company's business requirements in a very powerful expression. This data model becomes the guide used by functional and technical analysts in the design and implementation of a database.
Data models are used for many purposes, from high-level conceptual models to physical data models.
- Data modelling explores data-oriented structures and identifies entity types. Unlike object-oriented development, class modelling identifies classes with their operational methods.
- Three basic styles of data modelling generally used in practice today are:
- Conceptual Data Models: High-level, static business structures and concepts.
- Logical Data Models (LDMs): Entity types, data attributes and relationships between entities.
- Physical Data Models (PDMs): The internal schema of database design
A database model is primarily a type of data model. Depending on the model in use, a database model can include entities, their relationships, data flow, tables, and more. Other popular database models than relational ones include hierarchical models, flat file models, object-oriented models, NO-SQL, and network models. For example, within a hierarchal database model, the data model organizes data in the form of a tree-like structure having parent and child segments.
This document will focus on Relational Modeling. The NO-SQL database modeling will be dealt with in the “Non-Relational” modeling Convention document.