Mayur's SQL Portfolio

• My journey in mastering SQL, featuring topic-wise practice examples and real-world projects.
• Built using Microsoft SQL Server
• Demonstrates SQL queries, data manipulation and analysis techniques.

📊 SQL Solved Questions

Database: Northwind

• The practice examples are organized by topic and provide hands-on solutions to improve SQL proficiency.

1. Basic SQL Syntax and Filtering

• Questions: View Here
• Solutions: View Here
• Topics Covered:
  ✅ SQL Syntax and Queries
  ✅ Filtering and Sorting
  ✅ Subqueries
  ✅ Joins

2. Aggregations

• Questions: View Here
• Solutions: View Here
• Topics Covered:
  ✅ Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
  ✅ GROUP BY and HAVING Clauses
  ✅ Combining Aggregates with Filters
  ✅ Practical Aggregation Queries

3. Basic JOIN

• Questions: View Here
• Solutions: View Here
• Topics Covered:
  ✅ INNER JOIN
  ✅ LEFT OUTER JOIN
  ✅ RIGHT OUTER JOIN
  ✅ FULL OUTER JOIN

4. Subqueries

• Questions: View Here
• Solutions: View Here
• Topics Covered:
  ✅ Single-Row Subqueries
  ✅ Multi-Row Subqueries
  ✅ Correlated Subqueries

---

🚀 How to Use

• Clone the repository:

  https://github.com/mayur-de/My_SQL_Portfolio.git

• Explore:
  • Practice Examples:
    • Goal of this repository is to create a practice guide for the future queriers.
    • SQL queries organized by topics as I practiced.
    • Get the dataset from the link provided.
    • Load the data in Microsoft SQL Server.
    • Use the queries to fetch the data.
  • Projects: Real-world SQL projects stored in separate folders, demonstrating practical applications.

🚀 Get Started:

• Access /Dataset folder in the respository.
• Use instnwnd (Azure SQL Database), a .sql file.
• Create a database.
• Run the script in Microsoft SQL Server.

💡 How to Contribute

• Fork the repo and submit a pull request for improvements, optimizations, or new examples.

🎉 Acknowledgments

• SQL Server for database management.
• Datasets and resources from the open-source community.