Database fundamentals

Learn the basics of data and databases.

Database fundamentals

A short overview of databases

How tables, rows, columns, and keys work together to make a database.

3 min read

Data types and metadata

Why data types matter and how metadata can help you better understand your data.

2 min read

Database table relationships

Understanding how tables in a database can relate to each other.

4 min read

Measures and dimensions

How to work with quantitative and qualitative fields in your queries.

3 min read

Analytics engineering for fact tables

How to model data for a fact table, based on real analytics use cases.

15 min read

Data normalization

What a normalized database looks like and why table structure matters.

7 min read

Data cubes

Thinking about your data in more than two dimensions.

3 min read