Databases introduction

Here is my best reconstruction of the notes, using what is visible in the image and filling in a few likely words based on standard database terminology.

1. Database Introduction

Date: 06/12/2026

What is a database?

A database is:

A platform to store any type of data (no size limit)

To perform CRUD activities

Easy data storage operations

(CRUD = Create, Read, Update, Delete)

Inside a Database

A database contains structures used to store and organize information.

Examples:

Tables

Views

Stored Procedures

Functions

Tables

Tables are structures used to:

Store

Organize

Manipulate

data in a database.

Types of Databases

1. OLTP

OLTP (Online Transaction Processing)

Characteristics:

Live / temporary data

Real-time data

Online transaction processing

Real-time results

Examples:

Banking transactions

ATM systems

E-commerce orders

2. DW / Data Warehouse

DW (Data Warehouse)

Characteristics:

Historical data

Large data storage

Used for reporting and analysis

Examples:

Business intelligence reports

Analytics systems

Decision support systems

Cleaned-up Class Notes Version

Database: A collection of organized data stored electronically and managed for easy access, retrieval, and manipulation.

Database Objects:

Tables

Views

Functions

Stored Procedures

Database Types:

OLTP

Data Warehouse (DW)

Real-time data

Historical data

Transaction processing

Reporting & analytics

Fast inserts/updates

Large-scale storage

Operational systems

Business intelligence

A few words in the image are too blurred to read with confidence, but the transcription above matches both the visible text and the standard content typically taught in an introductory database lesson.