PostgreSQL: Up and Running, 3rd Edition
A Practical Guide to the Advanced Open Source Database
Price | $25.95 - $33.14
|
Rating | |
Authors | Regina Obe, Leo Hsu |
Publisher | O'Reilly Media |
Published | 2017 |
Pages | 314 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1491963417 |
ISBN-13 | 9781491963418 |
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system - it's an impressive application platform as well.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.
If you're a current PostgreSQL user, you'll pick up gems you may have missed before.
Learn basic administration tasks such as role management, database creation, backup, and restore; Apply the psql command-line utility and the pgAdmin graphical administration tool; Explore PostgreSQL tables, constraints, and indexes; Learn powerful SQL constructs not generally found in other databases; Use several different languages to write database functions; Tune your queries to run as fast as your hardware will allow; Query external and variegated data sources with foreign data wrappers; Learn how to use built-in replication to replicate data.
- Regina Obe (2 books)
- Leo Hsu (2 books)
4 5 204
Similar Books
by Kevin Makice
This groundbreaking book provides you with the skills and resources you need to build web applications for Twitter. Perfect for new and casual programmers intrigued by the microblogging, Twitter API: Up and Running carefully explains how each part of Twitter's API works, with detailed examples that show you how to assemble those buil...
Price: $25.68 | Publisher: O'Reilly Media | Release: 2009
by Wei-Meng Lee
This compact book offers the quickest path for Windows XP and Vista users to get started with Microsoft's Windows 7 operating system. With Windows 7: Up and Running, you get the essential information you need to upgrade or install the system and configure it to fit your activities, along with a tour of Windows 7's features and b...
Price: $15.00 | Publisher: O'Reilly Media | Release: 2009
Terraform: Up and Running, 3rd Edition
by Yevgeniy Brikman
Terraform has become a key player in the DevOps world for defining, launching, and managing infrastructure as code (IaC) across a variety of cloud and virtualization platforms, including AWS, Google Cloud, Azure, and more. This hands-on third edition, expanded and thoroughly updated for version 1.0 and beyond, shows you the fastest way to...
Price: $41.99 | Publisher: O'Reilly Media | Release: 2022
by Mark Pilgrim
If you don't know about the new features available in HTML5, now's the time to find out. This book provides practical information about how and why the latest version of this markup language will significantly change the way you develop for the Web.HTML5 is still evolving, yet browsers such as Safari, Mozilla, Opera, and Chrome ...
Price: $19.39 | Publisher: O'Reilly Media | Release: 2010
Pro Android Games, 3rd Edition
by Vladimir Silva, Massimo Nardone
Combining actionable, real-world source code with graphics, Pro Android Games, Third Edition shows you how to build more sophisticated and addictive Android game apps with minimum effort. Harness the power of the latest Android 5.0 SDK to bring countless legendary, action-packed PC games to the Android platform.With actionable real-world ...
Price: $44.99 | Publisher: Apress | Release: 2015
Ansible: Up and Running, 3rd Edition
by Bas Meijer, Lorin Hochstein, Rene Moser
Among the many configuration management tools available, Ansible has some distinct advantages: It's minimal in nature. You don't need to install agents on your nodes. And there's an easy learning curve. With this updated third edition, you'll quickly learn how to be productive with Ansible whether you're a develop...
Price: $41.99 | Publisher: O'Reilly Media | Release: 2022
Windows Server 2012: Up and Running
by Samara Lynn
If your organization plans to move to a cloud infrastructure from a LAN or WAN, this book shows you how to do it efficiently with Windows Server 2012. Experienced Windows administrators will learn how to deploy, configure, and manage the server's expanded capabilities and features step-by-step, using clear examples and numerous scree...
Price: $33.96 | Publisher: O'Reilly Media | Release: 2012
PostgreSQL: Up and Running, 2nd Edition
by Regina O. Obe, Leo S. Hsu
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system - it's also an impressive applicatio...
Price: $25.95 | Publisher: O'Reilly Media | Release: 2014