SQL From Zero to Hero in 30 Days — Day 2 The Select
Learn, practice, master.
The links below will be updated as we progress into the series:
- Day 1: Introduction
- Day 2: The Select
- Day 3: Filtering
- Day 4: The Group by
- Day 5: Expanding the Group by
- Day 6: Working With Text
- Day 7: Working With Text 2
- Day 8: Date Manipulation
We made an introduction to SQL and relational databases in the first article of this 30-day-series.
The next step is the backbone of SQL queries: The select statement. In my not-so-long data science journey, “select” might be the most frequent word I typed.
The select statement serves as a gate to SQL tables and allows for retrieving data. It is quite flexible so we can write queries in a way that only the necessary information is retrieved from the database.
It is possible to use aggregation functions along with the select statement so we can also perform quick data analysis operations.
As I have mentioned in the introduction, this series will be heavier on the practical side and each article will contain several examples.
