Description: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 application platform.With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. 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 restoreApply the psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with foreign data wrappersLearn how use built-in replication filters to replicate data"We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database. To get started finding PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.
Pages
—
Format
PDF, EPUB & Kindle Edition
Publisher
—
Release
—
ISBN
144937316X
PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database
Description: 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 application platform.With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. 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 restoreApply the psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with foreign data wrappersLearn how use built-in replication filters to replicate data"We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database. To get started finding PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.