From Rows to Insights: Aggregate Functions
A database that can only hand back individual rows is like a calculator that only displays the numbers you typed in. The real power of SQL appears whe...
Read article →Git Branches: Your Code's Parallel Universes
A branch is the feature that made Git famous. It lets you split off a private line of development, experiment freely without endangering your working ...
ContainersFrom Blueprint to Running Process: Inside Container Images
You know what a container is and why it exists. Now let's open the hood. This article walks through what a container image really is — the Dockerfile ...
SQLSQL JOINs: Combining Data from Multiple Tables
Relational databases deliberately scatter information across many tables — a single customer here, their orders there, their addresses somewhere else....
WebHow Modern Search Engines Actually Work
Type a question into Google and press Enter — you get an answer in less than a second. Behind that little search box is a huge system: it visits hundr...
GitYour First Local Repository: Getting Git Running on Your Machine
You have read about what Git is and why it exists. Now it is time to open a terminal and actually use it. This article walks you through every step — ...
SQLWhat Type Is That Column?
Every column in a database is, in a sense, a labelled box. The label tells the engine what may be stored inside, how much room to reserve, and how the...
SQLThe SELECT Statement: Reading Data from a Relational Database
If you ever plan to ask a question of a database, you will almost certainly begin with the word SELECT. It is the verb of SQL — the command that retri...
WebThe Window to the Web: How Browsers Became the Most Important Software You Never Think About
Every day, billions of people open a small icon on their phone, laptop or television and launch one of the most sophisticated pieces of consumer softw...