How-to guides
Practical articles for developers — workflows, tooling, and techniques you can use today. Each guide is organized with clear headings, context for why steps matter, and copy-paste commands where it helps.
SQL Basics for Developers: SELECT, JOINs, Aggregates, and Indexes
Databases & SQL Beginner 7 min read
Read and shape relational data with core SQL—filters, joins, GROUP BY, and why indexes matter for performance.
Learn SQL essentials: SELECT/WHERE, INNER vs LEFT JOIN, aggregates, basic indexes, and safe parameterized queries. Connects to databases in Docker Compose stacks.
Git Tutorial for Beginners: Clone, Commit, Branch, Merge, and Push
Getting started Beginner 7 min read
Learn the everyday Git workflow: track changes, branch safely, sync with a remote, and pair with SSH authentication.
Learn Git basics: clone, status, add, commit, branches, merge, pull vs fetch, and push. Includes .gitignore tips and links to SSH setup for GitHub and GitLab.
How to Install Python and Use venv on Windows, macOS, and Linux
Languages & runtimes Beginner 6 min read
Create isolated environments with python -m venv, activate them on each OS, and manage dependencies with pip.
Step-by-step: install Python 3, create and activate a venv on Windows, macOS, and Linux, use pip, and freeze dependencies. Troubleshoot PATH and permission issues.