All The Cool Things You Can Do With PostgreSQL To Next Level Your Data Analysis

Abstract: The intention of this VERY hands on workshop is to get you introduced and playing with some of the great features you never knew about in PostgreSQL. You know, and probably already love, PostgreSQL as your relational database. We will show you how you can forget about using ElasticSearch, MongoDB, and Redis for a broad array of use cases. We will add in some nice statistical work with R embedded in PostgreSQL. Finally we will bring this all together using the gold standard in spatial databases, PostGIS. Unless you have a specialized use case, PostgreSQL is the answer. The session will be very hands on with plenty of interactive exercises.

By the end of the workshop participants will leave with hands on experience doing:
Spatial Analysis
JSON search
Full Text Search
Using R for stored procedures and functions
All in PostgreSQL

Bio: Steve is a Partner, and Director of Developer Relations for Crunchy Data (PostgreSQL people). He goes around and shows off all the great work the PostgreSQL community and Crunchy Committers do. He can teach you about Data Analysis with PostgreSQL, Java, Python, MongoDB, and some JavaScript. He has deep subject area expertise in GIS/Spatial, Statistics, and Ecology. He has spoken at over 75 conferences and done over 50 workshops including Monktoberfest, MongoNY, JavaOne, FOSS4G, CTIA, AjaxWorld, GeoWeb, Where2.0, and OSCON. Before Crunchy Data, Steve was a developer evangelist for DigitalGlobe, Red Hat, LinkedIn, deCarta, and ESRI. Steve has a Ph.D. in Ecology.