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
Testimonials
interaction was encouraged,Very useful practical approaches.
Farhan - Molly Brooks, Fast Lane Consulting and Education Services Limited
PostgreSQL for Administrators - 2 Days Course
Lot's of excersises
Sebastian Kotulski, Santander
PostgreSQL for Administrators - 2 Days Course
1. Notes on the whiteboard 2. Labs were executed in a sharing mode
Evangelos Katsaros
PostgreSQL Administration and Development Course
The instructor explained everything we asked, he was very accurate, and he kept my interested.
Katerina Andreopoulou
PostgreSQL Administration and Development Course
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
PostgreSQL for Developers Course
The trainer scribbling on the pages to provide extra illustration, making the learning easier. It is unusual but effective.
Services Australia
PostgreSQL Essentials Course
The hands on practical parts of the training were engaging, I tended to lose a little interest if there was too much talking.
Bob Burt - Services Australia
PostgreSQL Essentials Course
I liked that we got hands on experience with exercises in the Virtual Desktop, rather than just purely listening to a presentation. The trainer was great - very understanding and helpful when one of us was lost.
Cruise Speck - Services Australia
PostgreSQL Essentials Course
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
PostgreSQL for Developers Course
The trainer was very knowledgeable in the subject, answered every question and kept the engagement of the participants. Some topics were explained in great depth, which I found really good.
Sopra Steria
PostgreSQL Advanced DBA Course
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
PostgreSQL Performance Tuning Course
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
PostgreSQL Advanced DBA Course
Michal is a knowledgeable and experienced trainer. It's good to have trainers who have industry experience. I also liked the hands-on exercises with remote VMs.
NIIT (USA) Inc.
PostgreSQL Advanced DBA Course
The pace was excellent. It seemed custom made for me ... loved it!