Foundations of Computer Science (2019-20)

Lecture plan

#	Who	Date	Topic	Material	Assignments	Solutions	WebEx
1	GDV	1/10	Introduction to the Jupyter Notebook, Array, lists, loops, dictionaries. Reading files, functions, and libraries.	Notebook 1 Notebook 2 Notebook python basics			WebEx (password: AdFJ8Dd5)
2	GDV	2/10	Separator-based files. Relational model DBMS. Schemas and instances. Exploring a DB. Constraints, Keys, Indices. Null values.	slides planets.csv	Exercise, PromessiSposi.txt	Solution Part 1	WebEx (password: AdFJ8Dd5)
3	MP	4/10	Basic shell usage, Version control	See “Linux shell commands” at the end of this page and version control for version control.			WebEx (password: apaMJQvu)
4	GDV	8/10	Pandas: introduction and indexing.	Notebook Notebook	Exercise	Solution	WebEx (password: puyJQpZ3)
5	GDV	9/10	Select..From..Where on 1 table. Aggregate operators	slides	Northwind 1	Solution	WebEx (password: FJ8Dd5)
6	MP	11/10	Queries on 1 table	NorthWind	Northwind 2	Solution	WebEx (password: HMni4AJc)
7	GDV	15/10	Pandas: aggregating data	Notebook Docs	Exercise	Solution	WebEx (password: CQjhGW8j)
8	GDV	16/10	Querying more tables in SQL. Set operations	slides slides	Exercise 1 Exercise 2	Solution 1 Solution 2	WebEx (password: hRBj2AXw)
9	MP	18/10	Regular Expressions	Regex Docs — You can read more about Regular Expressions in Chapter 3 of “Introduction to Automata Theory, Languages, and Computation” by Hopcroft, Motwani, and Ullman.	Exercise, email.txt, numbers.txt, exp_nums.txt	Solution	WebEx (password: QZUMwMUm)
10	GDV	22/10	Pandas: missing data. Hierchical indexing. Concatenating and merging tables	Notebook missing data Notebook Multindex Notebook concat Notebook merge	Exercise 1 Exercise 2	Solution 1 Solution 2	WebEx (password: 3yitMAMX)
11	GDV	23/10	Parsing files. List manipulation: comprehension, zip	slides docs	Exercise	Solution	WebEx (password: hWbe7jH2)
12	MP	25/10	Regular Expressions (cont’d) - Shell (cont’d) - Python outside the notebook	Quick overview of packages design	Same as Lesson #9		WebEx (password: rY3Yym4n)
13	GDV	29/10	Exercise on list comprehensions	docs	Exercise	Solution	WebEx (password: jJ4dJs9x)
14	GDV	30/10	Nested queries. Accessing databases	slides	Exercise Exercise	Solution	WebEx (password: Z2Grg3pE)
15	MP	5/11	Assertions, Debugging	assertions	Exercise		WebEx (password: pZuXrwst)
16	MP	6/11	Case study		Exercise, fifa18 db	Solution	WebEx (password: 3EhxkVAm)