Lesson 2: Databases, Data Storage and Access to Data

Lesson Outcomes

By the end of this lesson, learners will be able to:

  • Describe what a database is and how it functions
  • Explain the role of database management systems (DBMS)
  • Identify components of a database
  • Understand characteristics of good-quality data
  • Explain how data is stored, accessed, and managed

Lesson Overview

This lesson introduces learners to databases and how data is stored, accessed, and managed. Databases are at the heart of modern systems — from banking apps to social media platforms — and understanding them is essential for anyone working with data or automation.

Learners will explore how databases are structured, how data is organised, and how quality data supports better decision-making in organisations.

1. What is a Database?

A database is an organised collection of data that is stored electronically and can be accessed, managed, and updated efficiently.

  • Small databases can exist on a single device
  • Large databases are hosted on servers or cloud systems
  • Used across industries like banking, healthcare, retail, and more

👉 In simple terms:
A database = a structured way to store and retrieve information quickly and reliably.

2. Database Management System (DBMS)

A DBMS is software used to:

  • Store data
  • Retrieve data
  • Manage and update data
  • Control access

Examples include systems like relational database software.

Key benefits of a DBMS:

  • Reduces data duplication
  • Ensures data consistency
  • Improves data security
  • Allows multiple users to access data safely

3. Components of a Database

A database system is made up of five main components:

  1. Hardware

    • Physical devices (computers, servers, storage devices)

  2. Software

    • DBMS, operating systems, and applications

  3. Data

    • Raw facts that are stored and processed

  4. Procedures

    • Instructions for managing and using the database

  5. Database Access Language

    • Used to interact with data (e.g., retrieving, updating)

4. Types of Databases

  • Relational Databases

    • Store data in tables (rows and columns)

    • Most widely used type

    • Uses structured query methods

  • Non-relational Databases (NoSQL)

    • Store unstructured or flexible data

    • Used for big data and real-time applications

5. Data Storage and Access

Data is stored in structured formats and accessed using:

  • Queries
  • Applications
  • Database tools

Databases can be:

  • Internal (used within an organisation)

  • External (accessed from outside sources, e.g., internet databases)

6. Characteristics of Quality Data

Good data is essential for decision-making. Key characteristics include:

  • Accuracy – reflects real-world values
  • Completeness – no missing data
  • Consistency – same across systems
  • Timeliness – up to date
  • Uniqueness – no duplication
  • Validity – follows rules and formats

👉 Think of bad data like bad ingredients… even the best chef (or system) can’t fix it.

7. Data Storage Concepts

Modern systems use different storage approaches:

  • Databases → store structured data
  • Data Warehouses → store large volumes for analysis
  • Cloud Storage → scalable and accessible anywhere

A data warehouse acts as a central hub for analysis and decision-making.

8. Why Databases Matter in RPA

For RPA developers:

  • Databases provide structured data for automation

  • Bots interact with databases to:

    • Read data

    • Update records

    • Generate reports

Without databases, automation would basically be guessing… and we don’t let bots freestyle like that 😄

Lesson Summary

In this lesson, you learned that:

  • Databases store and organise data efficiently
  • DBMS software manages and controls access to data
  • Data quality directly impacts decision-making
  • Structured storage systems like databases and warehouses are essential for modern systems
  • Databases play a key role in automation and RPA solutions
PreviousNext