SQL Daily Practice with Grow Data Skills

This repository documents my daily progress and solutions for SQL assignments as part of the Grow Data Skills course. The focus is on consistency and learning SQL concepts thoroughly rather than rushing to complete assignments. Solutions are written in MySQL and updated regularly.

📂 Repository Structure

The repository is organized based on the course modules and classes:

• Module 1 - SQL
  • Class 1: Foundational SQL concepts (e.g., Database Basics, DDL/DML commands).
    • assignments.sql: Contains solutions to the provided assignments.
  • Class 2: Intermediate SQL (e.g., SELECT queries, Conditional Operators).
    • assignments.sql: Updated with solutions daily.
  • Class 3: Advanced SQL (e.g., Group By, Subqueries, Joins).
    • assignments.sql: Work in progress.
  • Class 4: Expert-level SQL (e.g., Window Functions, Recursive CTEs).
    • assignments.sql: Solutions to assignments will be added progressively.

Additional resources like challenges.pdf (if any) are included within each class folder.

---

🛠 Course Content

Module 1 - SQL

The course content includes:

1. Class 1:
   • Database concepts, MySQL setup, and basic DDL/DML commands.
2. Class 2:
   • Advanced table operations, conditional queries, and user-defined functions.
3. Class 3:
   • Grouping, subqueries, and joins.
4. Class 4:
   • Window functions, frame clauses, and recursive CTEs.

---

📘 How I Work on This Repository

1. Daily Practice:
   • Refer to the assignments provided for each class.
   • Solve questions using MySQL and document the queries in assignments.sql.
   • Add meaningful comments explaining the problem and approach.
2. Consistency Over Speed:
   • Commit to solving at least one question daily to maintain consistency.
   • Push the updated solutions to GitHub regularly.

---

🚀 How to Explore

1. Clone the repository to your local system:

   git clone <repository-url>

2. Navigate to the desired class folder to view assignments and solutions.
3. Open the assignment file to explore the queries and explanations.

---

🤝 Contributions

If you'd like to contribute:

1. Solve a new assignment or suggest improvements to existing solutions.
2. Create a pull request with your changes, and I'll review and merge them.
3. Discuss your queries or solutions in the issues tab.

---

🎯 Goals

• Complete all assignments from the Grow Data Skills SQL course.
• Learn and reinforce SQL concepts through hands-on practice.
• Build a consistent daily habit of problem-solving and learning.

---

Feel free to follow this journey and contribute! 😊