Databases and Data Warehouses

Start with database basics

The page includes several mind maps called Database. One describes a database as a collection of data on a subject, with examples such as customers, products and incident reports. Another introduces databases as collections that can use tables. These maps offer a starting point for understanding what databases hold.

Next, look at the Databases mind map that covers primary keys, splitting data and normalization. It moves from the idea of a large group of data toward organizing it into smaller structures. Another map with the same title covers accessing, updating, searching and presenting data.

Explore schemas and data warehouses

The Data Management flashcards introduce conceptual, logical and physical schemas. They also cover terms such as weak entity type, composite attribute, identifier and cardinality constraints. After exploring the database maps, use the cards to check how well you recognize these terms.

The data management mind map on warehouses covers data marts, data storage systems, sources, data integration and storage architecture. Use it to explore how the page connects databases with data warehouses.

Connect the resources

Databases and Data Warehouses is a section of the Data Management and Governance unit in Databases and data science. The maps and flashcards offer different ways into that section: maps show connected ideas, while cards focus on individual terms.

There are no quizzes listed on this page. Instead, turn a few terms from the flashcards into questions, then return to the maps to review related ideas. Pick a map and a set of cards to begin.