| zip | Baixar grátis |
|---|---|
| rar | Baixar grátis |
| epub | Baixar grátis |
| Baixar grátis | |
| lit | Baixar grátis |
| odf | Baixar grátis |
The PostgreSQL Handbook is the complete guide to PostgreSQL for developers who write SQL for a living — from your first SELECT to running a database in production with confidence.
Most SQL material stops at the query. This book keeps going: through the capabilities that are the actual reason to choose PostgreSQL, and out the far side into indexes, query plans, security, backups, partitioning, and replication. Across five parts, twenty-three chapters and 501 pages, you build one system — Lumina Helpdesk, a support-ticketing database that grows chapter by chapter from an empty schema into something with real data, real constraints, real indexes, and real operational concerns.
No prior PostgreSQL expertise is assumed. Comfort with basic SQL is enough to start; everything past SELECT, WHERE, and JOIN is built on the page, in order, against that one running example.
You'll learn to:
The last three chapters speak C# directly, but this is not a C# book: the first twenty contain none at all, and a reader who never opens Visual Studio loses nothing before Chapter 21.
Every SQL listing is real, executable SQL, verified against a live PostgreSQL 18.4 database by an automated harness before it was allowed into print. The output printed under a listing was captured from an actual run, never hand-typed. The database is deterministic by design — a fixed random seed and a fixed timestamp anchor — so when you run a listing you get the book's printed output exactly, on your machine, not "output may vary."
One script rebuilds the database to the exact state any chapter expects, so you can start reading anywhere, experiment freely, and reset when an experiment goes sideways.
Five appendices round it out: a native installation guide, a psql survival guide, the SQL style guide every listing in the book obeys, worked solutions to all 69 exercises, and a reference for what changed between PostgreSQL 16 and 18. A page-numbered index closes the book.
If you can write a SELECT, you can run PostgreSQL in production. This book is the path between the two.
Autores populares
Icon Group International (402) Publishing lmgdaw (341) Nikolay Krechet (266) Unknown Author (197) Lyudmil Tsvetkov (179) Barrett Williams (166) Kennie B Journals (158) Riddler Books (122) ChatGPT ChatGPT (118) NAK Legal Publishing (116) Evgeniia Naumchenko (114) Sharifa McFarlane (97) Jillo Trukudo (96) Quick Witted Coconut (94) Roggie Clark (94) Mint and Cherry Notebooks (93) Marina Buchholz B.Eng (89) Iwona Makara (87) Mary Hirose (87) Kingston Publishing (85)