Beginner Topic 1 of 51 Databases
What is a Database
Organized collection of data managed for efficient access.
How it works
A database is an organized collection of data stored and accessed electronically, designed so that information can be queried, updated and shared reliably by many users and programs. Unlike a plain file, a database provides a structure or schema, indexes for fast lookup, rules that protect data integrity and mechanisms for concurrent access and recovery after failures. Databases can be relational, document, key-value, graph or specialized for time series and vectors.
Step-by-step walkthrough
- Many applications need the same data.
- They talk to a database instead of private files.
- The database stores data in an organized structure on disk.
- It enforces rules, handles many users and recovers after crashes.
- Backups protect against disasters.
Where it is used
Banks, shops, social networks, hospitals, airlines and almost every application store customer, order and content data in a database. Applications talk to it through a query language or API.
Common pitfall
Storing data in scattered spreadsheets or text files leads to duplicates, inconsistencies and lost updates. Treating a database as just a bigger file ignores transactions and constraints. Choose the model that matches your access patterns, plan backups and design the schema before writing application code.
Where it fits in the course
What is a Database is topic 1 of 51 in Databases, rated Beginner. It is the first topic in this area. The next topic is DBMS.
Practice and explore
- Open the interactive lesson, with a mini quiz.
- Take the Databases quiz.
How to study this topic
- Read the explanation above and restate the definition in your own words.
- Open the interactive lesson and answer its mini quiz.
- Read the common pitfall, then write a short example that avoids it.
- Check your understanding in the Databases quiz, and revisit the topic if you miss a question.
Frequently asked questions
What is What is a Database?
Where do people use What is a Database?
What is the most common mistake with What is a Database?
What should I learn before this topic?
How can I practice it?
Is What is a Database hard to learn?
How long does it take to learn What is a Database?
Which topics are related to What is a Database?
What should I study after What is a Database?
Related topics
- DBMS (Databases)
- Relational Model (Databases)
- Tables, Rows and Columns (Databases)
- Primary Keys (Databases)
- What is an Operating System (Operating Systems)
- What is a Network (Computer Networks)
- What is Artificial Intelligence (AI & Machine Learning)