Security

Databases 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.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 Python developers who want to gain practical skills in working with databases
2 Data analysts who want to integrate Python with relational databases
3 People developing web applications or backend systems with Python
Outcomes after the program

Application and infrastructure security — a workshop for technical teams.

✓

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

Program · 4 modules

What we actually do

M01
Module 1: Introduction to Databases and SQLAlchemy
  • · What relational databases are
  • · SELECT
  • · INSERT
  • · UPDATE
  • · DELETE
  • · The role of ORM in Python applications
  • · Installation and configuration of SQLAlchemy
M02
Module 2: SQLAlchemy Architecture
  • · Key differences
  • · Use cases
  • · Engine
  • · MetaData
  • · Table
  • · Sessions and the Unit of Work pattern in ORM
M03
Module 3: Working with Databases in SQLAlchemy Core
  • · Creating a database connection
  • · Creating and modifying database schemas
  • · Inserting data
  • · Updating data
  • · Deleting data
  • · SELECT queries and data filtering
M04
Module 4: Working with Databases in ORM Mode
  • · Defining model classes and mapping them to tables
  • · One-to-One
  • · One-to-Many
  • · Many-to-Many
  • · Create
  • · Read
  • · Update
  • · Delete
  • · Transactions and session management
  • · Exception handling and rollbacks
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
Security

AWS Cloud Security Training

Application and infrastructure security — a workshop for technical teams.

Security →
Security

Azure Cloud Security Training

Application and infrastructure security — a workshop for technical teams.

Security →
Security

Container Security Management Training

Application and infrastructure security — a workshop for technical teams.

Security →