A database is a structured collection of data managed by a database management system (DBMS). Databases store, retrieve, and manage data efficiently while maintaining integrity, security, and concurrency. Understanding why databases exist and their core purposes is essential before studying specific models and technologies.
Start with real-world examples of databases you interact with daily (email, social media, banking systems), then discuss the problems databases solve compared to file storage.
Databases are not just large spreadsheets. A database involves complex indexing, query optimization, and concurrent access that spreadsheets cannot handle efficiently.
Imagine you run a small business and keep all your records in files on your computer — customer names in one text file, orders in a spreadsheet, inventory in another. At first this works, but as the business grows, problems multiply. Two employees try to update the same file simultaneously and one overwrites the other's changes. Someone accidentally deletes a row and there's no way to undo it. Finding all orders from a specific customer requires scanning every line of the orders file. You need a report that combines customer and order information, and the only way to get it is manual copy-paste. A database management system (DBMS) exists to solve all of these problems systematically.
A DBMS provides four core capabilities that file-based storage cannot. First, structured data organization: data is stored according to a defined schema that enforces what types of data go where, preventing the garbage-in problems of freeform files. Second, efficient querying: instead of scanning every record, a DBMS uses indexes and query optimization to find the data you need in a fraction of the time. Third, concurrency control: multiple users can read and modify data simultaneously without corrupting each other's work, because the DBMS coordinates access behind the scenes. Fourth, durability and recovery: if the power goes out mid-operation, the DBMS can recover to a consistent state, something a file system cannot guarantee.
The concept of data independence is central to why databases are designed the way they are. A DBMS separates the logical structure of data (what tables exist, what columns they have) from the physical storage details (what files are used, how data is laid out on disk). This means an application can query "find all customers in New York" without knowing or caring whether the data is stored in one file or a thousand, whether there is an index on the city column, or whether the database is on a local disk or a remote server. When the database administrator reorganizes the storage for better performance, no application code needs to change.
Modern database systems come in many forms — relational databases that organize data into tables with rows and columns, document databases that store flexible JSON-like structures, graph databases optimized for relationship-heavy data, and more. But they all share the same fundamental mission: providing reliable, efficient, concurrent access to structured data while shielding applications from the complexity of storage and retrieval. Understanding this mission and these core capabilities is the foundation for everything else you will learn about databases.
This is a foundational topic with no prerequisites.
No prerequisites — this is a starting point.