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

7. Updating and deleting records

 7 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (5)

Provisional Courses

Related Categories