Selecting Data


Sorting and Removing Duplicates


Filtering


Figure 1

SQL Filtering in Action

Calculating New Values


Missing Data


Aggregation


Figure 1

SQL Aggregation

Combining Data


Figure 1

Survey Database Structure

Data Hygiene


Creating and Modifying Data


Programming with Databases - Python


Programming with Databases - R


Figure 1

relevant XKCD