Welcome to CS50 SQL, Harvard University’s introduction to databases using SQL. This course teaches you how to create, read, update, and delete data with relational databases, model real-world entities and relationships using tables, and much more. Whether you are a concentrator or non-concentrator, this course covers fundamental concepts in SQL and database management.
CS50 SQL covers essential topics over the course of its duration:
- Week 1: Introduction to SQL
- Week 2: Querying
- Week 3: Relating
- Week 4: Designing
- Week 5: Writing
- Week 6: Viewing
- Week 7: Optimizing
- Week 8: Scaling
The course culminates in a final project where you will apply what you've learned to solve real-world problems.
Even if you are not enrolled at Harvard, you can access this course for free through Harvard's OpenCourseWare. Follow these steps weekly:
- Watch Lecture
- Complete Assignments
- Engage in Project Work
- Participate in Discussions
Throughout my journey in this course, I will be regularly updating this repository with my solutions to assignments and projects as I progress through the course.
- CS50 SQL Website
- CS50 SQL on edX
- CS50 SQL OpenCourseWare
- CS50 SQL's Zoom Meetings
- CS50 SQL on Ed Discussion
This repository and its contents are licensed under the MIT License. Feel free to use and modify these materials according to the terms of the license.
For questions or feedback, contact Carter Zenke at carter@cs50.harvard.edu or David J. Malan at malan@harvard.edu.
Feel free to explore the course's materials and engage with the community. Happy learning!