In this session, we’ll cover some lesser-known but incredibly useful features of PostgreSQL, a free, open-source relational database system named 2017 DBMS of the Year by DB-Engines. You’ll learn how to analyze spatial data with PostGIS, automate tasks with triggers, use Python and R in SQL functions, and discover PostgreSQL’s powerful full-text search engine.
This session is good for: People who have familiarity with SQL, but beginners are welcome.
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.