About This BookDesign efficient, real-world database solutions and extend your knowledge of database conceptsLearn how to program using native PostgreSQL procedural languages to write custom functionsExplore database partitioning and learn about query optimization techniquesWho This Book Is ForIf 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 requiredWhat You Will LearnRefresh your knowledge of SQL with PostgreSQL-supported DDL and DMLExplore native PostgreSQL procedural languages and learn how to write custom functionsLeverage the power of indexes for optimal database efficiencyUnfold tricky trigger concepts and implement them in native procedural languagesDiscover how to implement views, partitioned tables, and window functions in PostgreSQLDesign efficient queries with query optimization and query analysisCommunicate with PostgreSQL servers using foreign data wrappers such as LibPQ and ECPGExtend database powers using foreign data wrappers and achieve maintainability via PostgreSQL extensionsIn DetailPostgreSQL 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.