Course Outline
Module I: psycopg Library
1. Configuring the connection to PostgreSQL
2. Review of SQL fundamentals
3. Executing queries to the database
4. Security – protection against SQL injection attacks
Module II: Pandas in the Context of Databases
1. Loading data from the database into DataFrame
2. Exporting data from Pandas to PostgreSQL
3. Optimizing the transfer of large datasets
Module III: ORM SQLAlchemy
1. Configuring the connection using SQLAlchemy
2. Defining data models as Python classes
3. Object-relational mapping mechanism
4. Adding records through class instances
5. Retrieving and displaying data from tables
6. Updating and deleting records
Testimonials (3)
Practical Exercises
Agnieszka Ryzowicz
Course - QGIS for Geographic Information System
Machine Translated
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
Entire training. Trainer preparation, communication style, prepared exercises. Everything is top-notch.
Michal - AXAXL
Course - Testable Requirements - How to Write Good Acceptance Criteria?
Machine Translated