DEV Community

Cover image for Structured Query Language

Posted on • Updated on

Structured Query Language

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!

Sketchnote SQL

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:

wikipedia | syleguide | cheatsheet

Top comments (0)