WARIN.ME

Teaching Tools & Innovation

Reflective teaching tools, laboratories, and experimental systems for understanding learners, educators, subject matter, and educational decisions.

COURSE COLLECTIONS

Start from the course you are learning.

Each laboratory below has a clear home in one course.

COURSE 07

Data Science and Data Engineering

Data systems, machine learning and feature engineering

01
VIEW → DATA CONTRACT

Views for Data Engineering

Begin with reusable semantics, governance and the interface between application and analytics teams.

Continue lesson →
02
BULK MUTATION · CTAS

Bulk UPDATE versus Rebuild

See when row versions, logs, indexes and random writes make read–transform–new table a better candidate.

Continue lesson →
03
OLTP → FEATURE ENGINEERING

Operational data becomes features

See why row-oriented transactions are necessary—but expensive for repeated analytical computation.

Continue lesson →
03
OLAP → FEATURE STORAGE

OLAP Feature Engineering

Move recurring windows and aggregates into analytical structures designed for reuse.

Continue lesson →
04
FEATURE STORE

Feature Store Laboratory

Version, share and serve features while controlling training-serving skew.

Continue lesson →
05
WORKFLOW · AIRFLOW

Airflow Data Workflow Lab

Orchestrate dependencies, retries, schedules and observable data pipelines.

Continue lesson →
06
POSTGRESQL · DUCKDB · CLICKHOUSE · IVM

Data Systems Architecture Labs

Compare OLTP, embedded OLAP, columnar OLAP, materialization and IVM under one data contract.

Continue lesson →
07
POSTGRESQL → DUCKDB · MONTHLY ANALYTICS

PostgreSQL to DuckDB Analytical Bridge

Export bounded monthly snapshots, practise dual write, and compare equivalent analytical queries across both engines.

Continue lesson →
08
XPATH · BEAUTIFULSOUP · SELENIUM

Three-tool Screen Scraping Laboratory

Learn selectors, static HTML parsing and browser automation step by step through one trusted-source task.

Continue lesson →
01
FORMULA-FIRST · MARIADB

From ML formulas to MariaDB SQL

Derive kNN, Naive Bayes, regression, k-means and Z-score before translating operators into SQL.

Continue lesson →
02
PURE SQL · NO PYTHON

Machine Learning with Pure SQL

Open the black box across six model families and compare the DuckDB edition with MariaDB.

Continue lesson →
03
RECOMMENDATION · SQL

Recommendation Systems with SQL

Build popularity, co-occurrence, collaborative, content, temporal and hybrid ranking.

Continue lesson →
04
DUCKDB · PDPA · DATA FOUNDATION

NextGenEd Data Foundation

Design a questionnaire, versioned consent, participant-controlled CRUD, simulation assumptions and ERD before introducing a model.

Continue lesson →
05
DECLARATIVE ML

Declarative Machine Learning

Distinguish SQL-native algorithms from SQL-callable ML services and commercial platforms.

Continue lesson →
06
POSTGRESQL · MADLIB

In-Database ML with MADlib

Use a mature library after understanding what its SQL interface hides.

Continue lesson →
07
DUCKDB × CLICKHOUSE

Declarative ML Live Lab

Compare embedded and server OLAP execution boundaries with the same analytical intent.

Continue lesson →
08
ONLINE ML · PRODUCTION · DRIFT

Three Common Ways of Online ML

Separate online inference, online features and true online learning, including delayed labels and drift.

Continue lesson →
01
COMPOSITE · SHARED STATE

Composite Features and Shared Computation

Find expensive shared structure and avoid recomputing it across dependent features.

Continue lesson →
02
RFM · CUSTOMER MOVEMENT

RFM Analysis and Churn Signals

Select a customer, derive RFM snapshots and interpret multi-period slopes without mistaking a heuristic for probability.

Continue lesson →
03
REPRESENTATION

Representation as Features

Compare PCA, SVD, NMF, projections, embeddings and model-derived scores with leakage control.

Continue lesson →
04
BIOINFORMATICS

Bioinformatics Feature Laboratory

Trace sequence and structural features, their complexity and the value of storing reusable results.

Continue lesson →
05
FINANCIAL DATA

Financial Feature Laboratory

Interpret trend, momentum, volatility, volume, liquidity and risk without turning indicators into advice.

Continue lesson →
06
12 DOMAINS

Domain Feature Engineering Atlas

Compare feature meaning, computation cost and interpretation across twelve specialist domains.

Continue lesson →
07
DEEP LEARNING

Deep Learning Changes the Boundary

Understand what representation learning automates—and what information it cannot recover.

Continue lesson →

COURSE 01

Network Computing / Computer Networks

Routing and loop-free network topology

COURSE 04

Parallel and Distributed Systems

Parallel search and communication between workers

COURSE 05

Data Structures and Algorithms

Indexes, search, scoring and explainable heuristics

COURSE 06

Artificial Intelligence and Machine Learning

Applied AI, bioinformatics and reversible online learning

CROSS-COURSE COLLECTION

Use across courses and teaching contexts.

These tools support teaching decisions, reflection and assessment rather than one subject area.

GENERAL TEACHING TOOLS

Turn teaching judgment into inspectable evidence

Tools for educational beliefs, teaching decisions and multi-objective assessment.