Tutorial notes will be posted slightly after class. Code will be posted after the following week
Wrapping up the whole course. Updating data using embedded SQL queries
Wrapping up the whole course. Writing embedded SQL in Flask applications
Wrapping up Javascript. Practical uses of Javascript
An introduction to Javascript and client-side scripting
Wrapping up HTML and CSS. Exercises using the flexbox strategy
A continuation of HTML and CSS. Frontend design and styling
No tutorials this week because of reading week. Here’s a song about a mountain blowing up
An introduction to writing Flask apps. Using Flask to serve static data
Wrapping up SQL with views and GROUP BY clauses. A brief introduction to HTML and CSS
SQL queries. We go over SQL queries to extract data from databases
Relational algebra. We go over relational algebra and writing relational algebra to perform queries
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
No tutorials this week. Here’s a video of a dog riding a lawnmower