CS50’s Introduction to Databases with SQL — Coursework by Aditya Vatnani

---

Overview

This repository contains all the work I completed as part of Harvard’s CS50’s Introduction to Databases with SQL course.
It includes all problem sets, practice exercises, and my final project submission — Movies Analysis Database.

The goal of this repository is to showcase my learning progress in SQL concepts such as:

• Database design & normalization
• SQL querying (SELECT, JOIN, GROUP BY, HAVING, etc.)
• Data integrity & constraints
• Indexing & optimization
• Triggers & transactions
• Scaling

Course Details

• Course: CS50’s Introduction to Databases with SQL
• Institution: Harvard University (via edX)
• Instructor: Carter Zenke
• Language Used: SQL (SQLite, PostgreSQL and MySQL)

How to Run

1. Open the .db file in SQLite or the CS50 IDE: sqlite3 movies.db
2. View the schema: .schema
3. Read the file: .read queries.sql
4. Quit: quit