This project is an example of an order management system that uses a SQL database.
- queries: This folder contains sample SQL queries for manipulating data in the database.
- scripts: This folder contains SQL scripts for creating tables in the database. These scripts contain definitions of tables such as Customers, OrderItems, Orders and Products.
- views: This folder contains SQL queries for creating views to help you view the data in the database.
- Install a SQL database (e.g. MySQL).
- Run the SQL scripts in the "scripts" folder in the correct order to create the tables in the database.
- Use the SQL query files located in the "queries" folder to manipulate the data in the database.
- If you want to use views, execute SQL queries from the "views" folder to create the appropriate views.
- SQL database (e.g. MySQL)
- SQL client or database management tool (e.g. MySQL Workbench)
- w3schools - SQL
- MySQL tworzenie i zarządzanie bazami danych
- Kurs SQL od podstaw | MySQL
- Pasja informatyki - SQL
- Kanał o Wszystkim - SQL
- MySQL Workbench Tutorial
- MySQL Crash Course | Learn SQL
- MySQL Tutorial for Beginners
- MongoDB Crash Course
- How to Use VS Code to Run SQL on a Database
- MySQL Database Queries From VS Code
- you NEED to use VS Code RIGHT NOW!!
Author: Adam Cegiełka