Learn PostgreSQL - Use manage and build secure and scalable databases with PostgreSQL 16

Luca Ferrari, Enrico Pirozzi

Sinossi

The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to run server-side programs, to configuring, managing, securing, and optimizing database performance.This new edition will not only help you get to grips with all the recent changes within the PostgreSQL ecosystem but will also dig deeper into concepts like partitioning and replication with a fresh set of examples. The book is also equipped with Docker images for each chapter which makes the learning experience faster and easier. Starting with the absolute basics of databases, the book sails through to advanced concepts like window functions, logging, auditing, extending the database, configuration, partitioning, and replication. It will also help you seamlessly migrate your existing database system to PostgreSQL and contains a dedicated chapter on disaster recovery. Each chapter ends with practice questions to test your learning at regular intervals.By the end of this book, you will be able to install, configure, manage, and develop applications against a PostgreSQL database.

Disponibile da: 31/10/2023.

Lunghezza di stampa: 744 pagine.

Scienze e tecnologia

Altri libri che potrebbero interessarti

Make Your Home a Nature Reserve

Donna Mullen

Bees, butterflies, bats, badgers …
These beautiful and fascinating creatures need a little help from us, as their natural habitats are under pressure.
It's time to invite nature into your home – whether it's a window box, a suburban garden or a farm. Learn how to build a pond, make places for bats to roost and spaces for hedgehogs to ramble. Discover the amazing secret lives of Ireland's wildlife, from tiny bugs to large mammals.
Do try this at home!

Mostra libro

Making Bird-Friendly Birdhouses...

Melvin "Bird Man Mel" Toellner,...

As popular as birdhouses are, many are designed with aesthetics in mind, rather than the bird's preferences and needs. Not so for the projects in Making Bird-Friendly Birdhouses. Lifelong birder Mel "Bird Man Mel" Toellner and pro woodworker Matt Maguire walk readers step-by-step through 15+ projects for safe birdhouses that birds find conducive to their natural nesting habitats. They begin with a comprehensive introduction to why birdhouses are so important, and why the birdhouses should be created with specific birds in mind like bluebirds, wrens, chickadees, owls and even bats! With additional sections on distribution maps, detailed plans, mounting instructions, and tips on attracting birds to your yard, it has everything you need to create a successful backyard haven for your winged friends.

Mostra libro