         PostgreSQL with Python培訓

Introduction

Overview of PostgreSQL features and architecture
Python programming fundamentals
Advantages of Python PostgreSQL
Getting Started

Installing PostgreSQL
Installing Python, Django or Flask
Installing psycopg2
Connecting to PostgreSQL with Python
Python and SQL Operations

The basics of SQL language
Database schema and tables
Writing a Python query
Creating tables
Inserting data
Manipulating data
Using limit clause
Joining tables
Full-text search
Working with SQLite
Examples of Python applications
Advanced PostgreSQL with Python

Table inheritance
Nested transactions
User-defined types
VIEWS, HAVING, DISTINCT
Working with dates and times
Multi-version concurrency control (MVCC)
Charts, graphs, and reports using matplotlib
Administration and Security

PostgreSQL data safety
Restricting access using whitelist
Implementing replication
Database migration
Backup and restore
Monitoring queries
Performance tuning
Preventing SQL injection attacks
Troubleshooting

Summary and Next Steps