Advertisement
Search  
Always will be ready notify the world about expectations as easy as possible: job change page
Books for developers

PostgreSQL Developer's Guide

PostgreSQL Developer's Guide

Author: Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad
Year: 2015
Format: PDF
Pages: 270
Views: 1057

1,61 MB
Description

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.

Similar
Путь программиста. Самоучитель по языку Transact-SQL
Автор: Виталий Трунин
Год: 2020
Страниц: 204
Данная книга предназначена для тех людей, которые не знают языка T-SQL и даже об SQL мало что слышали, но хотят или им нужно освоить данный язык, иными словами, книга для начинающих. Идея написания данной книги у меня возникла, когда я...
Professional NoSQL
Автор: Shashank Tiwari
Год: 2011
Страниц: 386
THE GROWTH OF USER-DRIVEN CONTENT has fueled a rapid increase in the volume and type of data that is generated, manipulated, analyzed, and archived. In addition, varied newer sets of sources, including sensors, Global Positioning Systems (GPS), automated trackers and...
MongoDB Cookbook, 2nd Edition
Автор: Cyrus Dasadia, Amol Nayak
Год: 2016
Страниц: 371
MongoDB is a high-performance and feature-rich NoSQL database that forms the backbone of the systems that power many different organizations – it's easy to see why it's the most popular NoSQL database on the market. Packed with many features that...
PostgreSQL Server Programming, Second Edition
Автор: Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal
Год: 2015
Страниц: 320
This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and...
Send message
Email
Your name
*Message


© 1999–2024 WebDynamics
1980–... Sergey Drozdov
Area of interests: .NET Framework | .NET Core | C# | ASP.NET | Windows Forms | WPF | HTML5 | CSS3 | jQuery | AJAX | Angular | React | MS SQL Server | Transact-SQL | ADO.NET | Entity Framework | IIS | OOP | OOA | OOD | WCF | WPF | MSMQ | MVC | MVP | MVVM | Design Patterns | Enterprise Architecture | Scrum | Kanban