Honors 1000, Productive Data Manipulation in Python and SQL (Fall 2022)

Course Details

Instructor: Raj Sunderraman; Room 629, 1 Park Place; raj@gsu.edu
Office hours: Monday 11.00 am to Noon or by appointment (please send email)

Syllabus
Piazza Discussion Board (Self sign up)
Class Jupyter Notebooks

Course Materials

Course Project (teams of 2-3)

Project (Due: December 11, 2022)

Python Access to MySQL and Web Application Development

Python-MySQL Connector (pip3/pip install mysql-connector-python)
Load MySQL Tables from csv files
Web App Architecture
Python Flask API Example (pip3/pip install flask)

MySQL

Windows Install, MacOS Install
Jupyter Lab Kernel for MySQL
MySQL Notes Part 1
MySQL Notes Part 2
Homework 3 (SQL Queries) (Due: 6 November, 2022)

Python

Official Python Documentation
Python Tutorial
Python Install
Jupyter Lab
Homework 2 (Histogram) (Due: 16 October, 2022)
Homework 1 (Crypto) (Due: 25 September, 2022)