Advanced SQL using PostgreSQL

  • Event: 2015 CAR Conference
  • Speaker: Anthony DeBarros of The Wall Street Journal
  • Date/Time: Sunday, Mar. 8 at 9:00am
  • Location: M104
  • Audio file: No audio file available.

Using PostgreSQL and the pgAdmin interface, we will explore advanced SQL techniques to interview and clean data, go from basic math to advanced stats, and create ranks and rates.

This session is good for: People who are comfortable with SQL basics -- sorting, filtering, counting -- and familiar with joins.

Speaker Bios

  • Anthony DeBarros is Data News Editor in the Washington, D.C., bureau of The Wall Street Journal, covering trade, politics, the economy and demographics. Before joining the WSJ, Anthony spent more than 25 years with Gannett, including 15 as a data journalist at USA TODAY. He also led product development for DocumentCloud. Last year, No Starch Press published his first book, “Practical SQL: A Beginner’s Guide to Storytelling with Data.”

Related Tipsheets

No tipsheets have yet been uploaded for this event.