PostgreSQL Developer's Guide
Год: 2015
Автор: Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad
Издательство: Packt Publishing
ISBN: 978-1-78398-902-7
Язык: Английский
Формат: PDF/EPUB
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 270
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.
Примеры страниц Оглавление
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
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
Query planning
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
До перезалития, торрент был скачан - 1107 раз.Торрент перезалит. Причина: замена PDF и EPUB на True-версии. Добавлены исходники кода.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 2 MB Download Torrent

Login using:


Similar topics

Current time is: 18-Dec 23:55 :: All times are UTC + 3