📂 SQL Databases Collection
This repository contains multiple SQL databases and functional queries created for practice, learning, and query exploration. Each database is designed with unique table structures and queries to cover different real-world scenarios.
📑 Databases Included
🎬 Movie Database
Stores movies, actors, directors, and reviews. Includes queries for top-rated movies, actor collaborations, and genre analysis.
🎓 Student Database
Contains students, courses, results, and attendance. Includes queries for toppers, subject analysis, and overall performance.
👩💼 Employee Database
Stores details about employees, departments, and salaries. Includes queries for joins, aggregations, and filtering.
📚 Library Database
Manages books, members, and issued/returned records. Includes queries for book availability, late returns, and top readers.
🚀 Features
* Beginner-friendly SQL schema creation scripts. * Unique and different table names to avoid conflicts. * Useful queries for practice (joins, subqueries, aggregations). * Helps in understanding database design & management.
Queries Included
* Aggregate functions queries * Joins quesries
📂 Repository Structure
sql-databases/
│--moviedb
|--empdb
|--librarydb
|--studentdb
|--aggregate-func
|--joins
│-- README.md
🛠️ Technologies Used
*SQL (MySQL / PostgreSQL compatible) *Relational Database Concepts *Normalization & constraints (Primary Key, Foreign Key, etc.)