YoVDO

DuckDB - High-Performance SQL Queries on Pandas Dataframe - Python

Offered By: Samuel Chan via YouTube

Tags

Data Science Courses Python Courses pandas Courses Relational Databases Courses DuckDB Courses

Course Description

Overview

Explore the powerful capabilities of DuckDB for high-performance SQL queries on pandas dataframes in Python through this comprehensive 44-minute video tutorial. Dive into the world of "SQLite for Analytics" as the instructor explains why DuckDB is designed to be user-friendly for data scientists. Learn about database interfaces with applications, take a quick tour of the DuckDB shell, and discover how to utilize the DuckDB Python package with pandas. Master the art of executing multiline SQL queries on pandas dataframes and explore various tools for working with DuckDB. Gain valuable insights into related topics such as converting CSV to SQLite, hands-on SQL introduction, running SQLite in VSCode, and building dashboards with PyScript and Altair.

Syllabus

What is DuckDB? Intro, Why DuckDB? Overview
Mental Models: How database interface with applications
DuckDB intro / quick tour to DuckDB shell
DuckDB python package usage w/ pandas
Multiline SQL query on a pandas dataframe!
Tools for working with DuckDB


Taught by

Samuel Chan

Related Courses

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
Introduction to Ibis: Blazing Fast Analytics with DuckDB, Polars, Snowflake, and More - Tutorial
PyCon US via YouTube