PostgreSQL从入门到精通：全面学习指南与职业发展路径
PostgreSQL作为一款开源免费的关系型数据库管理系统，以其强大功能、稳定性能和高度可扩展性赢得了全球开发者的青睐。在国内，许多数据库技术都是在PostgreSQL基础上开发的，掌握这项技能能为您的职业发展打开新的大门。
PostgreSQL, as an open-source and free relational database management system, has gained worldwide popularity among developers due to its powerful features, stable performance, and high scalability. In China, many database technologies are developed based on PostgreSQL, making this skill a valuable asset for career advancement.
为什么学习PostgreSQL？
Why Learn PostgreSQL?
PostgreSQL数据库技术在国内企业应用广泛，掌握这项技能可以：
- 在国产数据库相关企业获得优质工作机会
- 提升数据库管理能力
- 获得工信部认证的专业资质
PostgreSQL database technology is widely used in domestic enterprises. Mastering this skill can:
- Secure quality job opportunities in domestic database-related companies
- Enhance database management capabilities
- Obtain professional certification from MIIT
学习路径与课程内容
Learning Path and Course Content
CUUG陈卫星老师与PostgreSQL中文社区德哥合作，提供系统的学习课程：
Teacher Chen Weixing from CUUG, in collaboration with Brother De from PostgreSQL Chinese Community, offers systematic learning courses:
- PG第1讲-PG简介
- PG第2讲+第3讲-安装与建库
- PG第4讲-实例结构
- PG第5讲-数据库结构
- PG第6讲-用户与角色管理
- PG第7讲-用户与模式的关系
- PG第8讲-对象权限管理
- PG第9讲-实例连接访问控制
- PG第10讲-数据库管理
- PG第11讲-控制文件管理
- PG第12讲-wal文件管理
- PG第13讲-全页写
- PG第14讲-检查点管理
- PG第15讲-数据文件和块管理
- Lecture 1: Introduction
- Lecture 2+3: Installation and Database Creation
- Lecture 4: Instance Structure
- Lecture 5: Database Structure
- Lecture 6: User and Role Management
- Lecture 7: User-Schema Relationship
- Lecture 8: Object Permission Management
- Lecture 9: Instance Connection Access Control
- Lecture 10: Database Management
- Lecture 11: Control File Management
- Lecture 12: WAL File Management
- Lecture 13: Full Page Writes
- Lecture 14: Checkpoint Management
- Lecture 15: Data File and Block Management
