Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL Developer s Guide

PostgreSQL Developer s Guide, 9781783989027 (1783989025), Packt Publishing, 2015

Design, develop, and implement streamlined databases with PostgreSQL

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.

(HTML tags aren't allowed.)

Network Security Principles and Practices
Network Security Principles and Practices

Expert solutions for securing network infrastructures and VPNs.

  • Build security into the network by defining zones, implementing secure routing protocol designs, and building safe LAN switching environments

  • Understand the inner...

PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL databases, Second Edition
PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL databases, Second Edition

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach...

SSL & TLS Essentials: Securing the Web
SSL & TLS Essentials: Securing the Web
The Secure Sockets Layer (SSL) and Transport Layer Security(TLS) protocols form the foundation for e-commerce security on the World Wide Web, verifying the authenticity of Web sites, encrypting the transfer of sensitive data, and ensuring the integrity of information exchanged. Now—for the first time the details of these critical security...

JavaScript Bible, Gold Edition
JavaScript Bible, Gold Edition
The JavaScript Bible, Gold Edition covers the new powerful functionality JavaScript gains with the release of the new fifth generation revisions of Internet Explorer and Netscape Communicator. The book includes all the great content included in the JavaScript Bible, 4th Edition, an international bestseller, plus over 400 pages of...
Mastering Visual C++ 6
Mastering Visual C++ 6
At 1400 pages, Mastering Visual C++ 6 is the one-stop reference for programmers (beginners through experts) who want to learn Microsoft's powerful 32-bit Visual C++ development environment. The book's tutorial "framework" provides a complete introduction to Microsoft's Win 32 programming architecture that lets you quickly create...
Herb Schildt's C++ Programming Cookbook
Herb Schildt's C++ Programming Cookbook

Your Ultimate "How-To" Guide to C++ Programming!

Legendary programming author Herb Schildt shares some of his favorite programming techniques in this high-powered C++ "cookbook." Organized for quick reference, each "recipe" shows how to accomplish a practical programming task. A recipe...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy