CS 105
Fall 2018

Labs

Lab 0: Preliminaries
complete on your own ASAP!
Lab 1: Getting started; designing a relational database
solutions
Lab 2: SQL basics
solutions
Lab 3: SQL revisited
solutions: task 1, task 2, task 3
Lab 4: Python fundamentals
solutions: task 1, task 2, task 3, extra
Lab 5: Loops; cumulative computations
solutions: task 1, task 2, task 3
Lab 6: Conditional execution; strings and lists
solutions: task 1, task 2, task 3
Lab 7: Accessing a database from Python; file writing
solutions: task 1, task 2, task 3
Lab 8: Reading and processing a text file
solutions: task 1, task 2, task 3
Lab 9: Data mining fundamentals; transforming a data file
solutions: task 1, task 2, task 3
Lab 10: Classification learning
solutions