Design, develop, and implement streamlined databases with PostgreSQL
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.
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
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.