Course Outline
Module I: psycopg Library
1. Configuring the connection to a PostgreSQL database
2. SQL fundamentals review
3. Executing database queries
4. Security – protection against SQL injection attacks
Module II: Pandas in the Context of Databases
1. Loading data from a database into a DataFrame
2. Exporting data from Pandas to PostgreSQL
3. Optimizing the transfer of large datasets
Module III: SQLAlchemy ORM
1. Configuring the connection using SQLAlchemy
2. Defining data models as Python classes
3. Object-relational mapping mechanisms
4. Adding records via class instances
5. Retrieving and displaying data from tables
6. Updating and deleting records
Requirements
Testimonials (2)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications