Sql

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, ...

Needed Some SQL Ran into a minor hiccup while performing some exploratory data analysis. The type of my columns was wrong. This is the kind of thing I want fixed before Python, R, or Julia touch the dataset. This is the kind of thing that would be suited for SQL. I have used MySQL for a different task that involves frequent updating. DuckDB is more suited for static data analysis. That ended up driving the choice of DuckDB. The CLI outputs are excellent. There are integrations available for Python, R, and Julia. ...