A quick speed-refresher of Python. We go over variables, functions, string methods, lists, loops, and basic I/O. The material covered today will be especially relevant to those who have not taken one of A08, A48, or A20

Relational algebra. We go over relational algebra and writing relational algebra to perform queries.

SQL queries. We go over SQL queries to extract data from databases.

Wrapping up SQL with views and GROUP BY clauses. A brief introduction to HTML and CSS

An introduction to writing Flask apps. Using Flask to serve static data.For this week’s lab, you will need your own computer. It is not possible to install Flask on the lab computers and there currently isn’t a solution to run your code in the lab.

No tutorials this week because of reading week.

A continuation of HTML and CSS. Frontend design and styling