Harvard CS50 SQL – Project Solutions

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

The course covered designing, optimizing, and querying relational databases using SQL.

🚀 Key Skills Demonstrated

• Complex Queries: Advanced data retrieval using JOIN, GROUP BY, HAVING, and Subqueries.
• Database Design: Creating tables, defining primary/foreign keys, and maintaining data integrity.
• Optimization: Using EXPLAIN Query PLAN and creating INDEXES to optimize slow queries.
• Automation & Security: Implementing TRIGGERS, VIEWS, and understanding SQL injection prevention.

📁 Repository Structure

• /01-filtering - Basic data manipulation and filtering.
• /02-joins - Advanced multi-table queries and relationship handling.
• /03-design - Schema creation and entity-relationship models.

🛠️ Tech Stack

• SQLite
• Git & GitHub