SQL - lesson 1 | HackIndia Skills

SQL - lesson 1 | HackIndia Skills | HackIndia

Example

Worked example

Feature: hostel students submit repair requests. The first version only needs one table.

You are not solving login, admin dashboards, or notifications yet. You are modelling the core data.

Feature: Hostel repair requests

User action:
A student reports a problem in their room.

Facts to store:
- student_name
- hostel_name
- room_number
- issue_title
- issue_description
- status
- created_at

Table:
repair_requests

Sample row:
Asha Nair | Ganga Hostel | B-204 | Fan not working | Fan stopped last night | open | 2026-09-20

Example

First schema file

Create a folder named sql. Put your first table design in sql/schema.sql.

This is only the model. Later lessons will improve it with keys and relationships.

CREATE TABLE repair_requests (
  student_name TEXT,
  hostel_name TEXT,
  room_number TEXT,
  issue_title TEXT,
  issue_description TEXT,
  status TEXT,
  created_at TEXT
);

Example

Seed data file

Seed data makes your repo easy to run and inspect. Add a few realistic rows, not private data from real people.

Use simple names and Indian campus examples if they fit your feature.

INSERT INTO repair_requests (
  student_name,
  hostel_name,
  room_number,
  issue_title,
  issue_description,
  status,
  created_at
) VALUES
('Asha Nair', 'Ganga Hostel', 'B-204', 'Fan not working', 'Fan stopped last night', 'open', '2026-09-20'),
('Rohan Mehta', 'Kaveri Hostel', 'A-118', 'Leaking tap', 'Water leaking near washbasin', 'open', '2026-09-20'),
('Iqbal Khan', 'Narmada Hostel', 'C-310', 'Tube light flickers', 'Light flickers during evening study time', 'closed', '2026-09-19');

Model one real feature

Start with a feature

One idea

Choose the scope

Worked example

First schema file

Seed data file

Common mistake

Do this now

Quick check