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

 7 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (4)

Provisional Courses

Related Categories