舉報 
會員
PostgreSQL Development Essentials
最新章節：
Summary
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
推薦閱讀
- Learn ECMAScript（Second Edition）
- 軟件項目估算
- MATLAB應用與實驗教程
- 新手學Visual C# 2008程序設計
- AngularJS深度剖析與最佳實踐
- Object-Oriented JavaScript（Second Edition）
- React.js Essentials
- Apache Karaf Cookbook
- Eclipse Plug-in Development：Beginner's Guide（Second Edition）
- 鋒利的SQL（第2版）
- Learning FuelPHP for Effective PHP Development
- C程序設計實踐教程
- 常用工具軟件立體化教程（微課版）
- Java語言程序設計教程
- 區塊鏈技術進階與實戰（第2版）
- Julia 1.0 Programming Complete Reference Guide
- Java程序設計教程
- 現代CPU性能分析與優化
- Qt 5.12實戰
- C語言程序設計實驗指導
- Mastering R for Quantitative Finance
- C語言開發寶典
- Web測試囧事
- HTML5+CSS3從入門到精通（微課精編版）
- Mastering Kali Linux for Advanced Penetration Testing（Second Edition）
- Mastering Microsoft Dynamics AX 2012 R3 Programming
- 算法競賽寶典（第一部）：語言及算法入門
- Java編程詳解（微課版）
- Python深度學習從零開始學
- 千金良方：MySQL性能優化金字塔法則
