Description
Book Synopsis: 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 PostgreSQL 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.
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
Read more
Details
Upgrade your database game with "PostgreSQL: Up and Running," a comprehensive guide to the advanced open source database system. Dive into PostgreSQL's enterprise class features and discover it's more than just a database—it's a powerful application platform. With real-world examples, this book will show you how to accomplish tasks that were previously challenging in other databases. Stay ahead with the latest updates and enhancements, including new full text functions, query parallelization features, and built-in logical replication. Whether you're new to PostgreSQL or a seasoned user, this book will take your understanding and utilization of the database to the next level.
Are you ready to unlock the full potential of PostgreSQL? With this third edition, you will explore basic administration tasks, use essential tools like psql and pgAdmin, and master SQL constructs unique to PostgreSQL. From tuning queries for optimal performance to querying external data sources with foreign data wrappers, this book covers everything you need to know to maximize the capabilities of PostgreSQL. Don't miss out on this valuable resource that will boost your productivity and efficiency in managing databases.
If you want to stay on top of your database game and harness the power of PostgreSQL, "PostgreSQL: Up and Running" is the ultimate guide you need. Take your PostgreSQL skills to the next level and become a master of this advanced open source database system. Don't miss out on this opportunity to enhance your knowledge and skills in database management. Get your copy now!
Discover More Best Sellers in Databases & Big Data
Shop Databases & Big Data
$25.99
Databases & Big Data - Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
$37.21
Databases & Big Data - Azure Databricks Cookbook: Accelerate and scale real-time analytics solutions using the Apache Spark-based analytics service
Generative Deep Learning: Teaching Machines To Paint, Write, Compose, and Play
$53.99
Databases & Big Data - Generative Deep Learning: Teaching Machines To Paint, Write, Compose, and Play
$36.99
Databases & Big Data - Data Science for Marketing Analytics: A practical guide to forming a killer marketing strategy through data analysis with Python, 2nd Edition
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
$9.95
Databases & Big Data - Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
$16.97
Databases & Big Data - MacBook for Non-Tech-Savvy Seniors: The Most Exhaustive and Intuitive Guide to Master Your MacBook Air & Pro. Includes Illustrated Step-by-Step Instructions and Helpful Tips (Senior-Friendly Manuals)
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
$43.99
Databases & Big Data - Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Text as Data: A New Framework for Machine Learning and the Social Sciences
$30.99
Databases & Big Data - Text as Data: A New Framework for Machine Learning and the Social Sciences
