MySQL Practice Repository

Welcome to MySQL Practice Repository, a comprehensive collection of SQL exercises, commands, and case studies that helped me master MySQL.

Repository Structure

└── 📁MySQL-Practice
    └── 📁Case-Expressions
        └── case_expressions.txt
        └── README.md
    └── 📁Exercises
        └── codebasics-movies-db.sql
        └── Exercise_1.txt
        └── Exercise_2.txt
        └── Exercise_3.txt
        └── Exercise_4.txt
        └── Exercise_5.txt
        └── Exercise_6.txt
        └── movies-db-1.xlsx
        └── README.md
    └── 📁Joins
        └── basic_joins.txt
        └── leetcode-joins.txt
        └── README.md
    └── 📁MySQL Commands
        └── codebasics-movies-db.sql
        └── commands.txt
        └── movies-db-1.xlsx
        └── README.md
    └── 📁REGEXP
        └── README.md
        └── regexp_commands.txt

Case-Expressions

• Focuses on SQL case expressions for conditional queries.
• File: case_expressions.txt provides examples and use cases.
• Refer to the README.md for additional explanations.

Exercises

• A variety of SQL exercises based on the codebasics-movies-db dataset.
• Includes queries for movie databases, financial calculations, and more.
• Files:
  • Exercise_1.txt through Exercise_6.txt: Step-by-step problems with solutions.
  • codebasics-movies-db.sql: Sample dataset for the exercises.
  • movies-db-1.xlsx: Additional reference for the movie database schema.
• Refer to the README.md for detailed instructions on how to use the exercises.

Joins

• Examples and problems related to SQL JOIN operations.
• Files include basic_joins.txt and leetcode-joins.txt for advanced practices.
• Refer to the README.md for more details.

MySQL Commands

• Collection of frequently used MySQL commands and scripts.
• Files:
  • commands.txt: Common commands for database manipulation.
  • codebasics-movies-db.sql: Sample database schema.
  • movies-db-1.xlsx: Schema and data reference.
• Refer to the README.md for further guidance.

REGEXP

• Focuses on regular expressions in MySQL.
• File: regexp_commands.txt provides a variety of REGEXP queries.
• Refer to the README.md for an overview and examples.

How to Use

1. Clone the repository:

   git clone https://github.com/CodeWithCharan/MySQL-Practice.git

2. Navigate to the desired folder based on your topic of interest.
3. Use the .sql or .txt files to practice queries in your MySQL environment.
4. Refer to the README.md in each folder for detailed explanations.

Contribution

Feel free to contribute by submitting pull requests with new exercises or improvements.