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 (4)
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
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
I really enjoyed the training. I found all modules to be applicable to problems that I am trying to solve at work. The integration of the training with jupyter notebooks was really impressive.
Mark Firmin - Environment and Climate Change Canada
Course - Python for Geographic Information System (GIS)
Real world knowledge from someone in the industry