Student Managment System

🚀 Hands-on SQL Practice with Oracle Live SQL (Step-by-Step)

I recently spent some time practicing SQL on Oracle Live SQL, and I want to share my journey with screenshots and code snippets. This exercise helped me understand DDL, DML, constraints, functions, joins, views, and stored procedures in a very practical way.

1️⃣ Creating Tables (DDL)

I started by creating the core tables: Students, Courses, Enrollments, and Faculty.

📸 Screenshot:

2️⃣ Inserting Data (DML)

I inserted a few sample students into the Students table.

📸 Screenshot:

3️⃣ Altering Tables

I added a new column PhoneNo to the Students table.

📸 Screenshot:

4️⃣ Constraints

I applied a CHECK constraint on the Courses table to ensure credits are always between 1 and 5.

📸 Screenshot:

5️⃣ Using SQL Functions

I practiced string functions by displaying student names in uppercase and checking the length of their emails.

📸 Screenshot:

📝 Lessons Learned

How to use DDL, DML, ALTER, and constraints effectively.

How to write aggregate queries and apply functions.

The importance of joins and views in simplifying queries.

A small stored procedure can automate updates like grade changes.

🎯 Next Steps

I’ll continue by experimenting with:

More complex joins (multi-table joins).

Writing nested queries and subqueries.

Exploring PL/SQL blocks for logic inside the database.