Python and SQL: Better Together, Powered by DuckDB
Offered By: PyCon US via YouTube
Course Description
Overview
Explore the powerful combination of Python and SQL through DuckDB in this 39-minute PyCon US talk. Discover how DuckDB, a novel database management system, bridges the gap between traditional data management systems and Python-based data wrangling tools. Learn about DuckDB's seamless integration with the Python ecosystem, its ability to read and write popular dataframe libraries, and its support for various file formats and cloud object storage. Understand how DuckDB offers a user-friendly SQL dialect, Pythonic dataframe syntax options, and compatibility with other database systems. Gain insights into DuckDB's performance advantages, ease of installation, and ability to handle larger-than-RAM datasets. Compare DuckDB with Python dataframe libraries and explore practical examples of combining DuckDB and dataframes for efficient data processing.
Syllabus
Talks - Alex Monahan, Gabor Szarnyas: Python and SQL: Better Together, Powered by DuckDB
Taught by
PyCon US
Related Courses
DuckDB - High-Performance SQL Queries on Pandas Dataframe - PythonSamuel Chan via YouTube New Feature - What the Fibers Extension Can Do for You
International PHP Conference via YouTube Getting Started with PHP-FFI - Introduction to Foreign Function Interface
International PHP Conference via YouTube DuckDB - Bringing Analytical SQL Directly to Your Python Shell
EuroPython Conference via YouTube OLAP on Cassandra Data with Arrow, Flight SQL, ADBC, and DuckDB
Linux Foundation via YouTube