Basic SQL Tutorial
This tutorial focuses on SQL usage for data analysis (rather than transaction processing). DuckDB is the engine primarily used, so some commands might not work with SQLite and vice versa. Commands largely drawn from https://www.dbvis.com/wp-content/uploads/2024/04/SQL-Cheat-Sheet.pdf Datasets Palmer Penguins, Chinook, Elevation of Indian Cities. The raw datasets are located in ~/Datasets/Raw. Set 1: Loading and Exporting Loading Data cd to the Raw datasets folder. run duckdb chinook.sqlite. this opens a duckdb command line with chinook loaded. run describe; or show; to see the tables and data types. Alternatively, ...