PostgreSQL Developer's Guide
| Author | : | |
| Rating | : | 4.25 (832 Votes) |
| Asin | : | B00U64KR44 |
| Format Type | : | |
| Number of Pages | : | 491 Pages |
| Publish Date | : | 2014-02-02 |
| Language | : | English |
DESCRIPTION:
Apart from his professional activities, he is also involved in doing social activities that involve helping people stand on their feet. He has been learning and using PostgreSQL for the last 7 years. Apart from his professional life, he delivers lectures at universities and reads books.Asif FayyazAsif Fayyaz is an open source technology lover and practitioner. He has contributed features such as pg_migrator (now called pg_upgrade) and Index Only Scans to PostgreSQL and has contributed to Google Chromium projects such as platform-independent FTP implementations of the Google Chrome browser, Chromium test framework enhancements, and porting of listen_socket and telnet_server to Linux. Amjad's core expertise lies in the are
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. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability.. Design, develop, and implement streamlined databases with PostgreSQLAbout 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
A great book a right reader. I'm a Postgres DBA and recently a new developer asked me for a book on Postgresql as an introduction to that RDBMS. I’ve pointed him to the official documentation, but it was too much for him. This book would be perfect for that developer.It gives a concise introduction to developing for RDBMS and specifically Postgresql, just enough information to give an idea and even create simple code. The book does not have too many details, and unfortunately sometimes missing explanations. These omissions are under. "a book with lots of well-designed examples" according to Ryan. Given the hyped data science and big data framework buzzwords, the topic this book covers is definitely relevant and important to big data practitioners. The author appears to have a long and solid experience in the industry which gave him much practical knowledge on the subject. Having quickly skimmed through the book, my first impression is the book has a broad coverage of Apache Hive, ranging from the basic setup to security, data manipulation and the detailed explanation on the grammar, complemented with r. Chapters 1-4 are good at describing basics of Postgres and PL/pgSQL Alexander Fyodorov This book leaves me with mixed feelings. Chapters 1-4 are good at describing basics of Postgres and PL/pgSQL, but have somewhat fussy explanations (e.g. exclusion constraints).The purpose, order and content of other chapters are questionable. They cover one tenth of material that possibly can go there These are not the reference and not the primer (especially the capter 9 on libpq).
His other passions include, but are not limited to, traveling to different places, trying different cuisines, and reading books if somehow permitted by his loving family.Amjad ShahzadAmjad Shahzad has been working in the open source software industry for the last 10 years. Apart from his professional activities, he, along with his dedicated friends, is keen to find ways that can make life easier for those who are fac