This repository contains my solutions to the problem sets of the online course, CS50's Introduction to Databases with SQL offered on edX.
Each problem set covers a range of concepts and topics in SQL, comprising a set of assignments that allowed me to show my understanding of different techniques and methodologies.
The course is an introduction to databases using Structured Query Language, SQL. Concepts learned include how to create, read, update, and delete data with relational databases, which store data in rows and columns. The course begins with SQLite and ends with introductions to PostgreSQL and MySQL. For more information about the course, please refer to the course website.
The problem sets in the course cover SQL topics, in the order below:
- Week 0: Querying
- Week 1: Relating
- Week 2: Designing
- Week 3: Writing
- Week 4: Viewing
- Week 5: Optimizing
- Week 6: Scaling
The last part of the course is the final project: