作者
digoal
日期
2020-08-14
标签
PostgreSQL , 交互式学习
背景
如果你是PG小白, 想软着陆入门PostgreSQL, 同时希望未来有较大提升. 可以看一下这篇文档.
Crunchy是一家专注于让PG在企业中持续运行的产品开发商.
同时也是PostgreSQL的major sponsor, 他们提供了一个比较好的交互式学习PG的文档和平台. 建议可以先从这里学起, 多练习.
https://learn.crunchydata.com/
PostgreSQL Interactive Learning Portal
PostgreSQL Administration
- 1 - Setting Up PostgreSQL
- 2 - Setting Up PostgreSQL Replication
- 3 - PG Dump & Restore
- 4 - PGBasebackup
- 5 - pgBackRest
- 6 - Failover
- Native Partitioning
- Logical Replication
PostgreSQL for Application Developers
- Introduction to Using the Command Line with PostgreSQL
- Introduction to Create Table in PostgreSQL
- Introduction to Data Types
- Advanced Data Types
- Introduction to PostgreSQL Data Constraints
- Add Data with INSERT
- Introduction To PostgreSQL in Containers
- Using PgAdmin4 as a GUI to your PostgreSQL Server
- Using EXPLAIN (ANALYZE) on Your Queries
- Introduction to Indexes
- Index Types in PostgreSQL
Full Text Search in PostgreSQL
- JSON in PostgreSQL 11
- Basics of Writing PostgreSQL Functions
- Using R in PostgreSQL
- Using Python in PostgreSQL
- Learning Lateral Joins
PostGIS
- 0 - Quick Introduction To PostGIS
- 1 - Geometries
- 2 - Geography
- 3 - Projection
- 4 - Spatial Relationships
- 5 - Geometry Constructing Functions
- 6 - Spatial Joins
- 7 - Advanced Spatial Joins
- 8 - Spatial Indexing
- 9 - Creating Spatial Features with pg_featureserv
- 10 - Creating Dynamic Vector Tiles with pg_tileserv
PostgreSQL for Kubernetes/OpenShift
- Basic Usage of the Crunchy Postgres Operator
- Advanced Usage of the Crunchy Postgres Operator
配套的文档:
https://www.crunchydata.com/developers/postgresql-documentation
学完以上的内容, 可以再辅助参考一下
https://www.postgresqltutorial.com/
https://lab.demog.berkeley.edu/Docs/Refs/aw_pgsql_book.pdf
https://momjian.us/main/writings/pgsql/aw_pgsql_book/
以及PostgreSQL的官方文档.
进阶学习:
http://www.interdb.jp/pg/
案例、解决方案学习:
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
