課程大綱： 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
加入高級會員獲得助教答疑
