Lesson Outcomes

After completing this lesson, learners will be able to:

Knowledge

  • Define a database

  • Identify database systems such as MySQL

Understanding

  • Explain how databases store and organise data

  • Understand how data is accessed and managed

Application

  • Differentiate between databases and spreadsheets

  • Apply basic concepts of data storage and access

Overview

Organisations generate and store large amounts of data. To manage this data efficiently, structured systems such as databases are used.

This lesson focuses on:

  • What databases are

  • How data is stored and accessed

  • The role of database systems

  • Differences between databases and spreadsheets

Understanding databases helps ensure that data is:

  • Organised

  • Accessible

  • Secure

  • Easy to manage

What is a Database?

Definition

A database is:

  • An organised collection of structured data

  • Stored electronically in a computer system

  • Managed using a Database Management System (DBMS)

Data in databases is typically:

  • Organised in tables

  • Arranged in rows and columns

  • Easy to search and update

👉 Databases allow efficient data storage and retrieval.

Database Systems

A database system includes:

  • The database (data)

  • The DBMS (management software)

  • Associated applications

👉 These components work together to manage data effectively.

What is MySQL?

Definition

MySQL is:

  • An open-source relational database management system

  • Based on Structured Query Language (SQL)

Features of MySQL

  • Supports large volumes of data

  • Handles multiple users

  • Commonly used in web applications

👉 MySQL is widely used for managing data in modern systems.

Data Storage and Access

Data Storage

Data is stored:

  • In structured formats (tables)

  • In organised systems for easy retrieval

Accessing Data

Data can be:

  • Retrieved

  • Updated

  • Modified

  • Controlled

👉 SQL is commonly used to access and manage data.

Importing Data

What is Data Import?

Data import is:

  • The process of bringing data from external sources into a system

  • Combining external data with existing data

Purpose of Data Import

  • Organise data for analysis

  • Improve business insights

  • Support decision-making

Databases vs Spreadsheets

Key Differences

  • Databases

    • Handle large volumes of data

    • Support multiple users

    • Allow complex queries

  • Spreadsheets

    • Suitable for small datasets

    • Typically used by single users

    • Limited in complexity

👉 Databases are more powerful and scalable than spreadsheets.

Importance of Databases

Databases are important because they:

  • Store large amounts of data

  • Allow efficient access and management

  • Support multiple users

  • Enable complex data analysis

Key Notes

  • A database is an organised collection of data

  • DBMS software manages databases

  • MySQL is a widely used database system

  • Data is stored in structured formats

  • Databases are more scalable than spreadsheets

PreviousNext