English | 中文

SQL Handbook

A comprehensive Quarto website providing parallel tutorials for common data manipulation tasks using SQL, R, and Python. This resource helps you understand equivalent operations across these three popular data analysis tools.

Handbook:https://jcwinning.github.io/Into_sql/

Features

• Language Comparison: Side-by-side examples showing how to achieve the same data manipulation tasks
• Comprehensive Coverage: From basic exploration to advanced operations like joins and pivoting
• Interactive Examples: Live code execution with Quarto
• Bilingual Support: Available in both English and Chinese
• Modern Libraries: Uses current best practices with DuckDB, polars, pandas, and dplyr

Contents

• Getting Started with Data Exploration
• Basic Queries (Select, Filter, Order)
• Data Transformation (Create columns, Group by)
• Table Operations (Create, Update, Delete, Drop)
• Advanced Operations (Joins, Union, Pivot/Unpivot)
• Beautiful Table Display

Built With

• Quarto for publishing
• DuckDB for SQL examples
• R with tidyverse for data manipulation
• Python with pandas and polars
• Babelquarto for multilingual support