1.1 What is Data?

Level: 1 | Version: v1.1 | Author: Meptrasoft

Overview

Before learning SQL and databases, we first need to understand data.

Data is the basic information that computer systems collect, store, process, and use.

Examples from a college:

Student Name
Student ID
Age
Department
Marks
Attendance
Email

Data is a collection of facts or values that can be stored, processed, and used to obtain useful information.

Real-World Example: Student Mark Sheet

Consider a college mark sheet:

Values such as Arun, Python, and 85 are data.

When we process the data, we can answer:

Highest mark?
Class average?
Who scored above 80?

RAW DATA
   ↓
PROCESSING
   ↓
USEFUL INFORMATION

What Can Be Data?

Data can have many forms:

Data in Everyday Life

When you order food, an application may collect:

Customer Name
Restaurant
Food Item
Quantity
Price
Delivery Address
Order Time
Payment Status

The system can process this data into:

Order Total = ₹450
Payment Status = Successful
Delivery Status = Out for Delivery

Data vs Information

Data is a raw value.

45

Information gives that value meaning.

Student Mark = 45

Example:

Raw Data:
45, 80, 90, 70, 95

After Processing:
Highest Mark = 95
Average Mark = 76

Data → Raw value
Information → Meaningful processed data

Where Is Data Stored?

Data can exist in:

Files
CSV
Excel
Applications
Databases
Cloud Storage

When data becomes large and needs organized storage and querying, databases become useful.

DATA
  ↓
DATABASE
  ↓
SQL
  ↓
RESULT

Data in a Database

A database table organizes data into rows and columns:

SQL can then retrieve required data:

SELECT Name, Marks
FROM Students
WHERE Marks > 80;

Result:

Data vs Database

DATA
→ Actual values

DATABASE
→ Organized system for storing and managing those values

Data is the content; a database organizes and manages the content.

Common Beginner Mistakes

Placement Quick Points

DATA        → RAW FACTS / VALUES
INFORMATION → MEANINGFUL PROCESSED DATA
DATABASE    → STORES AND MANAGES DATA
SQL         → WORKS WITH DATABASE DATA

• Data is the basic input used by computer systems.
• Data can exist in many forms.
• Processing and context can turn data into useful information.
• A database organizes and manages data.
• SQL is used to work with data stored in relational databases.

Interview Questions

What is data?

Data is a collection of raw facts or values that can be stored and processed.

Give examples of data.

TEXT

Name → Arun
Age → 20
Marks → 85
Department → CSE

Images, audio, video, and documents can also be data.

What is the difference between data and information?

TEXT

Data        → Raw facts
Information → Meaningful processed data

Can data exist without a database?

Yes. It can exist in files, CSVs, Excel, applications, documents, memory, and other storage systems.

What is the relationship between data, database, and SQL?

TEXT

DATA
 ↓
DATABASE
 ↓
SQL
 ↓
RESULT

Practice & Hands-On Exercises

1. Define data in your own words.
2. Give five examples of college data.
3. Give three examples of data collected by a food delivery app.
4. Explain data vs information with your own example.
5. Explain:

Data → Database → SQL → Result

6. Identify three pieces of data from a student table.
7. Explain why 100 may need context before it becomes meaningful information.

💡 Tip: Test your queries using the in-browser interactive runner above.

Key Takeaway

DATA
↓
RAW FACTS / VALUES
↓
DATABASE
↓
SQL
↓
USEFUL RESULT / INFORMATION

Data is the foundation of databases. SQL is one of the main tools used to work with that data.

End of What is Data?