SQL & PL/SQL Lab – MSc Software Technology

This repository contains SQL and PL/SQL lab files, questions, and semester notes for the Relational Database Management System (RDBMS) course in the MSc Software Technology program.

---

📂 Repository Structure

• Lab Files/ → Contains SQL queries and PL/SQL scripts for various database operations.
• Lab Questions/ → Includes lab record problems and solutions for SQL & PL/SQL.
• Semester Notes/ → Notes covering theoretical concepts in RDBMS.

---

📌 Topics Covered

🔹 SQL Topics:

1. Basic SQL Queries → SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING
2. Joins & Subqueries → INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, EXISTS, IN
3. Constraints & Keys → Primary Key, Foreign Key, Unique, Check, Not Null
4. Normalization & Indexing → 1NF, 2NF, 3NF, BCNF, Clustered & Non-Clustered Indexes
5. Views & Materialized Views → Creating and managing views
6. Transactions & Locks → COMMIT, ROLLBACK, SAVEPOINT, Deadlocks
7. Stored Procedures & Functions → Creating reusable database functions

🔹 PL/SQL Topics:

1. PL/SQL Basics → Anonymous blocks, variables, control structures
2. Cursors & Exceptions → Implicit & explicit cursors, exception handling
3. Stored Procedures & Functions → Parameterized procedures & functions
4. Triggers → Row-level and statement-level triggers
5. Packages → Creating and using packages

---

💡 How to Use

1. Clone the repository:

   git clone https://github.com/your-repo-url.git

2. Navigate to the respective folders for SQL queries, PL/SQL scripts, or notes.
3. Use a SQL developer tool (Oracle SQL Developer, MySQL Workbench) to execute the scripts.

---

🔗 References

• Oracle SQL & PL/SQL Documentation: docs.oracle.com
• SQL Tutorial: w3schools.com/sql
• Database Concepts: geeksforgeeks.org/dbms

---