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

Buy
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.)

ADO.NET 3.5 Cookbook
ADO.NET 3.5 Cookbook

This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio...

Networks-on-Chips: Theory and Practice (Embedded Multi-core Systems)
Networks-on-Chips: Theory and Practice (Embedded Multi-core Systems)

This book addresses many challenging topics related to the NoC research area. It starts by studying 3D NoC architectures and progresses to a discussion of NoC resource allocation, processor traffic modeling, and formal verification. NoC protocols are examined at different layers of abstraction. Also, several emerging research issues in NoC...

ADO.NET Cookbook
ADO.NET Cookbook
ADO.NET Cookbook is a comprehensive collection of over 150 solutions and best practices for everyday dilemmas. For each problem addressed in the book, there's a solution--a short, focused piece of code that programmers can insert directly into their applications The diverse solutions presented here will prove...

Complete PCB Design Using OrCad Capture and Layout
Complete PCB Design Using OrCad Capture and Layout
Complete PCB Design Using OrCAD Capture and Layout is the first book to offer a complete guide on how to use the OrCAD design suite to design and manufacture printed circuit boards. Professionals and students will find this book to be an easily accessible resource covering topics from the basic PCB design principles to advanced levels of specific...
Linguistic Structure Prediction (Synthesis Lectures on Human Language Technologies)
Linguistic Structure Prediction (Synthesis Lectures on Human Language Technologies)

A major part of natural language processing now depends on the use of text data to build linguistic analyzers. We consider statistical, computational approaches to modeling linguistic structure. We seek to unify across many approaches and many kinds of linguistic structures. Assuming a basic understanding of natural language processing and/or...

Sound Sleep, Sound Mind: 7 Keys to Sleeping through the Night
Sound Sleep, Sound Mind: 7 Keys to Sleeping through the Night

Do you lie awake each night tossing and turning, trying to fall asleep or stay asleep? Are you tired of the quick-fix, over-the-counter, or prescription drug remedies that promise more than they deliver? If you're one of the millions who struggle with sleepless nights, you need to know that most people with insomnia or other...

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