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

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
Secure Shell Client for Windows
Homework Submission Guidelines
GSU Data Portal (IPORT)
Grade Distribution

Course Materials

SQL

MySQL Tutorial
MySQL Basics (Sample session with commands)
MySQL Advanced Querying
SQL Fiddle
Homework 1 (Due:September 14, 2018 - Sunday) (Solution)
ER Model and Relational Mapping
Homework 2 (Due: September 26, 2018 - Wednesday) (Solution)

Python

Python Tutorial
Python Shell on the Web
Python Download and Install - Windows
Homework 3 (Due: October 17, 2018 - Wednesday) (Solution)

Beautiful Soup

BeautifulSoup
Tutorial
Beautiful Soup Examples (nbaRoster.py etc)
HTML Tutorial
Homework 4 (Due: November 16, 2018 - Friday)

Final Submissions

Project (Due: December 9, 2018 - Sunday) (handin submission under "project")
Summaries (Due: December 9, 2018 - Sunday) (handin submission under "summaries")