舉報(bào) 
會(huì)員
Learning PostgreSQL 10（Second Edition）
最新章節(jié)：
Summary
Ifyou'reinterestedinlearningmoreaboutPostgreSQL-oneofthemostpopularrelationaldatabasesintheworld,thenthisbookisforyou.ThoselookingtobuildsoliddatabaseordatawarehousingapplicationswithPostgreSQL10willalsofindthisbookausefulresource.Nopriorknowledgeofdatabaseprogrammingoradministrationisrequiredtogetstartedwiththisbook.
目錄(346章)
倒序
- 封面
- 版權(quán)信息
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Why subscribe?
- Customer Feedback
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Downloading the color images of this book
- Errata
- Piracy
- Questions
- Relational Databases
- Database management systems
- A brief history
- Database categories
- The NoSQL databases
- The CAP theorem
- NoSQL motivation
- Key-value databases
- Columnar databases
- Document databases
- Graph databases
- Relational and object relational databases
- ACID properties
- The SQL language
- Relational model concepts
- Relation
- Tuple
- NULL value
- Attribute
- Constraint
- Domain integrity constraint
- Entity integrity constraint
- Referential integrity constraints
- Semantic constraints
- Relational algebra
- The select and project operations
- The rename operation
- The set theory operations
- The cartesian product operation
- Data modeling
- Data model perspectives
- The entity-relation model
- Sample application
- Entities attributes and keys
- Mapping ER to relations
- UML class diagrams
- Summary
- PostgreSQL in Action
- An overview of PostgreSQL
- PostgreSQL history
- The advantages of PostgreSQL
- Business advantages of PostgreSQL
- PostgreSQL user advantages
- PostgreSQL applications
- Success stories
- Forks
- PostgreSQL architecture
- The PostgreSQL community
- PostgreSQL capabilities
- Replication
- Security
- Extension
- NoSQL capabilities
- Foreign data wrappers
- Performance
- Installing PostgreSQL
- Installing PostgreSQL using Advanced Package Tool
- Client installation
- Server installation
- Basic server configuration
- Installing PostgreSQL on Windows
- The PostgreSQL clients
- The psql client
- psql advanced settings
- PostgreSQL utility tools
- Summary
- PostgreSQL Basic Building Blocks
- Database coding
- Database naming conventions
- PostgreSQL identifiers
- Documentation
- Version control system
- Database migration tool
- PostgreSQL objects hierarchy
- Template databases
- User databases
- Roles
- Tablespace
- Template procedural languages
- Settings
- PostgreSQL high-level object interaction
- PostgreSQL database components
- Schema
- Schema usages
- Table
- PostgreSQL native data types
- Numeric types
- Character types
- Date and time types
- The car web portal database
- Summary
- PostgreSQL Advanced Building Blocks
- Views
- View synopsis
- View categories
- Materialized views
- Updatable views
- Indexes
- Index synopsis
- Index selectivity
- Index types
- Index categories
- Best practices on indexes
- Functions
- PostgreSQL native programming language
- Creating a function in the C language
- Function usages
- Function dependency
- PostgreSQL function categories
- PostgreSQL anonymous functions
- User-defined data types
- Triggers and rule systems
- Rule system
- Trigger system
- Triggers with arguments
- Triggers and updatable views
- Summary
- SQL Language
- SQL fundamentals
- SQL lexical structure
- Querying data with SELECT statements
- Structure of a SELECT query
- Select-list
- SQL expressions
- DISTINCT
- FROM clause
- Selecting from multiple tables
- Self-joins
- The WHERE clause
- Comparison operators
- Pattern matching
- Row and array comparison constructs
- Grouping and aggregation
- The GROUP BY clause
- The HAVING clause
- Ordering and limiting the results
- Subqueries
- Set operations – UNION EXCEPT and INTERSECT
- Dealing with NULLs
- Changing the data in the database
- INSERT statement
- The UPDATE statement
- UPDATE using sub-select
- UPDATE using additional tables
- The DELETE statement
- The TRUNCATE statement
- Summary
- Advanced Query Writing
- Common table expressions
- Reusing SQL code with CTE
- Recursive and hierarchical queries
- Changing data in multiple tables at a time
- Window functions
- Window definition
- The WINDOW clause
- Using window functions
- Window functions with grouping and aggregation
- Advanced SQL techniques
- Selecting the first records
- Selecting a data sample
- Set returning functions
- Lateral subqueries
- Advanced grouping
- Advanced aggregation
- Summary
- Server-Side Programming with PL/pgSQL
- SQL language and PL/pgSQL – a comparison
- PostgreSQL function parameters
- Function authorization-related parameters
- Function planner-related parameters
- Function configuration-related parameters
- The PostgreSQL PL/pgSQL control statements
- Declaration statements
- Assignment statements
- Conditional statements
- Iteration
- Loop statement
- While loop statement
- For loop statement
- Returning from the function
- Returning void
- Returning a single row
- Returning multiple rows
- Function predefined variables
- Exception handling
- Dynamic SQL
- Executing DDL statements in dynamic SQL
- Executing DML statements in dynamic SQL
- Dynamic SQL and the caching effect
- Recommended practices for dynamic SQL usage
- Summary
- OLAP and Data Warehousing
- Online analytical processing
- Extract transform and load
- Data modeling for OLAP
- Aggregation
- Partitioning
- Parallel query
- Index-only scans
- Summary
- Beyond Conventional Data Types
- Arrays
- Common functions of arrays and their operators
- Modifying and accessing arrays
- Indexing arrays
- The hash store data structure
- Indexing an hstore
- The JSON data structure
- JSON and XML
- JSON data types for PostgreSQL
- Modifying and accessing JSON types
- Indexing a JSON data type
- Providing a RESTful API interface for PostgreSQL
- A PostgreSQL full text search
- The tsquery and tsvector data types
- The tsvector data type
- The tsquery data type
- Pattern matching
- Full text search indexing
- Summary
- Transactions and Concurrency Control
- Transactions
- Transaction and ACID properties
- Transaction and concurrency
- MVCC in PostgreSQL
- Transaction isolation levels
- Explicit locking
- Table-level locks
- Table locking modes
- Row-level locks
- Row-level lock modes
- Deadlocks
- Advisory locks
- Summary
- PostgreSQL Security
- Authentication in PostgreSQL
- PostgreSQL pg_hba.conf
- Listen addresses
- Authentication best practices
- PostgreSQL default access privileges
- Role system and proxy authentication
- PostgreSQL security levels
- Database security level
- Schema security level
- Table-level security
- Column-level security
- Row-level security
- Encrypting data
- PostgreSQL role password encryption
- pgcrypto
- One-way encryption
- Two-way encryption
- Summary
- The PostgreSQL Catalog
- The system catalog
- System catalog for administrators
- Getting the database cluster and client tools version
- Terminating and canceling user sessions
- Defining and getting database cluster settings
- Getting the database and database object size
- Cleaning up the database
- Cleaning up the database data
- Tuning for performance
- Selective dump
- Summary
- Optimizing Database Performance
- PostgreSQL configuration tuning
- Maximum number of connections
- Memory settings
- Hard disk settings
- Planner-related settings
- Bench marking is your friend
- Tuning performance for write
- Tuning performance for read
- Explain command and execution plan
- Detecting problems in query plans
- Common mistakes in writing queries
- Unnecessary operations
- Misplaced or missing indexes
- Using CTE when not mandatory
- Using the PL/pgSQL procedural language consideration
- Cross column correlation
- Table partitioning
- Constraint exclusion limitations
- Query rewriting
- Summary
- Testing
- Unit testing
- Specificity of unit testing in databases
- Unit test frameworks
- Schema difference
- Database abstraction interfaces
- Data difference
- Performance testing
- Summary
- Using PostgreSQL in Python Applications
- Python DB API 2.0
- Low-level database access with psycopg2
- Connecting to a database
- Connection pooling
- Executing SQL commands
- Reading data from a database
- The COPY command
- Asynchronous access
- Alternative drivers for PostgreSQL
- pg8000
- asyncpg
- Object relational mapping with SQLAlchemy
- Main components of SQLAlchemy
- Connecting to a database and retrieving data with SQL Expression Language
- ORM
- Summary
- Scalability
- The problem of scalability and the CAP theorem
- Data replication in PostgreSQL
- Transaction log
- Physical replication
- Log shipping replication
- Streaming replication
- Synchronous replication
- Logical replication
- Using replication to scale PostgreSQL
- Scaling for heavy querying
- Data sharding
- Scaling for big number of connections
- Summary 更新時(shí)間：2021-07-02 22:42:54
推薦閱讀
- Div+CSS 3.0網(wǎng)頁布局案例精粹
- 智能傳感器技術(shù)與應(yīng)用
- 走入IBM小型機(jī)世界
- 可編程控制器技術(shù)應(yīng)用（西門子S7系列）
- Machine Learning with the Elastic Stack
- Azure PowerShell Quick Start Guide
- Working with Linux：Quick Hacks for the Command Line
- 人工智能技術(shù)入門
- Ansible 2 Cloud Automation Cookbook
- Drupal高手建站技術(shù)手冊(cè)
- 機(jī)床電氣控制與PLC
- 智能制造系統(tǒng)及關(guān)鍵使能技術(shù)
- Learn Microsoft Azure
- FANUC工業(yè)機(jī)器人虛擬仿真教程
- SQL Server 2019 Administrator's Guide
- 巧學(xué)活用AutoCAD
- 商務(wù)智能
- Mastering Windows Group Policy
- 從虛擬化到云計(jì)算
- 自動(dòng)控制原理
- 微機(jī)原理及接口技術(shù)
- 數(shù)字媒體交互設(shè)計(jì)原理與方法
- Getting Started with Flurry Analytics
- 喬家大院里的女人與Photoshop創(chuàng)意設(shè)計(jì)
- 企業(yè)網(wǎng)搭建及應(yīng)用寶典
- 計(jì)算機(jī)控制技術(shù)（第2版）
- 高級(jí)PLC硬件和編程：基于Allen-Bradley和Siemens平臺(tái)的軟、硬件基礎(chǔ)和高級(jí)技術(shù)
- Hands-On Software Engineering with Python
- Cisco ACI Cookbook
- Linux核心應(yīng)用命令速查
