YoVDO

Python and SQL: Better Together, Powered by DuckDB

Offered By: PyCon US via YouTube

Tags

DuckDB Courses Python Courses SQL Courses pandas Courses Data Processing Courses Data Management Courses DataFrames Courses Apache Arrow Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 - Python
Samuel 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