2a': Data Modeling

A semantic layer is a semantic data model that shows to the business user: a dimensional view (dimensional schema) from a relational schema. It will create/model a logical star schema by: ...

Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you’ll learn what these terms are, so you can communicate better with ot…

This article covers the basics of OLAP Cubes implementation using the SQL Server Analysis Service.

In this article, we will learn how to create your first cube from scratch using SQL Server Analysis Services (SSAS)

In Microsoft Analysis Services there are two model types: the Multidimensional and the Tabular. In this video, we'll explain what the difference is and which should you choose?

Download a free trial of our On-Demand Training Platform: http://pragmaticworks.com/Training/On-Demand-Training?hsCtaTracking=6bdedee8-b89b-420b-883d-37d9e6d...

This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.

Confused about ERD Shapes? Check out this guide for a comprehensive look at all ER diagram symbols and notation.

A Practical Introduction to Databases, an open educational resource textbook.

Diagrams and explanations showing the difference between non-identifying (dashed line) and identifying (solid line) relationships in relational database design

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Start by learning the meaning of the relational database. A relational database is a type of database that stores and provides access to…

An Entity-Relationship Diagram (ERD) is a visual layout of the structure of a database. It shows the relationships between different…

Data modeling is a technique to document a software system using entity relationship diagrams (ER Diagram) which is a representation of the data structures in a table for a company’s database. It is a very powerful expression of the company’s business requirements. Data models are used for many purposes, from high-level conceptual models, logical to …

I have a problem with second normal form (2NF) and I have been unable to solve it by using Google. It is making me crazy because I am a teacher and I don't want to teach wrong stuff to my students....

In relational databases, especially large ones, you need to arrange entries so that other maintainers and administrators can read them and work on them. This is why database normalization is important. In simple words, database normalization entails organizing a database into several tables in order to reduce redundancy. You can

This tutorial covers the basics of data pipelines and terminology for aspiring data professionals, including pipeline uses, common technology, and tips for pipeline building.

Learn how data pipelines provide the foundation for both simple and complex analyses.

Data lives at the heart of every modern system, but how do we organize and understand it? That’s where data models come in, blueprints for…

Data modeling is the process of creating a visual representation of an information system to communicate connections between data points and structures.