Your next chapter / Lesson library

UNDERSTAND IT. TRY IT. EXPLAIN IT.

Your lesson library.

Practical lessons, written in simple English. Start with the basics and build from there.

Using Windows, Ubuntu, Laragon, XAMPP, or standalone tools? Choose the setup instructions for your environment.

32 published lessons matching your search.

Professional PHP

PHP iterable data, generators and failure timing

Aggregate validated rows in one pass while distinguishing lazy work, source memory and one-shot traversal.

SQL & MySQL

SQL tables, keys, and constraints

Create related people/tasks tables and observe primary, unique, foreign-key, CHECK and NOT NULL rules.

SQL & MySQL

Join people and tasks without losing rows

Compare inner/left joins, count child IDs, and retain people with zero matching tasks.

SQL & MySQL

MySQL transactions, affected rows and row locks

Verify commit/rollback and held-row conflicts with explicit failure and retry boundaries.

SQL & MySQL

MySQL composite indexes and honest EXPLAIN analysis

Inspect a concrete owner-scoped report, preserve ordered results and distinguish plans from latency measurements.

Laravel core

Laravel routing, validation, and a feature test

Validate a protected task-preview form, select accepted fields and test HTML/JSON failures.

Laravel core

Project: a tested task report and English demo

Build a scoped practice report, collect evidence, and review it with a clearly labelled self-assessment rubric.

Laravel core

Eloquent relationships, eager loading and query evidence

Compare real eager/lazy queries while preserving owner-scoped reports, zero-task parents and explicit memory limits.

APIs & integrations

Laravel owned JSON endpoints and security tests

Verify real saved data, server-owned identity, authorization, selected fields and two-account failure tests.

Data structures & algorithms

Lists, maps and the first repeated ID

Validate a precise contract, find the first repeated encounter and explain expected linear time with extra memory.

Data structures & algorithms

Binary search: boundaries, duplicates and total cost

Find the leftmost match with a shrinking interval, test edge cases and distinguish search-phase cost from full validation cost.

AI literacy & prompting

AI prompt contracts and honest offline evaluation

Build a narrow prompt artifact and separate response shape, permitted evidence and semantic correctness using dummy fixtures.