Results for "databases"
5 results found
SQL Basics: The Queries Every Beginner Should Know
Ten queries that cover most of what you'll use day to day, with runnable examples
Ten SQL queries that cover most day-to-day database work, with runnable examples — SELECT, filtering, joins, aggregation, and the mistakes that trip up beginners.
How Database Indexes Work — Why the Same Query Can Take 2ms or 8 Seconds
The phone book analogy that actually explains it, and how to find the problem with EXPLAIN
The same query on the same table can take milliseconds or seconds depending entirely on whether the database has an index to use. Here's what an index does, and when adding one hurts more than it helps.
Docker for Complete Beginners: What It Solves and How to Get Started
From "works on my machine" to your first container, without the orchestration jargon
Docker packages an application with everything it needs so it runs identically anywhere. Here's what a container is, your first real commands, and where beginners get confused.
Notion vs Google Keep vs Obsidian: Which Note-Taking App Should You Actually Use
Three genuinely different tools solving different problems — not three versions of the same thing
These three aren't competing for the same job. A practical comparison of what each one is actually built for, so you can pick based on your use case instead of trying every app for a week each.
How Your Phone Knows Your Location Even With GPS Off
GPS is just one of at least four separate location systems running on your phone, and turning it off disables only one
Turning off GPS doesn't turn off location tracking — WiFi networks, cell towers, and Bluetooth beacons can pinpoint you almost as accurately.