Skip to content

✨This repository contains my complete coursework, problem sets, and final project for CS50's Introduction to Databases with SQL by Harvard University. It showcases my journey through relational database concepts, SQL query writing, optimization, and the design of a full-scale final project — CampusConnect.

License

Notifications You must be signed in to change notification settings

BleeGleeWee/SQL-CS50

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 

Repository files navigation

CS50 SQL Banner

Harvard CS50’s Introduction to Databases with SQL — CS50SQL 2023

🎓 Course Link


⚠️ Academic Honesty Disclaimer

This repository is shared strictly for educational purposes. It is intended to help others learn from structure, approach, and design — not to be copied or submitted as their own.

CS50 has a strict academic integrity policy. All final projects are subject to manual review, and if your submission is found to be plagiarized, copied, or unoriginal, your edX and GitHub usernames can be permanently banned from CS50.

Please use this repository to:

  • Understand how to approach the problem sets and final project
  • Learn best practices in SQL schema design and query building
  • Get inspired to build your own original and creative final project

Do not copy-paste any part of this repository directly
Always write your own code
Be proud of your own learning and creativity

Let’s keep the CS50 community honest, supportive, and brilliant!


🏅 Certificate of Completion

I have successfully completed CS50's Introduction to Databases with SQL by Harvard University, earning a certification like below in June 2025.

image

The course included:

  • ✅ 7 hands-on problem sets
  • ✅ 1 final project submission

📁 Repository Structure

SQL-CS50/
├── Assignments/         # All 7 problem sets and solutions
├── FINAL-PROJECT/       # CampusConnect — Final Project files
├── LICENSE              # MIT License
└── README.md            # You're here!

📚 Table of Contents

🕹️ Week 0

  • Cyberchase
  • 36 Views or Normals
  • Players

🔗 Week 1

  • "Packages, Please"
  • DESE
  • Moneyball

🧱 Week 2

  • ATL
  • Happy to Connect
  • Union Square Donuts

🚨 Week 3

  • Don’t Panic!
  • Meteorite Cleaning

🏠 Week 4

  • Census Taker
  • The Private Eye
  • Bed and Breakfast

📊 Week 5

  • Snap
  • Harvard

📈 Week 6

  • Happy to Connect (Sentimental)
  • Don’t Panic! (Sentimental) — Python Version

🎓 Final Project: CampusConnect

CampusConnect is a relational database designed to manage campus events and student participation. It allows:

  • Creating and managing user profiles
  • Organizing and attending events
  • Viewing interests and participation analytics

📌 See FINAL-PROJECT/ for schema design, sample queries, and project documentation.


🛠️ Tools & Technologies

  • SQL (SQLite)
  • DB Browser for SQLite
  • Harvard CS50 IDE
  • ER modeling & schema design

📫Any doubts? Connect with me: bleegleewee


“Without data, you're just another person with an opinion.” – W. Edwards Deming

About

✨This repository contains my complete coursework, problem sets, and final project for CS50's Introduction to Databases with SQL by Harvard University. It showcases my journey through relational database concepts, SQL query writing, optimization, and the design of a full-scale final project — CampusConnect.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published