Boot.dev Blog
Python Break vs Continue: What's the Difference?
by Lane Wagner - Boot.dev co-founder and backend engineer
Sometimes, while looping through a sequence, you may find items that you want to skip. Python provides a way to do this: the continue statement. But what if you want to exit the loop entirely? That's where the break statement comes in.
Python Bitwise AND and OR Operators
by Lane Wagner - Boot.dev co-founder and backend engineer
Bitwise operators are similar to logical operators, but instead of operating on boolean values, they apply the same logic to all the bits in a value by column. The two operators covered here are & (AND) and | (OR).
Python Default Parameters: How They Work
by Lane Wagner - Boot.dev co-founder and backend engineer
In Python you can specify a default value for a function parameter. It's useful when a function has parameters that are "optional." You can specify a default value in case the caller doesn't provide one.
How to Return Multiple Values in Python
by Lane Wagner - Boot.dev co-founder and backend engineer
A Python function can return more than one value by separating them with commas.
What Does git push -u origin main Do?
by ThePrimeagen - Ex-Netflix engineer, NeoVim ricer, and Git rebaser
The git push -u origin main command pushes your local main branch to the remote named origin and sets origin/main as its upstream. The push sends commits now; the -u saves the relationship for later.
Git Push vs Pull: What's the Difference?
by ThePrimeagen - Ex-Netflix engineer, NeoVim ricer, and Git rebaser
git push sends your local commits to a remote repository. git pull brings remote commits into your current local branch. They move Git history in opposite directions, but pull also integrates what it downloads, which is where the comparison gets interesting.
Git Fast-Forward Merge: How It Works
by ThePrimeagen - Ex-Netflix engineer, NeoVim ricer, and Git rebaser
The simplest type of merge is a fast-forward merge. Git moves the base branch's pointer forward instead of creating a merge commit.
What Does git remote -v Do?
by ThePrimeagen - Ex-Netflix engineer, NeoVim ricer, and Git rebaser
The git remote -v command lists the remote repositories connected to your local Git repository. The -v means "verbose": it includes each remote's URL and shows whether Git uses it for fetching or pushing.
Python / vs //: Floor Division Explained
by Lane Wagner - Boot.dev co-founder and backend engineer
Python has two division operators: / performs regular division, while // performs floor division.
How Hard Is It to Learn to Code? A Realistic Guide and What to Expect in 2026
by Maya Chen - Computer science and programming educator at Boot.dev
How hard is it to learn to code? Learn what makes coding challenging, how long it takes, which languages are easiest, and how to make the process easier.
How to Learn to Code in 2026: A Step-by-Step Guide
by Lane Wagner - Boot.dev co-founder and backend engineer
Learn to code in 2026 with a realistic, step-by-step roadmap: pick one language, follow a structured path, build real projects, and practice daily until you're job-ready.
SQL CREATE TABLE: How to Create and Alter Tables
by Boot.dev Team - Programming course authors and video producers
The SQL CREATE TABLE statement defines a table, its columns, and the data each column should hold. It can also enforce rules such as required values and unique identifiers.
SQL Indexes: How to Speed Up Database Queries
by Boot.dev Team - Programming course authors and video producers
A query that slows down as its table grows may be scanning far more rows than it returns. SQL indexes give the database a faster route to matching rows, often letting it jump to a small set instead of inspecting the whole table.
Database Normalization: 1NF, 2NF, and 3NF
by Boot.dev Team - Programming course authors and video producers
Database normalization gives each fact in a relational database one reliable home. It reduces duplicate data and prevents rows from contradicting each other. The first three normal forms, 1NF, 2NF, and 3NF, provide a practical way to find those problems.
What Is SQL?
by Boot.dev Team - Programming course authors and video producers
SQL (Structured Query Language) is the standard language for working with relational databases. You use it to define tables, read data, insert records, update records, and delete records. It's everywhere in backend development and data analysis because it handles repeatable queries over large datasets without spreadsheet busywork.
SQL Joins: INNER, LEFT, RIGHT, and FULL JOIN
by Boot.dev Team - Programming course authors and video producers
Relational data is often split across tables, but applications need it brought back together. SQL joins combine those rows: an INNER JOIN keeps matches, a LEFT JOIN or RIGHT JOIN preserves one side, and a FULL JOIN preserves both.
SQL Subqueries With Examples
by Boot.dev Team - Programming course authors and video producers
Sometimes one query needs the result of another. A SQL subquery nests that inner query inside another SQL statement so its value or result set can filter, calculate, or select data.
SQL SELECT Statement
by Boot.dev Team - Programming course authors and video producers
The SQL SELECT statement reads data from a database. Every read query begins by describing the result you want: stored columns, calculated values, or a combination of both. At its simplest, SELECT name FROM users; returns the name column from every row in users. Real queries can select several columns, rename them with aliases, remove duplicate results, and combine SELECT with clauses that filter, group, sort, or limit rows. This guide starts with the basic syntax, then explains wildcards, expressions, DISTINCT, clause order, and the mistakes that most often make a query fail or return a surprising result.
SQL Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, and NOT NULL
by Boot.dev Team - Programming course authors and video producers
SQL constraints prevent invalid data from entering a database. PRIMARY KEY, FOREIGN KEY, UNIQUE, and NOT NULL identify rows, preserve relationships, reject duplicates, and require values.
SQL WHERE Clause
by Boot.dev Team - Programming course authors and video producers
The SQL WHERE clause filters out rows that don't meet a condition. It lets a SELECT return specific records and keeps an UPDATE or DELETE from touching rows it shouldn't. You can build its conditions with comparisons, NULL checks, AND, OR, IN, and BETWEEN.
SQL ORDER BY and LIMIT
by Boot.dev Team - Programming course authors and video producers
SQL's ORDER BY clause sorts query results, and LIMIT caps how many rows the database returns. Together, they answer questions like "Which five products cost the most?" Sort direction and tie-breakers determine the order; without ORDER BY, LIMIT doesn't define which rows you'll get.
SQL CRUD: Create, Read, Update, and Delete Data
by Boot.dev Team - Programming course authors and video producers
SQL CRUD is the set of operations you use to create, read, update, and delete data in a relational database. In SQL, those operations usually map to INSERT, SELECT, UPDATE, and DELETE.
SQL Aggregate Functions: COUNT, SUM, AVG, MIN, and MAX
by Boot.dev Team - Programming course authors and video producers
SQL aggregate functions calculate one result from a set of rows. An aggregate query can return an order count, total revenue, average payment, lowest price, or highest score. The five you'll use most are COUNT, SUM, AVG, MIN, and MAX. GROUP BY, HAVING, and NULL values control what they calculate.
SQL LIKE Operator
by Boot.dev Team - Programming course authors and video producers
The SQL LIKE operator filters text using a simple pattern. Use it when you know part of a value but not the whole thing: a name that starts with Al, an email address that ends with a company domain, or a product name that contains banana. Its two wildcards, % and , stand in for unknown characters. Case sensitivity depends on the database.
The Boot.dev Beat. July 2026
by Lane Wagner - Boot.dev co-founder and backend engineer
In June we made a lot of updates to what's inside existing Boot.dev content. You can now work through the Linux course in a real in-browser shell, take multi-question quizzes, format your code with one click, and use OpenRouter on our AI-dependent courses.