Getting Started with SQLAlchemy
One of the biggest productivity boosts you can add to your data-driven application is to use a high-level framework to access your database. SQLAlchemy is the most flexible and highly popular ORM (Object Relational Mapper) in Python. Once you take this course, you'll be able to write efficient and reliable code whether you're working on a web application or other data driven application.
This course begins with an overview of ORMs and SQLAlchemy. Then we move on to the most commonly used feature of SQLAlchemy, the ORM. You'll learn how to map classes to the database and even generate the database from your in-memory models. Finally, we'll round out the course with a look at a lower-level layer of SQLAlchemy that provides greater flexibility than the ORM (at the cost of more work on your side).
After completing this course, you will be able to:
- Improve data access techniques
- Use SQLAlchemy to access the database
- Define an ORM and know when to use it
- Map classes to the database
- Generate the database from in-memory models
- Use the SQLAlchemy core layer