Duration
21 hours (usually 3 days including breaks)
Requirements
- Experience with PostgreSQL
- Python programming experience
Audience
- Developers
- Administrators
Overview
PostgreSQL (also known as Postgres) is an open source relational database management system or RDBMS built for handling large data workloads. Python is a dynamic and flexible programming language that supports various databases, such as MySQL, Oracle, PostgreSQL, etc.
This instructor-led, live training (online or onsite) is aimed at developers and administrators who wish to use PostgreSQL with Python to build secure, reliable, and stable applications at scale.
By the end of this training, participants will be able to:
- Install, configure, and connect PostgreSQL with Python.
- Get a refresher on Python programming fundamentals.
- Understand the benefits of using PostgreSQL with Python.
- Learn how to perform basic SQL operations with Python.
- Learn how to use the advanced PostgreSQL features with Python.
- Implement data safety, security, monitoring, and optimization techniques.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
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