The Logic Decode blog

Every article, one place

Tutorials, deep-dives, and the trends that actually matter — filter by topic below.

Browse the full archive of 115 articles →

All Python Web Dev AI & ML DevOps CS News

Git Basics: Create Your First Repository

Install Git, set your name and email, run git init, and read git status. The very first steps to put a project under version control.

Jul 26, 20267 min

DevOps

Why Git? Version Control, Explained

What Git and version control are, the problems they solve, and the mental model of commits as save points, the safety net under every project you build.

Jul 26, 20268 min

Web Dev

SQL Project: Design and Query a Database

Put it together: design a small library database with SQL, create the tables, add data, and answer real questions with joins and aggregates. Fully runnable.

Jul 25, 202611 min

Web Dev

SQL Window Functions, Explained Simply

Window functions in SQL without the headache: OVER, PARTITION BY, ROW_NUMBER, RANK, and running totals. Keep every row while you rank and total, live.

Jul 25, 20269 min

Web Dev

SQL Indexes and Query Performance

Make SQL queries fast: what an index is, when to add one with CREATE INDEX, reading EXPLAIN QUERY PLAN, and the trade-offs, explained simply, with examples.

Jul 24, 20268 min

Web Dev

Database Relationships and Foreign Keys

Model relationships in SQL: one-to-many and many-to-many, foreign keys, and how the orders/customers/products tables connect, with a diagram and live queries.

Jul 24, 20269 min

Web Dev

Creating Tables and Schema in SQL

Design tables with SQL: CREATE TABLE, column data types, PRIMARY KEY, NOT NULL, DEFAULT, and UNIQUE constraints. Build and query a table live in your browser.

Jul 23, 202610 min

Web Dev

SQL INSERT, UPDATE and DELETE

Change data in SQL: INSERT new rows, UPDATE existing ones, and DELETE safely, plus why a missing WHERE is dangerous. With live, runnable examples.

Jul 23, 20268 min

Web Dev

SQL Joins: INNER, LEFT and How They Work

Combine tables in SQL with joins: INNER JOIN, LEFT JOIN, join keys, and joining three tables, explained with a diagram and live, runnable queries.

Jul 22, 20268 min