Welcome to my SQL Practice + Projects Repository! This repository contains a variety of SQL files that cover essential SQL concepts, designed to aid in mastering database management and querying techniques. Each file contains example code, explanations, and exercises to reinforce SQL knowledge.

1. 1-ecommerce

   • 1.1-ecommerce_schema.sql
   • 1.2-insert_data.sql
   • 1.3-simple-queries.sql

2. 2-database-structures-management-with-mysql

   • 2.1- filtering-data.sql
   • 2.2- alias-concat.sql
   • 2.3- joining-clause.sql
   • 2.4- grouping-data.sql
   • 2.5- updating-Inserting-data.sql
   • 2.6- constraints.sql
   • 2.7- changing-table-structure.sql
   • 2.8- copy-table.sql
   • 2.10-virtual-tables.sql
   • 2.11-numeric-functions.sql
   • 2.12-string-functions.sql
   • 2.13-date-functions.sql
   • 2.14-comparison-functions.sql
   • 2.15-control-flow-functions.sql
   • 2.16-stored-procedures-in-mysql.sql

3. **ADVANCED MYSQL Topics **

   • 3.1-functions-and-stored-procedures-in-mysql.sql
   • 3.2-mysql-triggers.sql
   • 3.3-optimizing-database-queries.sql
   • 3.4-further-optimization-techniques.sql
   • 3.5-evaluating-MySQL-for-data-analysis.sql

4. 4-python-testing-tools

   • 4.0 Unit test and pytest

5. Practice Projects

   • 4.1 E-Commerce Database
   • 4.2 Library Management System
   • 4.3 Customer Order Tracking

6. SQL Query Exercises

   • 5.1 Basic Query Exercises
   • 5.2 Intermediate Query Challenges
   • 5.3 Advanced Query Scenarios

7. Resources

   • Links to Additional SQL Learning Resources

1. Clone this repository:

   git clone https://github.com/prantomollick/mysql-dbms-projects