Problem Solving with SQL and Python

A brief introduction of the SQL and Python problems, labs, and sets worked during the course.

NOTE: the challenges' Names in red are links to each cs50 challenge page.

---

SQL

SQL: Tables; Types; Statements; Constraints; Indexes; Keywords, Functions; Transactions. Race Conditionals. SQL Injection Attacks.

w7 Practice Problems:

• Favorites, for practice using SELECT and UPDATE keywords.

• Hall of Prophecy, for practice refactoring a database, using CREATE

w7 Lab 7:

• Songs, SQL queries to answer questions about a Spotify's songs database.

w7 Problem Set 7:

• Movies, SQL queries to answer questions about IMDB's movies database.

• Fiftyville, SQL queries to solve a mystery.

---