Programming 2

This course expands on Programming 1, and deepens students' knowledge of Python with a focus on data access and management.



Previously introduced programming topics include data types, operators, variables, and control flows are reinforced, this time in the context of retrieving and manipulating data. Students learn to use Regular Expressions, a powerful tool for finding and extracting data from string and other data types. They are introduced to modern web protocols and learn how to retrieve data from web services using Python and JSON, and how to access and parse data in XML. Students learn the basics of working with databases and the relationships between databases. They learn how to write queries in SQL, the foremost programming language for generating, manipulating, and retrieving information from a relational database.



Students work on small projects throughout the course. The final project challenges students to retrieve and visualize original data in Python.



All materials are included.