Analyzing JSON-, CSV, and Parquet data using SQL in DuckDB

Courses

Learn to perform data transformations and statistical aggregations in SQL. Practice using SELECT statements with transformations, calculating full-table aggregations, computing groupwise statistics with GROUP BY, and combining data from multiple tables using JOIN operations.

Sessions

Writing and Reading Metadata with Serialized with JSON

Organizing complex metadata with JSON

SQL Queries over Data Files With DuckDB

Managing and manipulating data in database

Aggregating Data Using Statistical Functions in SQL

Simple aggregations on databases