06-17, 09:00–10:30 (Europe/London), Tower Suite 3
Are you writing SQL strings in your code? Have you only used ORMs and want to start getting more control over your SQL?
SQLAlchemy is the gold-standard for working with SQL in Python and this tutorial will get you comfortable with working in it so you can take advantage of its power. We will go through Core and ORM abstractions so you'll be comfortable navigating through the different layers and be able to fully use the power of Python when writing your SQL
SQLAlchemy has been the defacto SQL toolkit in Python for a very long time - providing great abstractions, a powerful ORM but built on a flexible Core.
In this tutorial, we will go through SQLAlchemy's Core and ORM layers, giving you an introduction to what they are capable of and showing off the many clever features available to us when we're able to write SQL in pure Python.
We'll discuss common pitfalls and tips I've learned from my many years of using SQLAlchemy and you'll walk away with a good understanding of what SQLAlchemy is capable of and able to implement them in your own codebases
Some knowledge of SQL is expected - if you know what a JOIN and a GROUPBY are, you're good to go!
If you want to code alongside, an installation of Docker or Postgres is helpful, although instructions are available if you want to avoid these extra dependencies
Previous knowledge expected
I'm the Head of the Python Enablement Team at Nordea Asset Manager, driving enablement and adoption of Python for our teams.
I've previously worked as a tech lead for ML and Analytics, Sales Analytics as well as a Business Analyst and Management Advisor.
I also organize the Pydata Copenhagen monthly meetup