Data Exploration Using Relational DBMS (University-Wide)
Relational database management systems (RDBMS) are the most popular environment for storing and retrieving data used in research. Participants will learn the basics of data manipulation in RDBMS. They will learn how to create a table within a database, load simple tabular data, explore the data and execute simple queries. We will discuss when and what kind of optimizations might be required to handle the data efficiently. Together we will install a minimal RDBMS using a ready docker-compose image, write a simple Python script to ingest a CSV file, and create a simple dashboard visualizing the data.
- Audience: University-wide
- Pre-Requisites: Basic knowledge of Linux/Unix command line interface and familiarity with Python is essential. Participants should be able to use an integrated development environment (IDE) or a command-line text editor, such as Vim/Nano/Emacs, without assistance.
- Cost: None
- Late Drop/Cancel Fee: None
Registration and details on the Harvard Training Portal: REGISTER
