Artículo: AMZ-B0G25MHWX9

The PostgreSQL Developer's Handbook: From Simple Queries to Advanced Data Mastery — A Practical Guide to Building Efficient and Scalable Applications (The Go Pro Series)

Disponibilidad
En stock

Peso con empaque
0.73 kg

Devolución
Sí

Condición
Nuevo

Producto de
Amazon

Sobre este producto

Decode Query Plans:Stop guessing. Master EXPLAIN ANALYZE to find and eliminate performance bottlenecks. (Ch 8)
Master Advanced SQL:Wield the power of Window Functions, Common Table Expressions (CTEs), and Lateral Joins for sophisticated data analytics. (Ch 6, 11)
Harness the “NoSQL” Power of JSONB:Confidently store, index, and query unstructured JSON data — all inside PostgreSQL. (Ch 9)
Write Powerful PL/pgSQL:Move complex application logic inside your database with user-defined functions, stored procedures, and triggers. (Ch 10)
Build a High-Speed Search Engine:Implement lightning-fast, built-in Full-Text Search. (Ch 9)
Index Like a Pro:Go beyond B-Trees and learn when (and why) to use GIN, GiST, BRIN, and Partial Indexes for massive speed gains. (Ch 8)
Tackle Complex Hierarchies:Use Recursive Queries to elegantly manage data like org charts, threaded comments, and parts explosions. (Ch 11)
Ensure Data Integrity and Safety:Understand Transaction Isolation Levels, MVCC, and how to avoid deadlocks in concurrent applications. (Ch 7, 13)
Explore Geospatial Data:Get a practical primer on storing and querying geographic data with PostGIS. (Ch 9)
Manage Large Datasets:Learn the fundamentals of Table Partitioning for scaling massive tables. (Ch 11)
Backend Developers who need to build and scale data-driven applications.
Software Engineers who want to write efficient, performant database code.
Data Analysts moving beyond simple queries into advanced analytics.
Aspiring DBAs or developers tasked with database administration and maintenance.