Home   Schulung > EDV > Programmierung > Python

SQLAlchemy is THE object relational mapper used in the Python world. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. This practical course will make sure you understand the concepts behind SQLAlchemy. We will focus on practical patterns of SQLAlchemy usage and see how its use can grow from very simple to more advanced.

Python - SQLAlchemy Course

Ziel
SQLAlchemy is THE object relational mapper used in the Python world. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. This practical course will make sure you understand the concepts behind SQLAlchemy. We will focus on practical patterns of SQLAlchemy usage and see how its use can grow from very simple to more advanced.
Schulungsinhalte


· Get to know SQLAlchemy
We will start with an overview of the terminology used in SQLAlchemy, such as drivers, connectors, engines, metadata, sessions, tables and mappers.

· Simple statements
An overview of how the basic SQL statements can be generated from SQLAlchemy and how SQLAlchemy can simplify our life when we need to write those statements.

· Simple ORM
Set up an object relational mapping and experiment with the life cycle an object goes through when it is mapped by SQLAlchemy to the database. This can be be done using plain SQLAlchemy or Declarative or Elixir.

· SQLAlchemy Philosophy
Next we need to understand a bit of the philosophy behind SQLAlchemy and to study its different usage patterns. Know what is possible with SQLAlchemy and where to look for in its documentation. This will help us when being faced with more advanced topics.

· Advanced statements
See how SQLAlchemy allows us to keep even advanced database usage reasonably simple and experience the true power of SQLAlchemy.

· ORM and relations
Experience how relations between mapped objects behave and look at the options both the database and SQLAlchemy offer.

· Advanced ORM
Experiment with non trivial mapping issues, such as inheritance, arbitrary selects and arbitrary relations. In this part we will also study the use of transactions in combination with the ORM. .
Zielgruppe
Programmers with basic Python knowledge or after taking other courses such as Python for Programmers.
Voraussetzungen
Basic knowledge of Python and object oriented programming is required. If you do not know Python it is strongly recommended to take Python for Programmers before this course.Basic knowledge of SQL is necessary.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrsqlalchm
Dauer1 Tag
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Garantierte Durchführung Garantierte Durchführung!