🚀 Exploring Advanced SQL Operations in Oracle Autonomous Database (Free Tier)

As part of my ongoing learning journey with Oracle Cloud, I continued exploring Oracle Autonomous Database by performing more advanced SQL operations. This hands-on activity helped me understand how real-world database systems handle data updates and deletions.

---

🎯 Objective

The goal of this exercise was to:

• Perform advanced SQL operations

• Understand how data is updated and deleted

• Gain deeper practical experience with Oracle SQL

---

💻 Step 1: Creating a New Table

I created a table named courses to simulate a simple course management system.

CREATE TABLE courses (
  course_id NUMBER,
  course_name VARCHAR2(50)
);

---

🧪 Step 2: Inserting Data

INSERT INTO courses VALUES (101, 'Database Systems');
INSERT INTO courses VALUES (102, 'Operating Systems');

📊 Step 3: Viewing Data

SELECT * FROM courses;

This displayed the inserted records successfully.

🔄 Step 4: Updating Data

UPDATE courses 
SET course_name = 'Advanced Database Systems' 
WHERE course_id = 101;

This operation modified an existing record, demonstrating how data can be updated dynamically.

❌ Step 5: Deleting Data

DELETE FROM courses WHERE course_id = 102;

This removed a record from the database.

📈 Final Output

SELECT * FROM courses;

The final result showed only the updated record, confirming successful execution of all operations.

💡 What I Learned

• How to perform UPDATE and DELETE operations in Oracle SQL

• Managing real-time database records

• Practical use of Oracle Autonomous Database

🚀 Conclusion

This activity strengthened my understanding of real-world database operations using Oracle Cloud. Practicing these SQL commands helped me gain confidence in managing and modifying structured data effectively.