Honors 1000, Productive Data Manipulation in Python and SQL (Fall 2020)
Course Details
Instructor: Raj Sunderraman; Room 629, 1 Park Place; raj@gsu.eduOffice hours: Monday 11.00 am to Noon (on WebEx) or by appointment (please send email)
Syllabus
Piazza Discussion Board
Class Jupyter Notebooks
Class Recordings
Filezilla
Handin Instructions
Use the following command on tinman to submit your event summaries
sudo handin1000 summaries file-name(s)
Course Materials
Final Project (Due: 13 December 2020)
(Sample Backend Code, Sample Frontend Code)
MySQL
MySQL Windows DownloadMySQL Windows Installation Step by Step
MySQL Install on MacOS
Jupyter Kernel for MySQL
MySQL Code Terminal Session
MySQL Code Part 1
MySQL Code Part 2
Homework 3 (SQL Queries) (Due: 30 October, 2020)
Python-MySQL Connector (pip3/pip install mysql-connector-python)
Load MySQL Tables from csv files
Python Flask API (pip3/pip install flask)
Web App Architecture
Homework 4 (Python-SQL) (Due: 22 November, 2020 - Sunday)
Python
Official Python DocumentationPython Tutorial
Python Shell on the Web
Mac Install
Windows Install
Jupyter Lab
hangman.py
Practice Problems 1
Homework 1 (Crypto) (Due: 28 September, 2020)
Homework 2 (SongLyrics) (Due: Due: October 12, Monday) (Tips from Wednesday Extra Office Hours)