Loading...
Please wait a moment
Founded by passionate advocates of learning and innovation, Learni set out to make professional training accessible to everyone, everywhere in the world. Our team works in the largest cities such as Paris, Lyon, Marseille, and internationally, to support talents and organizations in their skills development.
10 spots per session maximum — 10 already taken
Which format do you prefer?
30 free minutes with a training advisor — no commitment.
Loading available slots...
Professional Training training in Memphis in October 2026 with Learni. Certified, expert trainers, eligible for employer funding. Free quote.
Discover why advanced Excel formulas training is crucial for business professionals in March 2026. Explore key formulas, trends, and top training programs to boost your data skills and career.
Cybersecurity training in Sheffield in November 2026 with Learni. Certified, expert trainers, eligible for employer funding. Free quote.
Discover the best strategies, courses, certifications, and resources to master Manufacturing Execution Systems (MES) by March 2026. Perfect for manufacturing professionals aiming to thrive in Industry 4.0.
The Training SQLAlchemy - Mastering the Python ORM for Databases training is delivered in-person or remotely (blended-learning, e-learning, virtual classroom, remote in-person). At Learni, a Qualiopi-certified training organization, each program is designed to maximize skills acquisition, regardless of the training mode chosen.
The trainer alternates between demonstrative, interrogative, and active methods (through practical exercises and/or real-world scenarios). This pedagogical approach ensures concrete and directly applicable learning in the workplace.
To ensure the quality of the Training SQLAlchemy - Mastering the Python ORM for Databases training, Learni provides the following teaching resources:
For in-house training at a location external to Learni, the client ensures and commits to having all necessary teaching materials (IT equipment, internet connection...) for the proper conduct of the training action in accordance with the prerequisites indicated in the communicated training program.
The assessment of skills acquired during the Training SQLAlchemy - Mastering the Python ORM for Databases training is carried out through:
Learni is committed to the accessibility of its professional training programs. All our training programs are accessible to people with disabilities. Our teams are available to adapt teaching methods to your specific needs. Do not hesitate to contact us for any accommodation request.
Learni training programs are available for inter-company and intra-company settings, both in-person and remote. Registration is possible up to 48 business hours before the start of training. Our programs are eligible for OPCO, Pôle emploi, and FNE-Formation funding. Contact us to discuss your training project and funding possibilities.
Installation and configuration of SQLAlchemy with Alembic. Definition of basic ORM models. Management of data types and constraints. Table creation via Python code. Practical exercises on concrete business cases. Setting up the red thread project: database for a business app. Connection to PostgreSQL/MySQL. Unit tests on models. Hands-on practice with simple inserts and selects. Introduction to sessions and query objects.
Exploration of one-to-many and many-to-many relationships. Joins and lazy/eager loading. Filtered queries, aggregations, and ORM subqueries. Transaction management and rollback. Professional exercises on real datasets. Progress on the red thread project: implementation of complex relationships. Query optimization for performance. Use of Hybrid Properties. Real-world cases: e-commerce and HR management. Debugging common production errors.
Migration management with Alembic in CI/CD environments. Indexing and performance tuning. Integration with Flask/Django. JSON serialization and REST APIs. Exercises on horizontal scaling. Finalization of the red thread project: fully deployable app. Integration tests and monitoring. Best practices for maintainable team code. Deployment on cloud (Heroku/AWS). Q&A on real enterprise cases.
Target audience
Backend Python developers, data engineers, and software engineers seeking to upskill on ORM
Prerequisites
Mastery of Python OOP, basic SQL, and relational database management
Loading...
Please wait a moment





























