Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
This conference talk from PyCon US explores how to translate SQL query design patterns into efficient Python functions, eliminating the overhead of database systems. Learn how familiar SQL concepts can be reimplemented in Python using generator expressions and list comprehensions. Discover techniques for recreating SELECT statements, GROUP BY and HAVING clauses without relying on database engines like SQLite3. The 32-minute presentation is aimed at those already comfortable with Python's functional programming features who want to maintain SQL's analytical clarity while leveraging Python's implementation advantages. Understand how to use SQL concepts for initial design before pivoting to more robust Python implementations.
