Hosted at Portland State University, this week-long day camp (free and open to any Oregon student entering the 9–12 grade) offers an immersive introduction to transportation careers and the workings of transportation systems in Portland. Learn more about this year's camp and apply here!
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!
KEY LEARNING TAKEAWAYS
- Understand relational database schema: relations, keys and types
- Write single and multiple table SQL queries (e.g. SELECT, JOIN, WHERE)
- Write SQL aggregate queries (e.g. COUNT, SUM)
- Understand the range of queries possible to write with SQL
Kristin Tufte, Ph.D., Research Assistant Professor, Maseeh College of Engineering & Computer Science, Portland State University
Dr. Kristin...Read more
World Society for Transport and Land Use Research
The World Society for Transport and Land Use Research (WSTLUR) promotes the understanding and analysis of the interdisciplinary interactions of transport and land use, offers a forum for debate, and provides a mechanism for the dissemination of information. The Society organizes the World Symposium on Transport and Land Use Research. The first symposium was held in Whistler, Canada 2011, the second was held at Delft, The Netherlands in 2014, and the third took place in Brisbane, Australia in 2017. The next (virtual!) symposium is planned for 2021 in Portland, Oregon, in the United States.
Kelly Clifton serves as the interim Associate Vice President for Research and as a professor in the Department of Civil and Environmental Engineering at Portland State University. She holds an...Read more
Hosted at Portland State University, this week-long day camp (free and open to any female-identified Oregon student entering the 9–12 grade) offers an immersive introduction to transportation careers and the workings of transportation systems in Portland. Learn more about this year's camp and apply here!