Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad - PostgreSQL Developer's Guide - 2015 (+Code)seeders: 0
leechers: 0
Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad - PostgreSQL Developer's Guide - 2015 (+Code) (Size: 6.12 MB)
Description PostgreSQL Developer's Guide Year: 2015 Author: Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad Publisher: Packt Publishing ISBN: 978-1-78398-902-7 Language English Format: PDF / EPUB Quality: initially computer (eBook) Interactive contents: Yes Number of pages: 270 Description: 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 What You Will Learn Refresh your knowledge of SQL with PostgreSQL-supported DDL and DML Explore native PostgreSQL procedural languages ??and learn how to write custom functions Leverage the power of indexes for optimal database efficiency Unfold tricky trigger concepts and implement them in native procedural languages Discover how to implement views, partitioned tables, and window functions in PostgreSQL Design efficient queries with query optimization and query analysis Communicate with PostgreSQL servers using foreign data wrappers such as LibPQ and ECPG Extend database powers using foreign data wrappers and achieve maintainability via PostgreSQL extensions 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 Preface Chapter 1: Getting Started with PostgreSQL Writing queries using psql Creating, altering, and truncating a table Inserting, updating, and deleting data from tables PostgreSQL's supported data types PostgreSQL's operators and usage Constraints in PostgreSQL Privileges in PostgreSQL Chapter 2: The Procedural Language Why should you use PL / pgSQL? Installing PL / pgSQL Understanding the structure of PL / pgSQL Using comments in PL / pgSQL Declaring variables in PL / pgSQL Declaring function parameters Declaring the% TYPE attribute Declaring the row-type and record type variables Statements and expressions Control structures Exception handling Native support for other procedural languages Chapter 3: Working with Indexes What is an index? How to create an index How to drop an index Types of indexes Index types Index bloating Reindexing Points to ponder Chapter 4: Triggers, Rules, and Views Understanding triggers PostgreSQL rules Understanding views Chapter 5: Window Functions Understanding window functions Chapter 6: Partitioning Creating a table partition Partitioning in PostgreSQL Chapter 7: Query Optimization What is EXPLAIN? Cost parameters Sequential scans Index scans Bitmap scans Common Table Expressions Joins Query planning Hints Configuration parameters to optimize queries Chapter 8: Dealing with Large Objects Why large objects? PostgreSQLlarge objects Manipulating large objects through the libpq client interface library Chapter 9: Communicating with PostgreSQL Using LibPQ Connecting and disconnecting to PostgreSQL Establishing a connection asynchronously Connection-supporting functions Executing a query Executing prepared statements Retrieving data Using status functions Chapter 10: Embedded SQL in C - ECPG Writing ECPG programs Compiling an ECPG program Running SQLcommands Error handling Chapter 11: Foreign Data Wrapper Creating foreign data wrappers The basic components of foreign data wrappers Loading foreign data wrappers Using foreign data wrappers Chapter 12: Extensions Features of an extension Creating extensions Altering extensions Dropping extensions How to check available extensions Additional supplied extensions Other available extensions Index Sharing Widget |