Course Outline
Module I: The psycopg Library
1. Configuring the connection to the 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 the 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. The Object-Relational Mapping mechanism
4. Adding records via 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
