Publishing archive
Wednesday
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 |
The highlighted days are the ones with something published; those are clickable.
Society
Shanraq’s new course explains SQL through a familiar everyday problem: keeping track of household income and spending. Across 13 practical lessons, learners progress from a first table to an auditable report, an index, and a verified backup. Queries can be run directly in a browser on a computer, tablet, or phone.
IT
Calculate the balance after every event and rank spending while keeping each source row.
IT
Compute display columns, handle NULL honestly, and define month boundaries.
IT
We identify the project's accounts, categories, transactions, and limits, and separate a missing value from zero. Before learning syntax, understand the single fact represented by each row.
IT
Insert one or several transactions and keep user values separate from SQL code.
IT
Create the family-budget tables and move essential validation into the database.
IT
Use control totals, duplicate candidates, and relationship checks to test completeness.
IT
Break the savings-rate calculation into named, testable CTE stages.
IT
Make safe corrections and treat a transfer as one atomic database operation.
IT
Assemble the report, inspect its plan, add a justified index, and prove a backup by restoring it.
IT
Normalise the budget model and join tables by stable keys without multiplying rows.
IT
Compress transactions into auditable totals and detect limits that were exceeded.
IT
Learn projection, filtering, stable sorting, and limiting a result.
IT
In the first lesson, we open a ready-made family-budget database and calculate income, spending, and savings with one query. SQL is useful when an answer must be exact, repeatable, and auditable rather than assembled by hand.
