dbhitman/sql2025samples repository overview

USE AirlineFleetDB;
SELECT * FROM Flights WHERE Status = 'Scheduled';



## 🍽️ FoodFleetDB – Restaurant Delivery Schema
- Realistic restaurants, drivers, orders, and menu items
- Tables: Restaurants, Drivers, MenuItems, Orders, DeliveryStatus
- Perfect for logistics, delivery tracking, and dashboarding
USE FoodFleetDB;
SELECT Name, Cuisine FROM Restaurants WHERE Rating > 4.0;



## 🎟️ EventHiveDB – Event Management Schema
- Events, venues, tickets, attendees, and sponsors
- Tables: Events, Venues, Attendees, Tickets, Sponsors
- Great for ticketing platforms and event analytics
USE EventHiveDB;
SELECT Title, EventDate FROM Events WHERE Category = 'Music';



## 🐾 PetCareDB – Veterinary Schema
- Pets, owners, vets, visits, and treatments
- Tables: Pets, Owners, Vets, Visits, Treatments
- Ideal for clinic management and health tracking
USE PetCareDB;
SELECT Name, Species FROM Pets WHERE Gender = 'Female';



## 🏡 TravelNestDB – Property Booking Schema
- Hosts, properties, guests, bookings, and reviews
- Tables: Hosts, Properties, Guests, Bookings, Reviews
- Perfect for travel-tech demos and booking engines
USE TravelNestDB;
SELECT Title, PricePerNight FROM Properties WHERE Location = 'Goa';



## 🏋️ FitTrackDB – Fitness Tracking Schema
- Users, workouts, goals, nutrition plans, and progress logs
- Tables: Users, Workouts, FitnessGoals, NutritionPlans, ProgressLogs
- Great for health-tech apps and fitness dashboards
USE FitTrackDB;
SELECT Type, DurationMinutes FROM Workouts WHERE CaloriesBurned > 300;



## 🌾 AgroTrackDB – Agriculture Schema
- Farmers, crops, fields, yields, and weather logs
- Tables: Farmers, Crops, Fields, Yields, WeatherLogs
- Ideal for agri-tech analytics and field monitoring
USE AgroTrackDB;
SELECT Name, Season FROM Crops WHERE Type = 'Cereal';




🐳 How to Use
1. Pull the image from Docker Hub
docker pull dbhitman/sql2025samples:latest


2. Run the container in detached mode
docker run -d -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Welcome123!" -p 1433:1433 dbhitman/sql2025samples:latest


Welcome123! is the default SQL Server sa password. You can change it if needed.

3. Connect via SSMS
- Server name: localhost,1433
- Authentication: SQL Server Authentication
- Login: sa
- Password: Welcome123!

🙌 Credits
Created by dbhitman (Anil), Principal Cloud Architect & community educator.
This image is part of a broader initiative to ritualize technical onboarding through container-native labs and stylized schemas.