
Shipping Estimate
USA
- USA
- CAN
- USA
- CAN
Ships within 48 hours · Estimated delivery Jul 4 - Jul 9
For Your Every Summer RSVP, with Code: SUMMER15
Description
PostgreSQL: Up and RunningIf youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9. 2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font family: Verdana; font size: 11px; text
If youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9.2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font-family: Verdana; font-size: 11px; text-align: justify;"With numerous examples throughout this book, youll learn how to achieve tasks that are difficult or impossible in other databases. If youre an existing PostgreSQL user, youll pick up gems you may have missed along the way.
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 replicate data, using built-in replication features
Chapter 1 The Basics
Where to Get PostgreSQL
Administration Tools
Whats New in Latest Versions of PostgreSQL?
Database Drivers
Server and Database Objects
Where to Get Help
Chapter 2 Database Administration
Configuration Files
Setting Up Groups and Login Roles (Users)
Databases and Management
Extensions and Contribs
Backup
Restore
Managing Disk Space with Tablespaces
Verboten
Chapter 3 psql
Interactive psql
Non-Interactive psql
Session Configurations
psql Gems
Importing and Exporting Data
Basic Reporting
Chapter 4 Using pgAdmin
Getting Started
pgAdmin Features
pgScript
Graphical Explain
Job Scheduling with pgAgent
Chapter 5 Data Types
Numeric Data Types
Arrays
Character Types
Temporal Data Types
XML
Custom and Composite Data Types
Chapter 6 Of Tables, Constraints, and Indexes
Tables
Constraints
Indexes
Chapter 7 SQL: The PostgreSQL Way
SQL Views
Window Functions
Common Table Expressions
Constructions Unique to PostgreSQL
Chapter 8 Writing Functions
Anatomy of PostgreSQL Functions
Writing Functions with SQL
Writing PL/pgSQL Functions
Writing PL/Python Functions
Trigger Functions
Aggregates
Chapter 9 Query Performance Tuning
EXPLAIN and EXPLAIN ANALYZE
Writing Better Queries
Guiding the Query Planner
Caching
Chapter 10 Replication and External Data
Replication Overview
Setting Up Replication
Foreign Data Wrappers (FDW)
Appendix Install, Hosting, and Command-Line Guides
Installation Guides and Distributions
Where to Host PostgreSQL
PostgreSQL Packaged Command-Line Tools
Shipping Notes
- Free Standard Shipping on $100+ Orders to the USA.
- Except Preorder products are shipped in 48 hours.
- Delivery to the USA:
- Standard Shipping : 3-10 business days
- If time is of the essence, please consider selecting expedited delivery for faster service.
Exchange/Return Notes
- We offer a 30-day return/exchange service after receiving.
- Final sale items are not eligible for returns or exchanges.
- To process your return/exchange, please contact us at [email protected]
- Please click here for more details>>> Return & Exchange Policy