SPEAKERS: Kristin Tufte and Tammy Lee, Portland State University. DATE: Wednesday, July 21, 2021.
The world is awash in data, and the data available to transportation analysts and planners is growing by the minute. With this rapid growth, traditional data analysis tools may no longer be effective. Relational databases such as Microsoft SQL Server, PostgreSQL and Oracle are one tool that can be used to manage and query large data sets. In this webinar, we give a brief introduction to relational databases and SQL — the language that is used to communicate with relational databases. Participants will learn the key structures of relational databases (relations, keys and types), and will learn how to write simple SQL queries. We will practice writing SQL queries during the training. Additional resources will be provided for participants who wish to continue practicing their new SQL skills after the training. Join us to learn a bit more about how to manage those large data sets!
More info: https://trec.pdx.edu/events/professional-development/transportation-data-webinar-brief-introduction-relational-databases
