Advanced SQL for Developers (PostgreSQL)

By:

An indepth look at SQL (specifically in PostgreSQL) and how to improve your query design. This course looks into advanced joins, set theory, improving subselects, and data type and operators available within the PostgreSQL system. It also looks at the query planner and how to read the output of EXPLAIN. Participants with laptops will be able to log into a demonstration database to practice the topics covered.

Stream: Databases

Paper: Advanced SQL for Developers (PostgreSQL)

Evan Leybourn is the founder and Managing Director of Looking Glass Solutions in Canberra. Evan has been working with large corporate and government entities doing data analysis and software design for the last 10 years. He currently runs PostgreSQL training for Fujitsu Australia, and is developing an Open Source Data Warehouse.