(click anywhere to close)
OPEN MENU
ALL POSTS IN...

SQL

SQL is the most used language for interacting with databases. It stands for Structured Query Language, and does exactly what it promises: allow you to write well-structured programs for your databases. With those databases you could start a blog, a web shop, an online game, a website that allows users to create accounts, and much more!

Prerequisites: A tiny bit of (server-side) programming knowledge could be useful.

[SQL] Data Types

When defining keys and constraints, and creating t...

[SQL] Operators & Conditions

Earlier in this course, you’ve seen me menti...

[SQL] Aliases & Variables

We’ve seen in all the previous chapters, tha...

[SQL] Aggregators

Now that we know how to create aliases for complex...

[SQL] Sorting

Let’s say you’ve crafted a nifty selec...

[SQL] Grouping

Now that we know how to select entries based on co...

[SQL] Filtering

Continuing in the spirit of last chapter, we will ...

[SQL] Joins I

All the queries and fancy keywords we’ve use...

[SQL] Joins II

Joins are so powerful and important, that they des...

[SQL] Searching

I don’t think I need to explain the importan...

CONTINUE LEARNING