MTH 448/548
Logistics
MTH 448/548 Syllabus
Current Tasks
Project Report Guide
Useful links
Schedule
Preliminaries
Week 1 (1/31-2/6)
Week 2 (2/7-2/13)
Week 3 (2/14-2/20)
Week 4 (2/21-2/27)
Week 5 (2/28-3/6)
Week 6 (3/7-3/13)
Week 7 (3/14-3/20)
Week 8 (3/28-4/3)
Week 9 (4/4-4/10)
Week 10 (4/11-4/17)
Week 11 (4/18-4/24)
Week 12 (4/25-5/1)
Week 13 (5/2-5/8)
Week 14 (5/9-5/15)
Tools
Numpy
Pandas
Seaborn
Plotly
Requests
Beautiful Soup
JSON
Regular expressions
SQL
SQL basics
SQL queries
SQL joins, union, intersection
Views
SQL with Python
Projects
Project: Recognizing digits with k-NN
Project: MNIST with k-means
Project: Baby names
Project: Scrapping marathon results
Project: Discord logs
Project: Analysis of marathon results
Project: Text classification with naive Bayes
Optional Project: Music database
MTH 448/548
MTH 448/548
»
SQL
SQL
¶
SQL basics
SQL in Jupyter Notebook
Creating tables
Deleting tables
Creating table records
Modifying records
Deleting records
SQL queries
SELECT … FROM …
WHERE
ORDER
LIMIT
Aggregate functions
GROUP BY
HAVING
SQL joins, union, intersection
INTERSECT
UNION
EXCEPT
Joins
Views
SQL with Python