Поиск  
Always will be ready notify the world about expectations as easy as possible: job change page
Книги для разработчиков

PostgreSQL Developer's Guide

PostgreSQL Developer's Guide

Год:
Страниц:
270
Просмотров:
1116

Описание

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.

Похожее
Создаем динамические веб-сайты с помощью PHP, MySQL, JavaScript, CSS и HTML5
Автор: Робин Никсон
Год: 2016
Научитесь создавать интерактивные сайты, активно работающие с данными, воплощая в них мощные ком-бинации свободно распространяемых технологий и веб-стандартов. Для этого достаточно обладать базовымизнаниями языка HTML. Это популярное и доступное пособие поможет вам уверенно освоить динамическоевеб-программирование с применением самых современных языков...
Troubleshooting PostgreSQL
Автор: Hans-Jürgen Schönig
Год: 2015
PostgreSQL is a powerful, open source, object-relational database system. PostgreSQL offers many advantages for your company or business over other database systems.This book is your practical guide to understanding the advanced techniques used to handle complex data and methods to...
NoSQL: Database for Storage and Retrieval of Data in Cloud
Автор: Ganesh Chandra Deka
Год: 2017
This book discusses the advanced databases for the cloud-based application known as NoSQL. It will explore the recent advancements in NoSQL database technology. Chapters on structured, unstructured and hybrid databases will be included to explore bigdata analytics, bigdata storage and...
Написать сообщение
Тип
Почта
Имя
*Сообщение