ebooks and download videos Search All  Title  Author 
Home / Nonfiction / Computers / Database Management / Servers

PostgreSQL Development Essentials

| £26.66 | €29.98 | Ca$43.24 | Au$42.68
by Manpreet Kaur & Baji Shaik
What is this?DRM-EPUB | by download   add to wish list
PostgreSQL Development Essentials by Manpreet Kaur & Baji Shaik

Develop programmatic functions to create powerful database applications About This Book • Write complex SQL queries and design a robust database design that fits your application's need • Improve database performance by indexing, partitioning tables, and query optimizing • A comprehensive guide covering the advanced PostgreSQL concepts without any hassle Who This Book Is For If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you're want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite. What You Will Learn • Write more complex queries with advanced SQL queries • Design a database that works with the application exactly the way you want • Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing • Develop applications in other programming languages such as Java and PHP • Use extensions to get extra benefits in terms of functionality and performance • Build an application that does not get locked by data manipulation • Explore in-built db functions and data type conversions In Detail PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it's difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database. The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts Style and approach Every chapter follows a step by step approach that first explains the concept , then shows you how to execute it practically so that you can implement them

To view this DRM protected ebook on your desktop or laptop you will need to have Adobe Digital Editions installed. It is a free software. We also strongly recommend that you sign up for an AdobeID at the Adobe website. For more details please see FAQ 1&2. To view this ebook on an iPhone, iPad or Android mobile device you will need the Adobe Digital Editions app, or BlueFire Reader or Txtr app. These are free, too. For more details see this article.

SHARE  Share by Email  Share on Facebook  Share on Twitter  Share on Linked In  Share on Delicious
or call in the US toll free 1-888-866-9150 product ID: 873518

Ebook Details
Pages: 210
Size: 1.6 MB
Publisher: Packt Publishing
Date published:   2016
ISBN: 9781783989010 (DRM-EPUB)

DRM Settings
Copying:not allowed
Printing:not allowed
Read Aloud:  not allowed

Territory Restrictions
This ebook will only be sold to customers with a billing address in:

This product is listed in the following categories:

Nonfiction > Computers > Database Management
Nonfiction > Computers > Database Management > Database Mining
Nonfiction > Computers > Database Management > Servers

If you find anything wrong with this product listing, perhaps the description is wrong, the author is incorrect, or it is listed in the wrong category, then please contact us. We will promptly address your feedback.

Submit 5 page SummaryWhat is this?

© 2016