📊 SQL Internship - Day 5 Tasks

Author: Sai Pradeep Kala
GitHub: @pradeep240604
Email: saipradeep2464@gmail.com

---

📌 Overview

This repository contains the Day 5 tasks of the SQL Internship program. The focus of the day was on mastering JOIN operations, SET operations, and implementing advanced queries to fetch and manipulate data from multiple tables effectively.

---

📁 Topics Covered

• ✅ INNER JOIN
• ✅ LEFT JOIN
• ✅ RIGHT JOIN
• ✅ FULL OUTER JOIN (If supported)
• ✅ CROSS JOIN
• ✅ SELF JOIN
• ✅ UNION, UNION ALL
• ✅ INTERSECT, EXCEPT (if applicable in your DBMS)
• ✅ Subqueries within JOINs
• ✅ Combining Data from Multiple Tables

---

🛠️ Tools Used

• Database: MySQL
• Platform: MySQL Workbench or any compatible RDBMS
• Language: SQL

---

📂 Files Included

• day5_queries.sql – SQL script file with all JOIN and SET operation queries.
• Sample datasets used for join operations.

---

🧠 Learning Outcome

By the end of this task, you will be able to:

• Efficiently join two or more tables.
• Use set operations to combine or filter datasets.
• Understand the difference between various join types.
• Solve complex data retrieval problems using SQL joins.

---

🚀 How to Use

1. Open MySQL Workbench.
2. Load the sample data if not already imported.
3. Execute queries from the day5_queries.sql file step-by-step.
4. Observe the outputs and tweak conditions to experiment.

---

📞 Contact

For any doubts or clarifications, feel free to reach out:

📧 saipradeep2464@gmail.com
🔗 GitHub - pradeep240604

---