Skip to content

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, that allow to apply basic, intermediate and advance SQL queries to different datasets.

Notifications You must be signed in to change notification settings

MaxLopezSalgado/sql-playground

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 

Repository files navigation

Project Description

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.

Getting Started

To get started with this project, follow these steps:

  1. Clone the repository: git clone https://github.com/MaxLopezSalgado/sql-playground
  2. Set up a SQL database (e.g., MySQL, PostgreSQL) and import the provided SQL script.
  3. Configure the database connection in the project files (if necessary).
  4. Open the project in your preferred IDE or text editor.
  5. Explore the tasks and tables provided and start working on the queries and operations.
  6. Use the provided documentation and resources to guide you through the project.
  7. Once you have completed the tasks, submit your solutions and any additional code or documentation.

Resources

About

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, that allow to apply basic, intermediate and advance SQL queries to different datasets.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published