文件名称：PostgreSQL.Developers.Guide
文件大小：1.61MB
文件格式：PDF
更新时间：2018-04-21 03:41:08
PostgreSQL
Title: PostgreSQL Developer’s Guide Author: Amjad Shahzad, Asif Fayyaz, Ibrar Ahmed Length: 201 pages Edition: 1 Language: English Publisher: Packt Publishing Publication Date: 2015-02-20 ISBN-10: 1783989025 ISBN-13: 9781783989027 Design, develop, and implement streamlined databases with PostgreSQL About This Book Design efficient, real-world database solutions and extend your knowledge of database concepts Learn how to program using native PostgreSQL procedural languages to write custom functions Explore database partitioning and learn about query optimization techniques Who This Book Is For If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required In Detail PostgreSQL is an enterprise-level database that competes among proprietary database vendors, owing to its remarkable feature set and reliability without the expensive licensing overhead. This book is a comprehensive and pragmatic guide to developing databases in PostgreSQL. Beginning with a refresher of basic SQL skills, you will gradually be exposed to advanced concepts, such as learning how to program in native PostgreSQL procedural languages, implementing triggers, custom functions, and views. You will learn database optimization techniques such as query optimization and indexing while exploring extensive code examples. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability. Table of Contents Chapter 1. Getting Started with PostgreSQL Chapter 2. The Procedural Language Chapter 3. Working with Indexes Chapter 4. Triggers, Rules, and Views Chapter 5. Window Functions Chapter 6. Partitioning Chapter 7. Query Optimization Chapter 8. Dealing with Large Objects Chapter 9. Communicating with PostgreSQL Using LibPQ Chapter 10. Embedded SQL in C – ECPG Chapter 11. Foreign Data Wrapper Chapter 12. Extensions