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

Luca Ferrari, Enrico Pirozzi

Summary

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.

Available since: 10/31/2023.

Print length: 744 pages.

Science & Technology

Other books that might interest you

Synchronicity - Nothing Just...

Marcus Riauka

Why do certain numbers follow you? Why does the right person appear at the exact moment you think of them? Why does a delay that ruins your plans later reveal itself as protection? And why does the world sometimes behave as though it knows more about your life than you do?
Carl Jung named the phenomenon in 1952. He called it synchronicity. But he described it without explaining how it works — and for seventy years, no one has filled that gap. Until now.
SYNCHRONICITY: Nothing Just Happens is the first book to propose a concrete engineering mechanism for how meaningful coincidences are produced. Not a spiritual metaphor. Not a description of the experience. A mechanism.
At the heart of the book lies the Dormant Template Theory — a model in which consciousness is the fundamental substrate of reality and the physical world is its rendered output. Within this architecture, synchronicities are not random. They are authored signals — embedded in the pre-structured template of your experience before you encounter them, calibrated to your awareness, and designed to evolve in response to your attention.
The model passes the test of quantum physics. The measurement problem, Bell's theorem, nonlocality, the fine-tuning of universal constants — each finds a structural explanation within the proposed architecture, more parsimoniously than standard interpretations provide.
Built on years of direct research into expanded states of consciousness — including documented contact with non-human intelligence — this book bridges the gap between rigorous theoretical framework and honest first-person testimony. Eleven chapters, constructed as a single argument, from first principles to personal field report.
This is not spiritual mainstream. There are no affirmations. No angel numbers. This is an engineering inquiry into the architecture of reality — written for listeners who want structure, not sentiment.
As Einstein said — God does not play dice. This book explains why.

Show book

Soil Science Simplified -...

KATE LOWENFELS, JEFF MESSNER

Soil Science Simplified: Unearth the Richness of the Earth Beneath Us: A Comprehensive Guide to Understanding and Applying Soil Science for a Thriving Garden and a Sustainable Future 🌍🌱
Hey there, eco-enthusiast! Do you have a green thumb or simply a burning curiosity about the world beneath your feet? Ever wondered why some plants thrive while others seem to sigh in despair? The secret, my friend, isn’t just in the seed, but in the soil!
This isn’t just a book; it’s your ticket to tapping into the pulsating heart of Mother Earth. And guess what? You don’t need a PhD. This guide whisks you away on a down-to-earth journey, making soil science not just accessible but absolutely enthralling!
🌱 Soil 101: Dive beneath the surface and get to know soil in all its vibrant, varied glory. Understand its composition, structure, and the micro-universe that teems within.
🔬 The Science Unearthed: Demystify the complex processes that make soil the life-giving medium it is. Photosynthesis, respiration, and nutrient cycles? We’ve got them covered in digestible bites!
🍅 Garden Glory: Transform your garden from ‘meh’ to mesmerizing. Discover how understanding soil can lead to lusher lawns, vivacious veggies, and fabulous flowers.
🌍 Sustainability and Soil: Grasp the integral role of soil in our ecosystem. Dive into practices that not only nourish your garden but also safeguard our planet’s future.
Dust off that trowel, let curiosity take root, and dive hands-first into the wonderland below. A thriving garden and a sustainable future are right beneath your feet!
Grab your copy, roll up your sleeves, and let's get the dirt on soil! 🌸🍂🔍🎋

Show book

Nature’s Ghosts: The world we...

Sophie Yeo

Winner of the 2024 Richard Jefferies Award for nature writingShortlisted for the 2024 Wainwright Prize for Writing on ConservationA Times Science Book of the Year
‘Sophie writes fantastically, chronicling the most important issues facing nature conservationists today.’ Chris Packham
For thousands of years, humans have been the architects of the natural world. Our activities have permanently altered the environment – for good and for bad.
In Nature’s Ghosts, award-winning journalist Sophie Yeo examines how the planet would have looked before humans scrubbed away its diversity: from landscapes carved out by megafauna to the primeval forests that emerged following the last Ice Age, and from the eagle-haunted skies of the Dark Ages to the flower-decked farms of more recent centuries.
Uncovering the stories of the people who have helped to shape the landscape, she seeks out their footprints even where it seems there are none to be found. And she explores the timeworn knowledge that can help to fix our broken relationship with the earth.
Along the way, Sophie encounters the environmental detectives – archaeological, cultural and ecological – reconstructing, in stunning detail, the landscapes we have lost.
Today, the natural world is more vulnerable than ever; the footprints of humanity heavier than they have ever been. But, as this urgent book argues, from the ghosts of the past, we may learn how to build a more wild and ancient future.
Sophie Yeo's Nature’s Ghosts is a non-fiction masterpiece that takes us on a journey through the science of ecology, exploring the habitats and ecosystems that have been altered by human activity. The book emphasises the need for protection of these resources, offering a glimpse into the past to help us understand how we can shape a better future.
For fans of Robert Macfarlane (Is a River Alive?), Robin Wall Kimmerer (The Democracy of Species), Isabella Tree (Wilding), Jennifer Ackerman (What an Owl Knows), and Derek Gow (Birds, Beasts and Bedlam).
HarperCollins 2024

