SQL From Zero to Hero in 30 Days — Day 1 Introduction
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
SQL is one of the most sought-after skills in data science. If you quickly browse through the job postings in data science, you will notice it is almost always listed alongside Python.
SQL is a programming language used for managing data in relational databases. Considering a substantial amount of data is stored in relational databases, SQL is a must-have skill for data scientists.
A relational database consists of relational tables created under a schema. An SQL table contains labeled rows and columns and the tables are related to each other by means of shared columns.
When I first started learning SQL, I had the wrong impression that SQL was a language just to query relational databases. I thought I would only use it to retrieve data from tables.
