Join us for a multi-day online workshop on databases and SQL. Each day will be a combination of a lecture and practical. We will cover:

• Introduction to relational databases,
• Structured query language (SQL),
• How to setup a PostgreSQL database on your local machine and use it to analyze PORTAL* data.

* The workshop will also introduce attendees to the underlying infrastructure of PORTAL, PSU's centralized data repository that is freely available to the public. Learn more about PORTAL.

Workshop Schedule

Instructional days are: 

• Monday, December 1, 9:00 AM to 12:30 PM
• Wednesday, December 3, 9:00 AM to 12:30 PM
• Friday, December 5, 9:00 AM to 12:30 PM

With one additional day for those interested in extra help, practice problems, and follow-up:

• Monday, December 8, 9:00 AM to 12:30 PM

Registration

Main Registration Link for non TransPort members

• General Registration: $285
• Non-profit and community-based organizations: $95
• PSU students: $10
• TransPort members: Free for the first 20 spots. Use this separate TransPort registration link.
  • TransPort members & CBO/workforce organizations: ODOT, TriMet, Metro, Clackamas County, Multnomah County, Washington County, City of Portland, FHWA, Port of Portland, City of Beaverton, City of Gresham, City of Hillsboro, City of Lake Oswego, City of Tigard, City of Tualatin, City of Wilsonville, The Street Trust, Verde, APANO, Division Midway Alliance, and Oregon Walks.

Instructor

Basem Elazzabi, Ph.D.  
Head of Programming and Development for PORTAL and BikePed Portal, TREC at PSU

Basem is the head of programming and development for the PORTAL and BikePed Portal projects at TREC. He is responsible for maintaining and developing the database and the infrastructure of both projects. He also does various data analysis and visualization tasks. Basem received a PhD in Computer Science from Portland State University with a focus in database and data analysis. He also received his BS in Computer Science also from Portland State University. He has almost 20 years of experience in system analysis and development. His main interests are database systems, data analysis, distributed systems, and big data. His main research topics focus on how to facilitate data analysis for typical and non-technical data analysts. One of the main research topics that he works on is how to build the next generation data-analysis ecosystem in which institutions (government and private) can easily store their massive data and have easy access to data analysis tools to support and improve data-driven decision making.

Professional Development

This workshop is eligible for up to 12 hours of professional development credit. We can provide an electronic attendance certificate upon request.