Introduction to Python and SQL

Fall 2023



Diego Fregolent Mendes de Oliveira, PhD

Video lecture by Brian Kim, PhD



No prerequisites.


This course introduces students to the basics of Python and SQL for data analysis. Students will explore real publicly-available datasets, using the data analysis tools in Python to create summaries and generate visualizations. Students will learn the basics of database management and organization, as well as learn how to code in SQL and work with SQL databases. By the end of the class, students should understand how to read in data from CSV files or from the internet and be comfortable using either SQL or Python to aggregate, summarize, describe, and visualize these datasets.