Databases in Python – SQLAlchemy Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedDatabases in Python – SQLAlchemy Training
The Databases in Python – SQLAlchemy training is a practical course that allows participants to learn both the basics of working with relational databases and advanced data management techniques in Python using SQLAlchemy. The course covers both SQLAlchemy Core and ORM, showing how to create, modify, and read data in relational databases, manage relationships between tables, and use transactions and sessions. Participants will learn how to build secure and efficient Python applications that rely on databases.
Who is this training for?
Python developers who want to gain practical skills in working with databases-
Data analysts who want to integrate Python with relational databases
-
People developing web applications or backend systems with Python
What You Will Learn
- How to create and configure databases in Python using SQLAlchemy
- How to define tables and schemas in SQLAlchemy Core and ORM
- How to insert, update, delete, and read data in databases
- How to create and manage relationships between tables (One-to-One, One-to-Many, Many-to-Many)
- How to use sessions and transactions to manage database changes
- How to handle exceptions and perform rollbacks in case of errors
- How to distinguish between SQLAlchemy Core and ORM and choose the right approach depending on the application’s needs
Training Program
-
Module 1: Introduction to Databases and SQLAlchemy
- What relational databases are
- Basics of SQL language
- SELECT
- INSERT
- UPDATE
- DELETE
- The role of ORM in Python applications
- Installation and configuration of SQLAlchemy
-
Module 2: SQLAlchemy Architecture
- SQLAlchemy Core vs ORM
- Key differences
- Use cases
- SQLAlchemy Core components
- Engine
- MetaData
- Table
- Sessions and the Unit of Work pattern in ORM
-
Module 3: Working with Databases in SQLAlchemy Core
- Creating a database connection
- Defining tables using
TableandColumn - Creating and modifying database schemas
- Inserting data
- Updating data
- Deleting data
- SELECT queries and data filtering
-
Module 4: Working with Databases in ORM Mode
- Defining model classes and mapping them to tables
- Relationships
- One-to-One
- One-to-Many
- Many-to-Many
- CRUD operations in ORM
- Create
- Read
- Update
- Delete
- Transactions and session management
- Exception handling and rollbacks
