Get in Touch
 Duration 7 hours

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

 

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (2)

Provisional Courses

Related Categories