🚀 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.
Top comments (0)