This session will introduce you to PostgreSQL, a free, open source relational database system similar to MySQL and Microsoft SQL Server. We’ll cover the PostgreSQL ecosystem, from the database itself to management tools such as pgAdmin and psql. We’ll also dig into some of PostgreSQL’s unique and super-handy features, including the PostGIS spatial database extension, full-text search, and statistical functions.
This session is good for: People who have some database experience, but beginners are welcome too!
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.