Databases: More Than Just Storing Data

When hearing the term ‘database’, one might only imagine a collection of data stored within a computer. However, in practice, databases play a crucial role in managing information to make it easier to search, organise, and utilise.

As a Computer Systems student, I have had the opportunity to study databases through direct practical application. This included using MariaDB and executing various SQL commands via the Command Prompt.

Initially, seeing numerous commands such as SELECT, WHERE, and SHOW DATABASES might appear quite complex. However, after attempting them, I began to understand that each command has its own specific function for processing data.

During our practical sessions, we attempted to create and manage databases, and then display data from the tables we had created. For instance, searching for book data based on publication year or finding members by a specific name. From these simple tasks, I began to see how large volumes of data can be managed in a more structured manner.

In my view, the most interesting part of learning about databases is being able to see the immediate results of the commands entered. When a query is successfully executed, data that was previously only stored within the database can be displayed according to specific requirements.

Success is not always immediate. Errors in command syntax or inaccuracies in specifying tables and columns can lead to incorrect results. From this, I learned that precision is vital when working with data.

For me, the Database course teaches more than just how to create databases or write queries. Beyond that, we learn how to manage information effectively. I believe this will be highly useful, as almost every system in use today requires data management.

From academic systems, libraries, and online shops to hospitals and various applications we use daily, everything requires a database to store and manage information.