會員

PostgreSQL Development Essentials

Manpreet Kaur Baji Shaik 著

更新時間：2021-07-14 10:01:05

開會員，本書免費讀 >

IfyouareaPostgreSQLdeveloperwithabasicknowledgeofPostgreSQLdevelopmentandyou’rewantdeeperknowledgetodevelopapplications,thenthisbookisforyou.Asthisbookdoesnotcoverbasicinstallationandconfigurations,youshouldhavePostgreSQLinstalledonyourmachineasaprerequisite.

目錄(77章)

倒序

封面
版權頁
Credits
About the Authors
About the Reviewers
www.PacktPub.com
eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Advanced SQL
Creating views
Materialized views
Creating cursors
Using the GROUP BY clause
Using the HAVING clause
Using the UPDATE operation clauses
Using the LIMIT clause
Using subqueries
Subqueries that return multiple rows
Using the Union join
Using the Self join
Using the Outer join
Summary
Chapter 2. Data Manipulation
Conversion between datatypes
Introduction to arrays
Summary
Chapter 3. Triggers
Introduction to triggers
Creating a trigger function
Summary
Chapter 4. Understanding Database Design Concepts
Basic design rules
Normalization
Anomalies in DBMS
Summary
Chapter 5. Transactions and Locking
Defining transactions
Summary
Chapter 6. Indexes and Constraints
Introduction to indexes and constraints
Clustering on an index
Exclusion constraints
Summary
Chapter 7. Table Partitioning
Table partitioning
Summary
Chapter 8. Query Tuning and Optimization
Query tuning
Optimizer settings for cached data
Multiple ways to implement a query
Bad query performance with stale statistics
Explain Plan
Query operators
Summary
Chapter 9. PostgreSQL Extensions and Large Object Support
Creating an extension
Using binary large objects
Summary
Chapter 10. Using PHP in PostgreSQL
Postgres with PHP
PHP-to-PostgreSQL connections
Dealing with DDLs
DML operations
Data retrieval
Helper functions to deal with data fetching
Summary
Chapter 11. Using Java in PostgreSQL
Making database connections to PostgreSQL using Java
Using prepared statements
Connection properties
Summary 更新時間：2021-07-14 10:01:05

官术网_书友最值得收藏!

PostgreSQL Development Essentials