Intermediate SQL
by datacamp
Overview:
- How to filter and compare data
- How to use aggregate functions to summarize data
- How to sort and group data
- How to present data cleanly using tools such as rounding and aliasing
Chapter 1 : Selecting Data
| Section | Content |
|---|---|
| 1 | Querying a database |
| 2 | Query execution |
| 3 | SQL style |
Chapter 2 : Filtering Records
| Section | Content |
|---|---|
| 1 | Filtering numbers |
| 2 | Multiple criteria |
| 3 | Filtering text |
| 4 | NULL values |
Chapter 3 : Aggregate Functions
| Section | Content |
|---|---|
| 1 | Summarizing data |
| 2 | Summarizing subsets |
| 3 | Aliasing and arithmetic |
Chapter 4 : Sorting and Grouping
| Section | Content |
|---|---|
| 1 | Sorting results |
| 2 | Grouping data |
| 3 | Filtering grouped data |