-
Course
- Core Tech
Python: Database Management with SQLAlchemy
Learn to use SQLAlchemy for efficient database interactions. This course will teach you to build, query, and manage databases with ORM and Core techniques in Python applications.
What you'll learn
Managing databases efficiently can be challenging, especially as applications scale and evolve. In this course, Python: Database Management with SQLAlchemy, you’ll learn how to leverage SQLAlchemy for smooth database interactions in Python applications.
First, you’ll explore how to establish database connections and understand the foundational concepts of SQLAlchemy's ORM and Core components. Next, you’ll learn how to manage database schemas and even how to run database migrations using Alembic, ensuring your application remains adaptable to future needs. Finally, you’ll discover how to perform CRUD operations to create, query, and manipulate data effectively using both Core and ORM approaches.
When you’re finished with this course, you’ll have the skills and knowledge of SQLAlchemy needed to efficiently manage databases in Python and streamline workflows in real-world applications.
Table of contents
About the author
Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. As SGBD evolve into more complex solutions, he tries to make sure that people understand the fundamentals and implement their databases wisely.
More Courses by Rudi