Advanced SQL using PostgreSQL
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.
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.”
No tipsheets have yet been uploaded for this event.