High Performance PostgreSQL for Rails

Build faster, more reliable Rails applications using advanced PostgreSQL and Active Record capabilities to meet the challenges of scaling and growing your application. Master the skills needed to work with multi-terabyte databases, complex Active Record, SQL, and specialized indexes. Develop your PostgreSQL skills on a laptop, then apply them to production, keeping everything in sync. Speed ​​up slow queries, perform any schema change or data migration without errors, and use scaling techniques such as read/write splitting, partitioning, and sharding to handle high loads from web-scale applications to enterprise SaaS.

Deepen your knowledge of highly scalable PostgreSQL databases and Ruby on Rails applications by completing dozens of hands-on labs. Unravel the mysteries of complex Active Record. Perform any schema change or data migration confidently, without downtime. Enhance your expertise with modern and exclusive PostgreSQL features such as SQL Merge, Returning, and Exclusion constraints. Leverage advanced capabilities such as full-text search and Publish/Subscribe built into PostgreSQL in your Rails applications. Improve the quality of your database data using an advanced and extensible type and constraint system to reduce and eliminate application errors. Tackle complex challenges such as improving query performance using specialized indexes. Learn how to leverage built-in database functions and write your own, administer replication, and make the most of partitioning and external data.

Use over 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable database administration knowledge by performing advanced optimizations, including high-performance database maintenance, while solving real-world operational problems.

Apply your new skills in a production environment and take your PostgreSQL and Rails applications to new levels of reliability and performance.