GitHub Repository: CS50 SQL Project
CS50’s Introduction to Databases with SQL is a course offered by Harvard University that teaches the fundamentals of relational databases, including the use of SQL for managing and manipulating data. The course covers topics such as database design, relational algebra, normalization, and SQL queries.
This repository contains complete solutions for all the projects in the course. Each project is focused on solving real-world problems using SQL and database management techniques. The repository includes:
- Fully implemented SQL solutions to the problems provided in the course.
- Original problem statements in PDF format for reference.
This repository serves as both a learning resource for others and a portfolio showcasing my expertise in database management and SQL.
The repository is structured as follows:
| Project | Topics Covered | Description |
|---|---|---|
| Problem Set 1 | Basic SQL Queries | Writing basic SQL queries to retrieve and manipulate data. |
| Problem Set 2 | Joins, Subqueries, Aggregation | Using joins, subqueries, and aggregation functions in SQL. |
| Problem Set 3 | Data Normalization, Constraints | Implementing database normalization and constraints to improve data integrity. |
| Problem Set 4 | Advanced SQL Techniques, Views | Applying advanced SQL techniques such as creating views, triggers, and using indexes. |
| Problem Set 5 | Database Optimization, Performance | Optimizing database queries and improving performance using indexing and query optimization techniques. |
Each folder contains:
- SQL Scripts – My implementation of the project.
This repository is beneficial for:
- Students – Use it as a reference while taking CS50's Introduction to Databases with SQL.
- Database Enthusiasts – Learn practical SQL solutions for common database-related tasks and challenges.
- Developers – Strengthen your database management skills and gain hands-on experience with SQL.
- Interview Preparation – Prepare for database-related questions and tasks commonly asked in technical interviews.