SQL is an abbreviation for Structured Query Language. It was born in 1974 to handle data that is stored in a Relational Database Management System - RDBMS.
It is good to know SQL, because it is widely used in software development and data engineering. Furthermore it influenced al lot NoSql languages. So it is considered a basic skillset every information technology engineer needs.
As there is a lot of information to store in the brain, when it comes to learn or remember a specific topic, I thought drawing a sketchnote might help. This has the advantage that you have all the information one page and it helps learning and remembering facts about a topic.
As you can see, I did not use a pen for a long time. But even though the graphical quality is not high, I hope you can also use it to learn or freshen up your sql skills.
The sql sketchnote holds information about:
- When to use sql
- Entity relationship diagram
- Normalization
- Joins
- Aggregations
- Subqueries
- Core window functions
- Ranking window functions
- Advanced window functions
I hope you like it - Enjoy!
If the resolution here is too low - in case you really want to read it - you can find a higher resolution here.
If you don't like it, but still need some information, you can check these links:
Top comments (0)