PostgreSQL Development Essentials by Manpreet Kaur, Baji Shaik
PostgreSQL Development Essentials by Manpreet Kaur, Baji Shaik PDF, ePub eBook D0wnl0ad
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 in your application.
From reader reviews:
Betty Adkins:
The book PostgreSQL Development Essentials can give more knowledge and information about everything you want. Exactly why must we leave a very important thing like a book PostgreSQL Development Essentials? A number of you have a different opinion about reserve. But one aim that will book can give many details for us. It is absolutely correct. Right now, try to closer with your book. Knowledge or data that you take for that, it is possible to give for each other; you may share all of these. Book PostgreSQL Development Essentials has simple shape but the truth is know: it has great and big function for you. You can appear the enormous world by wide open and read a publication. So it is very wonderful.
Dennis Gaines:
Are you kind of hectic person, only have 10 or perhaps 15 minute in your day to upgrading your mind ability or thinking skill possibly analytical thinking? Then you have problem with the book compared to can satisfy your short period of time to read it because this time you only find publication that need more time to be read. PostgreSQL Development Essentials can be your answer because it can be read by you who have those short time problems.
Francis Corder:
You can get this PostgreSQL Development Essentials by visit the bookstore or Mall. Just viewing or reviewing it could to be your solve difficulty if you get difficulties on your knowledge. Kinds of this reserve are various. Not only by means of written or printed and also can you enjoy this book by e-book. In the modern era like now, you just looking because of your mobile phone and searching what their problem. Right now, choose your own personal ways to get more information about your e-book. It is most important to arrange yourself to make your knowledge are still up-date. Let's try to choose right ways for you.
Read PostgreSQL Development Essentials by Manpreet Kaur, Baji Shaik for online ebook
PostgreSQL Development Essentials by Manpreet Kaur, Baji Shaik Free PDF d0wnl0ad, audio books, books to read, good books to read, cheap books, good books, online books, books online, book reviews epub, read books online, books to read online, online library, greatbooks to read, PDF best books to read, top books to read PostgreSQL Development Essentials by Manpreet Kaur, Baji Shaik books to read online.
Tidak ada komentar:
Posting Komentar