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
I genuinely enjoyed the trainer Subject Knowledge.
Julian Pirau
I enjoyed learning how to maintain the database, and how is the orgenazition of the data.
Jiang Chang
I liked everything he taught.
Emily Zhou
Very in depth knowledge on the subject matter. No “I'll have to look into that and get back to you, just new it all”.
David Marshall
I liked the thorough knowledge of the material and easily answered questions and could compare PostgreSQL to other database vendors.
YAZAKI SERVICE S DE RL DE CV
It was excellent. Great information and knowledgeable trainer. Great hands-on learning. Really got a lot out of it!.
- University of Victoria
*very clear* great use of blackboard in combination with PP slides.
- University of Victoria
There was a good amount of practical exercises which helped cement the learning and kept us engaged throughout.
Samuel Reeve - Capita Business Services Ltd
practice
- Jeppesen Poland
Practical experience of trainer
- Jeppesen Poland
everything
Artur Kruszlinski - Amazon Development Center Poland Sp. z o.o.
trainer's knowledge
steve guan - The Walt Disney Company
Very hands on
rebecca schulte - The Walt Disney Company
attention to each student's work!
- The Walt Disney Company
Very thorough, the VMs we used for the exercises were great.
- The Walt Disney Company
Practical examples with hands on
Amol Ghalke - Donyati LLC
Trainer explained everything in detail. i.e., from basics
Priyanka Devaraj - Amazon Development Center Poland Sp. z o.o.
exercise and that the teacher explains everything personally if you have any questions
Olga Ogorelkova - Amazon Development Center Poland Sp. z o.o.
trainer
Julia Malicka - Amazon Development Center Poland Sp. z o.o.
Examples were useful, everything made sense until %75 of the training
- Amazon Development Center Poland Sp. z o.o.
Patient for very basic knowledge of audience :)
Dorota Los - Amazon Development Center Poland Sp. z o.o.
I liked the attitude of the trainer I felt very comfortable asking questions and I knew the answers would be understandable for me.
- Amazon Development Center Poland Sp. z o.o.
The exercises and that the trainers was very responsive and was listening to us actively. He was also very patient with us. THANK YOU SO MUCH :)
Martyna Szewczuk - Amazon Development Center Poland Sp. z o.o.
useful knowledge
Ewa Napieralska - Amazon Development Center Poland Sp. z o.o.
The fact that we had a chance to hear about the difference between many databases types.
Marta Melloch - Amazon Development Center Poland Sp. z o.o.
Training from the basics, which I needed. I hope that now it will be easier for me to write the queries and understand more advanced ones. Maybe sometimes too slow, but on the other hand it was large group so I guess it is hard to adjust the training pace for everybody as the knowledge was different (some of the people were more advanced).
- Amazon Development Center Poland Sp. z o.o.
Almost one to one training and Michal had a lot of experience on the subject matter.
- CACI LTD
The diversity and very good explanation
Michael Nybråten - Politiets IKT-tjenester
The diversity and very good explanation
Michael Nybråten - Politiets IKT-tjenester
Lot of hands on.
Harald Liverud - Politiets IKT-tjenester
Patience, excellent knowledge with regards to answering questions. I also liked the combination of theory/lectures and practical examples.
Politiets IKT-tjenester
The openness of the instructor to take questions at any point.
Industry Canada
Show good examples & hand on. I would attend another training session by this trainer/instructor provided my employer approving funding for me.
Industry Canada
knowledge of the instructor course agenda
Kendra Roscoe - Industry Canada
great knowledge from the presenter
ANIXE Polska sp. z o.o.
Detailed knowledge and customer approach
Wojciech Polak - ANIXE Polska sp. z o.o.
The exercises.
ANIXE Polska sp. z o.o.
The in depth explaination of mechanisms working inside of psql instance and humour.
Łukasz Biel - ANIXE Polska sp. z o.o.
deep explanation about mechanisms how actually postgres is working underneath, experiments on database
Paweł Rynowiecki - ANIXE Polska sp. z o.o.
The openness, the way of the presentation
Marcin Szewczyk - ANIXE Polska sp. z o.o.
new knowledges that can be apply in our system
Laurence Bangsal - PayMaya Philippines, Inc.
the additional and extensive postgres knowledge we attained
PayMaya Philippines, Inc.
the learnings, because of the exercises given per topic it help us to apply and understand more the concepts.
PayMaya Philippines, Inc.
Michal did a great job at covering the material and explaining anything I had questions on.
Schonfeld Strategic Advisors LLC
The informality, relaxed and flexible approach. The content and pace was just about right for me to follow and understand
Lee Taylor
The training being interactive.
John Groover
Michol did a really good job! he was engaging. He kept up with the pace of the class instead of the class needing to keep up with the instructor. he assisted and kept it at a level where everyone could understand even from various knowledge backgrounds
patrice lester
Basically all of it. The trainer has done a great job on his delivery of the course material. He came ready to teach and was able to answer all questions with clarity. Additionally, the in-class exercises furthered our understanding of PostgreSQL architecture, features, and commands.
Robert Holtz
hands on class.
Basically all of it. The trainer has done a great job on his delivery of the course material. He came ready to teach and was able to answer all questions with clarity. Additionally, the in-class exercises furthered our understanding of PostgreSQL architecture, features, and commands.