Get in Touch

Course Outline

Module I: psycopg Library
1. Configuring the connection to the PostgreSQL database
2. Review of SQL fundamentals
3. Executing database queries
4. Security - protection against SQL injection attacks

Module II: Pandas in the Context of Databases
1. Loading data from the database into a DataFrame
2. Exporting data from Pandas to PostgreSQL
3. Optimizing large dataset transfers

Module III: SQLAlchemy ORM
1. Configuring connections using SQLAlchemy
2. Defining data models as Python classes
3. The object-relational mapping mechanism
4. Adding records via class instances
5. Retrieving and displaying data from tables
6. Updating and deleting records

Requirements

 

 7 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (2)

Provisional Courses

Related Categories