SQL · LEVEL 0 — BASICS

1. INTRODUCTION TO DATA

Understand what Data is, what Information is, and how both concepts are related in SQL & Databases.

Sign into track your progress

What is Data?

1. Introduction

Every application we use generates or stores some details. These details are called Data. For example, names, phone numbers, marks, prices, and ages are all examples of Data.

2. Definition

Data is a collection of raw facts and figures that have not yet been processed or organized into meaningful information.

3. Explanation

Data represents individual details about something.

For example, consider these values: 85 90 75

These numbers are Data. They represent marks, but we don't know whose marks they are or what they represent.

Data can be available in different forms:

Text – Student names, addresses.
Numbers – Age, marks, salary.
Images – Photos, profile pictures.
Audio – Voice recordings.
Videos – Recorded videos.

4. Real-Time Example: Example: Instagram

When you create an Instagram account, you provide details such as:

Username
Email address
Password
Profile picture
Date of birth

All these details are considered Data. Instagram stores this Data to create and manage your account.

5. Practical SQL Example

Data is stored inside Database Tables. Consider a table named Students.

Table: Students

student_id	name	age	marks
1	Ravi	20	85
2	Priya	21	90
3	Kumar	20	75

SQL QUERY

SELECT * FROM Students;

SELECT – Used to retrieve data.

* – Selects all columns.

FROM Students – Retrieves data from the Students table.

Expected Output:

student_id	name	age	marks
1	Ravi	20	85
2	Priya	21	90
3	Kumar	20	75

What does this output tell us? The query retrieves all student records stored in the Students table.

6. Real-World Scenario: Scenario: College Management System

Imagine a college collecting student details during admission. It collects:

Student Name
Roll Number
Age
Phone Number
Branch

These individual details are stored as Data in the college Database. Later, the college uses this Data to prepare attendance reports, marksheets, and student records.

7. Important Points

Data means raw facts and figures.
Data can be numbers, text, images, audio, or videos.
Individual data values may not provide complete meaning.
Data is stored and managed in Databases.
Data is the basic input used to generate Information.

What is Information?

1. Introduction

We collect Data from different sources, but raw Data alone may not always help us make decisions. When Data is processed and organized into a meaningful form, it becomes Information.

2. Definition

Information is processed and organized Data that provides meaningful results and helps us understand something or make decisions.

3. Explanation

Information is created by processing raw Data.

Let's understand with an example.

Suppose three students scored the following marks: 85, 90, 75 These are raw Data.

After processing the marks: Total Marks = 250 Average Marks = 83.33 Highest Marks = 90

Now we can understand the students' performance. This meaningful result is called Information.

Raw Data
   |
   v
Processing
   |
   v
Meaningful Information

4. Real-Time Example: Example: YouTube

YouTube collects Data about your activity:

Videos watched
Likes
Search history
Watch time

YouTube processes this Data to understand your interests. For example: If you frequently watch JavaScript tutorials, YouTube may recommend more JavaScript and programming videos. Your viewing activity is Data. The personalized recommendations are Information generated through processing that Data.

5. Practical SQL Example

Consider the same Students table. Suppose we want to calculate the average marks of all students.

Table: Students

student_id	name	age	marks
1	Ravi	20	85
2	Priya	21	90
3	Kumar	20	75

SQL QUERY

SELECT AVG(marks) AS average_marks
FROM Students;

SELECT – Retrieves the result.

AVG(marks) – Calculates the average of student marks.

AS average_marks – Gives a name to the result column.

FROM Students – Uses data from the Students table.

Expected Output:

average_marks
83.3333

What does this output tell us? The average marks of the three students are approximately 83.33. Instead of looking at individual marks, we now understand the overall student performance. This meaningful result is Information.

6. Real-World Scenario: Scenario: Banking Application

Imagine a bank collecting transaction Data:

Transaction	Amount
Deposit	₹5,000
Withdrawal	₹2,000
Deposit	₹3,000

Total Deposits = ₹8,000

Total Withdrawals = ₹2,000

Net Increase = ₹6,000

The bank processes these transactions to calculate the account balance changes. The calculated result helps the customer understand their financial activity. This meaningful result is Information.

7. Important Points

Information is processed Data.
It provides meaningful results.
It helps people understand situations.
It supports decision-making.
Information is generated from Data.

Data vs Information

1. Introduction

Data and Information are closely related, but they are not the same. Data represents raw facts, whereas Information represents meaningful results obtained after processing Data.

2. Definition

Data: Raw facts and figures that may not have a clear meaning individually. Information: Processed Data that provides meaning and helps us understand something.

3. Explanation

Let's understand using a simple student marks example.

Suppose three students scored: 85, 90, 75 These values are Data.

Now, calculate the total and average: Total = 250 Average = 83.33 Highest Marks = 90

These results are Information because they help us understand student performance.

       DATA
    85, 90, 75
        |
        v
    Processing
        |
        v
   INFORMATION
   Total = 250
   Average = 83.33
   Highest = 90

4. Real-Time Example: Example: Amazon

Amazon collects Data about customer activities:

Products purchased.
Product prices.
Customer ratings.
Order dates.

After processing this Data, Amazon can generate Information such as: Best-selling products, Total sales, Most popular categories, Customer buying patterns. This Information helps Amazon understand customer interests and improve business decisions.

5. Practical SQL Example

Let's use the same Students table to see the difference in SQL.

Table: Students

student_id	name	age	marks
1	Ravi	20	85
2	Priya	21	90
3	Kumar	20	75

SQL QUERY

SELECT name, marks
FROM Students;

Expected Output:

name	marks
Ravi	85
Priya	90
Kumar	75

Query 1: Retrieve Raw Data. This output shows individual student marks.

Query 2: Generate Meaningful Information

SQL QUERY

SELECT 
    COUNT(*) AS total_students,
    AVG(marks) AS average_marks,
    MAX(marks) AS highest_marks
FROM Students;

COUNT(*) – Counts the total number of students.

AVG(marks) – Calculates average marks.

MAX(marks) – Finds the highest marks.

Expected Output:

total_students	average_marks	highest_marks
3	83.3333	90

What does this output tell us? The first query retrieves individual student records (Data). The second query processes student records and generates meaningful results (Information).

6. Real-World Scenario: Scenario: College Examination System

A college stores marks of thousands of students.

Step 1: Data Collection

The college collects individual student marks.

Step 2: Data Processing

The system calculates: Average marks, Highest marks, Lowest marks, Pass percentage.

Step 3: Information Generation

The college generates a performance report. Teachers and management use this Information to understand student performance and identify areas that need improvement.

Information enables targeted academic intervention.

7. Important Points

Data represents raw facts and figures.
Information is processed Data.
Data is the input; Information is the meaningful result.
Data alone may not provide a complete understanding.
Information helps in analysis and decision-making.

Comparison Table

Data	Information
Raw facts and figures.	Processed and meaningful Data.
May not provide clear meaning.	Provides meaningful results.
Used as input for processing.	Generated after processing Data.
May be unorganized.	Usually organized and structured.
Example: 85, 90, 75	Example: Average = 83.33