- Basic queries - selecting data from a table and performing basic calculations
- Filtering - selecting only the data that matches a set of conditions
- Sorting - ordering results
- Aggregation - grouping the output of queries and performing calculations within groups
- Joins - combing data from multiple tables
- Basic database design - how and why to split data into multiple tables