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 (5)
The fact of having more practical exercises using more similar data to what we use in our projects (satellite images in raster format)
Matthieu - CS Group
Course - Scaling Data Analysis with Python and Dask
I thought the trainer was very knowledgeable and answered questions with confidence to clarify understanding.
Jenna - TCMT
Course - Machine Learning with Python – 2 Days
Very good preparation and expertise of a trainer, perfect communication in English. The course was practical (exercises + sharing examples of use cases)
Monika - Procter & Gamble Polska Sp. z o.o.
Course - Developing APIs with Python and FastAPI
The explaination
Wei Yang Teo - Ministry of Defence, Singapore
Course - Machine Learning with Python – 4 Days
Trainer develops training based on participant's pace