Harvard CS50 SQL Problem Sets

This repository contains my solutions to the problem sets from CS50's Introduction to Databases with SQL course offered by Harvard University.

About the Course

CS50 SQL is Harvard's introduction to databases using SQL. The course covers querying, relating, designing, writing, and optimizing databases using SQLite, MySQL, and PostgreSQL.

Repository Structure

Problem Sets

Folder	Description
cyberchase	Querying a database of Cyberchase episodes
players	Querying a database of MLB players
views	Creating views in a database
dese	Querying Massachusetts Department of Elementary and Secondary Education data
moneyball	Analyzing baseball statistics (Moneyball style)
snap	Querying a social media database
bnb	Querying Airbnb listings data
census	Analyzing census data
donuts	Designing a database schema for a donut shop
ATL	Designing a database schema for Atlanta airport (Hartsfield-Jackson)
happytoconnect	Designing a database schema for a LinkedIn-style platform
sentimental-connect	Python-based database schema design
meteorites	Importing and cleaning meteorite landing data
packages	SQL-based mystery/investigation problem
private	Working with encryption in SQL
harvard	Creating indexes for query optimization
deep	Analyzing database partitioning strategies
dont-panic	SQL injection and database security
dont-panic-python	Python implementation of database security

Final Project

Folder	Description
final-project	Hospital Management System (HMS) - A comprehensive database design project featuring patient management, appointment scheduling, medical records, and audit logging

Technologies Used

• SQLite - For most problem sets
• SQL - Querying, schema design, views, indexes
• Python - For Python-integrated database problems

How to Use

1. Clone this repository
2. Navigate to the problem set folder you want to explore
3. Use SQLite or the appropriate database system to run the SQL files

# Example: Running a query from the cyberchase problem set
sqlite3 cyberchase/cyberchase.db < cyberchase/1.sql

Author

Ferit Bulut

License

This project is for educational purposes. Please refer to CS50's Academic Honesty policy before referencing these solutions.

Acknowledgments

• Harvard University
• CS50 Team