This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, such as managing manufacturers and products, employees and departments, warehouses and boxes, and movies and movie theaters.
The project demonstrates how to create tables, insert data into them, and perform complex SQL queries to retrieve and manipulate the data. It covers a wide range of query types, including selecting data based on conditions, calculating averages and sums, sorting data, joining tables, and performing updates and deletions.
By working on this project, you will gain practical experience in SQL database management and learn how to design tables, write efficient queries, and perform common operations on a relational database. It serves as a great opportunity to enhance your SQL skills and deepen your understanding of database management systems.
To get started with this project, follow these steps:
- Clone the repository:
git clone https://github.com/MaxLopezSalgado/sql-playground - Set up a SQL database (e.g., MySQL, PostgreSQL) and import the provided SQL script.
- Configure the database connection in the project files (if necessary).
- Open the project in your preferred IDE or text editor.
- Explore the tasks and tables provided and start working on the queries and operations.
- Use the provided documentation and resources to guide you through the project.
- Once you have completed the tasks, submit your solutions and any additional code or documentation.