课程大纲
介绍
- PostgreSQL 特性和架构概述
- Python 编程基础知识
- Python Postgre 的优势SQL
开始
- 安装 PostgreSQL
- 安装 Python、Django 或 Flask
- 安装 psycopg2
- 连接到 PostgreSQL with Python
Python 和 SQL 操作
- SQL语言的基础知识
- 数据库架构和表
- 编写 Python 查询
- 创建表
- 插入数据
- 操作数据
- 使用 limit 子句
- 联接表
- 全文搜索
- 使用 SQLite
- Python 应用程序示例
高级 PostgreSQL with Python
- 表继承
- 嵌套事务
- 用户定义类型
- 视图, 有, 独特
- 使用日期和时间
- 多版本并发控制 (MVCC)
- 使用 matplotlib 的图表、图形和报告
管理与安全
- PostgreSQL 数据安全
- 使用白名单限制访问
- 实施复制
- 数据库迁移
- 备份和还原
- 监视查询
- 性能调优
- 防止 SQL 注入攻击
故障 排除
摘要和后续步骤
要求
- Postgre 使用经验SQL
- Python编程经验
观众
- 开发 人员
- 管理员
客户评论 (5)
示例/练习完全适合我们的领域
Luc - CS Group
课程 - Scaling Data Analysis with Python and Dask
机器翻译
培训师非常乐意回答我所做的所有问题
Caterina - Stamtech
课程 - Developing APIs with Python and FastAPI
机器翻译
It was a though course as we had to cover a lot in a short time frame. Our trainer knew a lot about the subject and delivered the content to address our requirements. It was lots of content to learn but our trainer was helpful and encouraging. He answered all our questions with good detail and we feel that we learned a lot. Exercises were well prepared and tasks were tailored accordingly to our needs. I enjoyed this course
Bozena Stansfield - New College Durham
课程 - Build REST APIs with Python and Flask
传授培训师的实践知识和经验。
Rumel Mateusz - Pojazdy Szynowe PESA Bydgoszcz SA
课程 - GUI Programming with Python and PyQt
机器翻译
As I was the only participant the training could be adapted to my needs.