Skip to content

README.md

Latest commit

 

History

History
73 lines (47 loc) · 1.76 KB

README.md

File metadata and controls

73 lines (47 loc) · 1.76 KB

🔗 Oracle SQL Joins

This repository contains practical SQL queries demonstrating various types of table joins using Oracle Database. It's designed as a hands-on lab to help students and professionals understand how to retrieve and relate data across multiple tables.

📘 Topics Covered

The lab covers 12 types of joins with full solutions and comments:

  1. ✅ Natural Join
  2. ✅ Join with the USING Clause
  3. ✅ Join with the ON Clause
  4. ✅ Self-Join
  5. ✅ Non-Equijoins
  6. ✅ LEFT OUTER Join
  7. ✅ RIGHT OUTER Join
  8. ✅ FULL OUTER Join
  9. ✅ CROSS Join (Cartesian Product)
  10. ✅ Three-Way Join using ON
  11. ✅ Join with Additional Conditions
  12. ✅ Table Aliases with Joins

🧾 File Details

  • joins_lab.sql – Contains all queries with:
    • Question numbers and headings as comments
    • Clear formatting and table aliases
    • Educational purpose queries with expected logic

🛠️ Tools Used

  • 💾 Oracle SQL Developer
  • 🧩 Oracle Server (Live/Local)
  • 💻 Structured Query Language (SQL)

🎓 Learning Outcomes

By completing this lab, you will be able to:

  • Write SQL queries that combine data from multiple tables
  • Understand INNER, OUTER, and CROSS joins
  • Use USING, ON, and aliases to simplify code
  • Perform advanced queries like self-joins and non-equijoins

📸 Screenshots (Optional)

image

image

📎 How to Use

  1. Clone this repository
git clone https://github.com/YourUsername/oracle-sql-joins-lab.git

!

📬 Connect with Me
👤 Linkedin : Awais Manzoor
📧 awaismanzor125@gmail.com