Summer Transportation Camp at PSU: All Genders

Monday, July 19, 2021, 9:00am PDT to Friday, July 23, 2021, 5:00pm PDT

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!

Transportation Data Webinar: A Brief Introduction to Relational Databases & SQL

Wednesday, July 21, 2021, 2:00pm to 3:30pm PDT

OVERVIEW

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

SPEAKER

Kristin Tufte, Ph.D., Research Assistant Professor, Maseeh College of Engineering & Computer Science, Portland State University

Dr. Kristin...

Read more

Partner Event: 2021 World Symposium on Transport and Land Use Research

Sunday, August 8, 2021, 8:00am PDT to Thursday, August 12, 2021, 5:00pm PDT

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.

Learn more about the event and see the latest updates here

 

Conference Co-Chairs

Kelly Clifton, Portland State University

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

Summer Transportation Camp at PSU: Girls

Monday, August 9, 2021, 9:00am PDT to Friday, August 13, 2021, 5:00pm PDT

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!