Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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 (5)
Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter
Ryan - Questronix Corporation
Course - PostgreSQL for Administrators - 3 Days
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
Course - PostgreSQL Essentials
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
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system