SQL-Databases-Projects

Welcome to the SQL database projects! In this repository you will find a collection of practical SQL projects that will help you improve your skills in working with relational databases. Whether you're a beginner just starting out with SQL or an experienced developer looking to deepen your knowledge, there are plenty of exciting projects here that will help you take your knowledge to the next level.

📋 Contents of the repository

• Project: Internship Database
  A complete database for managing internships, including tables for companies, supervisors, teachers, students, internships, reports, and related data.

• Project: Book Database
  A database for managing books, publishers, authors, categories, and library loans, including records for late fees, customers, and borrowing transactions.

• Project: Class Schedule Database
  A database to manage teachers, classes, subjects, students, and their schedules, allowing for the assignment of teachers to specific classes and subjects at certain times.

• Project: Employee Database
  A database for managing employees and departments, including their details, and the relationship between departments and company locations.

• Project: Training Company Database
  A database for a training company that manages trainers, rooms, and courses, including details about the instructors, rooms, and course schedules.

• Project: Running Event Database
  A database for managing participants and events in running competitions, including the details of runners, events, and participation records.

• Project: Equipment Rental Database
  A database for managing customers, machines, machine types, rental transactions, and locations, including details about the machines, rental periods, and maintenance.

🛠️ Technologies

• SQL (Structured Query Language) - The basis for all database interactions.
• MySQL - These projects are compatible with common relational database systems.

🚀 Functions

• Create tables - Design data structures for storing data.
• Database queries** - Learn how to write SELECT, INSERT, UPDATE and DELETE queries.
• Joins and subqueries** - Work with INNER JOINs, LEFT JOINs and subqueries for complex queries.
• Indexes and optimizations** - Improve the performance of your queries through indexing and optimizations.
• Transactions and ACID** - Understand how to use transactions safely and efficiently in SQL databases.

🔧 Installation

1. clone the repository:

git clone https://github.com/Kraptukrait/SQL-Databases-Projects

2. install a SQL database:

• MySQL: MySQL download and installation guide

3. upload the SQL files:

Import the .sql files into your database environment.

mysql -u root -p < my_sql_project.sql

4. start queries:

Now you can execute the various SQL queries and work with the data.

👨‍💻 Developer

This repository was created by Kraptukrait, a passionate programmer who enjoys working on various SQL database projects. Follow me on GitHub to discover more interesting projects!

📢 License

This project is licensed under the MIT license. See the LICENSE file for more details.

---

Have fun coding! 🚀