#intermediate
Getting Started with PostgreSQL
PostgreSQL (often called “Postgres”) is the most popular open-source relational database — and for good reason. It’s reliable, feature-rich, standards-compliant, and handles everything from small side projects to massive production workloads. If you’re choosing a database for a new project and don’t have a specific reason to pick something else, PostgreSQL is the safe default. This tutorial gets you from installation to running queries in minutes. Installing PostgreSQL macOSLinuxWindows Using Homebrew: Read more →
May 18, 2026
AWS Lambda
AWS Lambda lets you run code without managing servers. You upload a function, define what triggers it (an HTTP request, a file upload, a schedule), and AWS handles everything else — provisioning, scaling, patching, and shutting down when idle. You only pay for the milliseconds your code actually runs. If you’ve been through the EC2 Basics tutorial, you know that EC2 gives you full virtual machines. Lambda is the opposite end of the spectrum: no servers to manage at all. Read more →
May 18, 2026
Classes and Object-Oriented Programming
Classes let you create your own data types that bundle data and behavior together. Instead of passing loose dictionaries around and writing separate functions to operate on them, you define a class that knows what data it holds and what operations make sense for that data. Your First Class class Dog: def __init__(self, name, breed, age): self.name = name self.breed = breed self.age = age def bark(self): return f"{self.name} says: Woof! Read more →
May 18, 2026
Docker Introduction
“It works on my machine” is the problem Docker solves. Docker packages your application with everything it needs — code, runtime, libraries, system tools — into a portable container that runs identically everywhere: your laptop, your colleague’s laptop, staging, production. What Docker Actually Is Docker is a platform for building and running containers. A container is a lightweight, isolated environment that shares the host OS kernel but has its own filesystem, processes, and network. Read more →
May 18, 2026
SQL Joins
In the SQL Basics tutorial, we worked with a single table at a time. But real databases almost always have multiple related tables — customers and orders, students and courses, products and categories. Joins are how you combine rows from two or more tables based on a related column. Understanding joins is one of the most important SQL skills you can have. They come up constantly in application development, data analysis, and technical interviews. Read more →
April 3, 2026
EC2 Basics
Amazon EC2 (Elastic Compute Cloud) is AWS’s core compute service. It lets you run virtual servers — called instances — in the cloud. Instead of buying and maintaining physical hardware, you can launch a server in minutes, use it for as long as you need, and shut it down when you’re done. If you’ve been through the AWS Getting Started guide, you already have an AWS account. In this tutorial, we’ll launch an EC2 instance, connect to it via SSH, run a simple web server, and then clean everything up so you don’t get charged. Read more →
April 3, 2026