- Experience with PostgreSQL
- Python programming experience
Audience
- Developers
- Administrators
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.
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
United Arab Emirates - PostgreSQL with Python
Qatar - PostgreSQL with Python
Egypt - PostgreSQL with Python
Saudi Arabia - PostgreSQL with Python
South Africa - PostgreSQL with Python
Brasil - PostgreSQL with Python
Canada - PostgreSQL with Python
Österreich - PostgreSQL with Python
Schweiz - PostgreSQL with Python
Deutschland - PostgreSQL with Python
Czech Republic - PostgreSQL with Python
Denmark - PostgreSQL with Python
Estonia - PostgreSQL with Python
Finland - PostgreSQL with Python
Greece - PostgreSQL with Python
Magyarország - PostgreSQL with Python
Ireland - PostgreSQL with Python
Luxembourg - PostgreSQL with Python
Latvia - PostgreSQL with Python
España - PostgreSQL with Python
Italia - PostgreSQL with Python
Lithuania - PostgreSQL with Python
Nederland - PostgreSQL with Python
Norway - PostgreSQL with Python
Portugal - PostgreSQL with Python
România - PostgreSQL with Python
Sverige - PostgreSQL with Python
Türkiye - PostgreSQL with Python
Malta - PostgreSQL with Python
Belgique - PostgreSQL with Python
France - PostgreSQL with Python
Australia - PostgreSQL with Python
Malaysia - PostgreSQL with Python
New Zealand - PostgreSQL with Python
Philippines - PostgreSQL with Python
Singapore - PostgreSQL with Python
Thailand - PostgreSQL with Python
Vietnam - PostgreSQL with Python
India - PostgreSQL with Python
Argentina - PostgreSQL with Python
Chile - PostgreSQL with Python
Costa Rica - PostgreSQL with Python
Ecuador - PostgreSQL with Python
Guatemala - PostgreSQL with Python
Colombia - PostgreSQL with Python
México - PostgreSQL with Python
Panama - PostgreSQL with Python
Uruguay - PostgreSQL with Python
Venezuela - PostgreSQL with Python
Polska - PostgreSQL with Python
United Kingdom - PostgreSQL with Python
South Korea - PostgreSQL with Python
Pakistan - PostgreSQL with Python
Sri Lanka - PostgreSQL with Python
Bulgaria - PostgreSQL with Python
Bolivia - PostgreSQL with Python
Indonesia - PostgreSQL with Python
Kazakhstan - PostgreSQL with Python
Moldova - PostgreSQL with Python
Morocco - PostgreSQL with Python
Tunisia - PostgreSQL with Python
Kuwait - PostgreSQL with Python
Slovakia - PostgreSQL with Python
Kenya - PostgreSQL with Python
Nigeria - PostgreSQL with Python
Botswana - PostgreSQL with Python
Slovenia - PostgreSQL with Python
Croatia - PostgreSQL with Python
Serbia - PostgreSQL with Python
Bhutan - PostgreSQL with Python