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
Testimonials (3)
Hands-on exercises related to content really helps to understand more about each topic. Also, style of start class with lecture and continue with hands-on exercise is good and helpful to relate with the lecture that presented earlier.
Nazeera Mohamad - Ministry of Science, Technology and Innovation
Course - Introduction to Data Science and AI using Python
Preparation of materials and code (with comments). Coherence of the teaching process and topic progression. Preparation of the instructor.
Piotr - ArcelorMittal
Course - Machine Learning with Python – 4 Days
Machine Translated
The trainer was very available to answer all te kind of question I did