Show book

Day Trading for Beginners - How...

Brian Mahoney

Day Trading for Beginners: How to Start Day Trading Entrepreneur Audio Book
Are you looking to make money quickly and flexibly? Day trading might just be the answer you've been searching for.
* Chapter 1 introduces you to the world of day trading
* Chapter 2, you'll discover the tools and software you need to set up your trading station
* Chapter 3 teaches you the ins and outs of market analysis, including technical and fundamental analysis, so you can understand market trends and patterns.
* Chapter 4, you'll learn about different day trading strategies so you can understand which is the best trading strategy for you.
* Chapter 5 covers risk management in day trading, including how to manage your losses, set stop-loss orders, and create a trading plan that works for you.
* Chapter 6, you'll learn how to develop a personalized trading plan, including setting goals, defining your risk tolerance, and creating a routine that works for you.
* Chapter 7 shows you how to practice day trading without risking real money, using simulators and other practice tools to hone your skills.
* Chapter 8 emphasizes the importance of trading discipline and execution, including managing your emotions, sticking to your plan, and avoiding common pitfalls.
* Chapter 9 covers advanced day trading techniques, including Options Trading, Short Selling, and Day Trading Futures and Forex, to help you take your trading to the next level.
Finally, in Chapter 10, you'll learn about legal and tax considerations for day traders, including tax reporting requirements and common legal issues to watch out for.
If you are looking to branch out into day trading, "Day Trading for Beginners: How to Start Day Trading Entrepreneur Audio Book" has everything you need to get started on the path to financial independence. Order now and start your journey to becoming a successful day trader!

Show book

PMP Certification Secrets:...

Jareth Westfall

PMP Certification Secrets: Streamlined Success Strategies for Your Journey
⭐⭐ Simplified Guide & Explanations Included ⭐⭐
Are you eager to advance your career and solidify your knowledge while successfully obtaining your PMP certification for 2024-2025?
Looking for a thorough guide that encompasses all the essential components needed to achieve PMP certification in 2024-2025?
Your search ends here!
This guide is your ultimate companion for enhancing your understanding, applying your skills, and engaging in practical exercises. With this resource, you’ll be set for success.
Updated for the PMP 2024-2025 Exam Structure.
Key features of this enriched guide:
- In-depth insights into the PMP Certification for 2024-2025
- Clear explanations of project management concepts
- Effective strategies for exam preparation and problem-solving
Our guide stands out with its extensive coverage, crucial for your exam triumph. Concepts are not merely touched upon; they are examined in depth with precision.
Please note that this guide operates independently and is not affiliated with any official PMP entity. It is designed solely for your benefit.
Structured clearly and written in accessible language, our PMP Exam Guide 2024-2025 ensures seamless transitions between topics. Bid farewell to complex jargon and embrace clear, concise, and technically accurate content.
So, why hesitate? Click the BUY NOW button to secure your guide and embark on your journey to PMP success for 2024-2025!
Elevate your project management skills and achieve the certification you desire!

Show book

Strategies For Higher Thinking -...

Dwaine AJ Whogoes

Boldly step into the world of AI and revamp your approach to innovation – even if technical jargon sends you into a tailspin. Your journey to mastering artificial intelligence starts here! 
You might have objections fueled by misconceptions and fears. You might think "AI is too complex," "The field evolves too rapidly," or worry that "AI resources don't apply to my specific interests" — rest assured, this guide is designed for readers like you. Our straightforward, inclusive approach ensures that no one is left behind. 
We simplify the complex, ensure content remains current, and provide broad yet specialized coverage — all while debunking common myths that could hold you back. 
Whether you’re an AI novice eager to dip your toes or an enthusiast ready to plunge headfirst, "Strategies for Higher Thinking" gears you up for the journey. Explore the AI landscape, understand its impact, and harness its powerful potential across diverse fields.

Show book