Course Outline

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

Requirements

  • Experience with PostgreSQL
  • Python programming experience

Audience

  • Developers
  • Administrators
  21 Hours
 

Testimonials (4)

Related Courses

Related Categories