⛁

Student Database with CRUD

DBMSBeginner

SQLMySQL

💡 Overview

CRUD (Create, Read, Update, Delete) is the foundation of almost every real-world application that stores data. This project builds muscle memory for the SQL you'll use constantly in DBMS exams and interviews.

✅ Features to Build

0/4 done

🧭 Step-by-Step Guide

Design the table: CREATE TABLE Students (ID INT PRIMARY KEY, Name VARCHAR(50), Course VARCHAR(50), Marks INT);

Insert at least 10 sample rows using INSERT INTO statements.

Write SELECT queries with WHERE, ORDER BY, and LIKE to practice filtering and searching.

Write an UPDATE query to change a specific student's marks.

Write a DELETE query with a WHERE clause (never run DELETE without WHERE!) to remove a specific student.

🚀 Starter Code

CREATE TABLE Students (
  ID INT PRIMARY KEY,
  Name VARCHAR(50),
  Course VARCHAR(50),
  Marks INT
);

INSERT INTO Students VALUES (1, 'Aarav', 'CS', 88);

SELECT * FROM Students WHERE Marks > 75 ORDER BY Marks DESC;

💡 Pro Tip

Always write and mentally check your WHERE clause before running UPDATE or DELETE — running them without a WHERE clause accidentally is one of the most common (and painful) real-world SQL mistakes.

← Back to all Projects