Course catalog
Found: 8 courses of 8
A working course in T-SQL for QA engineers in professional services firms who already know the basics — SELECT, WHERE, a simple JOIN — and now need SQL as a daily testing instrument rather than as a topic. Everything is set in ENGAGE, the fictional engagement and billing platform of Aldervane Advisory LLP: clients, engagements, staff, timesheets, approvals, invoices, an audit log and a migration staging table. One schema, carried through every unit, so the examples are the ones you actually meet — a report total that disagrees with the raw rows, a record the UI claims it saved, a migration that quietly dropped a hundred time entries, a duplicate that only appears under a business key. Each construct is introduced the same way: the problem that makes you reach for it, the construct itself, and the price it charges. LEFT JOIN buys you the missing rows and charges you row multiplication. NOLOCK buys you speed on a shared environment and charges you dirty reads. A green test that never asked the right question costs more than a red one. Nineteen core units cover reading an unfamiliar schema, staying safe on a shared test environment, NULL and three-valued logic, data types and collation, dates and time zones, joins and orphan records, set operations as reconciliation, aggregation, subqueries, CTEs, window functions, test data setup and idempotent teardown, verifying what the application wrote, reading someone else's views and triggers, and turning a SQL check into a deterministic assertion. Five optional units add a local sandbox script, execution plans, client data and AI assistants, an end-to-end migration reconciliation checklist, and normalisation as an explanation of why the schema looks the way it does. Units are open in any order: come for the whole course, or come for the one thing that is biting you today. Scope note: the course teaches you to write queries and to read them. Practice covers both; the certification exam checks reading, recognition and knowledge of constructs, since a written query cannot be machine-verified here.
Testing and QA · intermediate · 24 units · ~20.4 h · material in English · author: Andrey Kuralekh
English: Phrasal Verbsdemo course
A basic set of English phrasal verbs: how they differ from a verb with a preposition, verbs about people and relationships, verbs about actions and plans.
Languages · beginner · 3 units · ~1.5 h · material in Русский · author: Andrey Kuralekh
A full working course on Playwright with TypeScript for QA engineers in large professional-services firms (Big 4 and similar). It covers the same ground as a comprehensive "zero to hero" Playwright curriculum: TypeScript essentials for test code, installation and project layout, running and debugging (CLI, UI mode, Inspector, codegen, Trace Viewer), locators and the strictness rule, web-first assertions, auto-waiting and the timeout hierarchy, every common UI component (inputs, checkboxes, radios, dropdowns, tooltips, dialogs, tables, date pickers, sliders, iframes), the Page Object Model and a scalable page architecture, custom fixtures, configuration and projects, environment variables and mobile emulation, authentication reuse through storageState, artifacts and reporters, visual regression testing, API requests, network interception and mocking, parallelism, retries, tags and flakiness control, Docker and CI on GitHub Actions. Every topic is taught the same way: the problem that exists without the feature, the feature that solves it, and the price you pay for using it. The course is written for people who will maintain a suite on a client engagement for years, not for people writing a demo test once — so review criteria, evidence for audit, secret handling and cost of maintenance are part of the material, not an appendix. By the end you should be able to build and maintain a Playwright suite unaided, and to pass an external certification-style exam on the same syllabus.
Testing and QA · intermediate · 27 units · ~36.5 h · material in English · author: Andrey Kuralekh
Exam-focused preparation for AZ-900: Microsoft Azure Fundamentals, built strictly against the skills measured as of 20 July 2026. Nineteen required units cover all three domains at their official weights: cloud concepts, Azure architecture and services, management and governance. Every service is taught as pain, then solution, then cost — because the exam asks which option fits a constraint, not what a service is called. A dedicated unit untangles the pairs candidates confuse most: Advisor and Monitor and Service Health, VPN Gateway and ExpressRoute, RBAC and Policy and resource locks, Cool and Archive, availability zones and region pairs. Three optional units cover databases, traffic delivery and secrets — useful at work, explicitly out of exam scope. Course text is in Russian; Azure service names stay in English, as you will meet them on the exam and in the portal.
Infrastructure and cloud · beginner · 22 units · ~36 h · material in Русский
English Phrasal Verbs (Extended)no practice tracking
An extended course of English phrasal verbs for B2–C1. The first half is built around the most frequent base verbs (do, make, get, take, give, come, put, run, set, keep, go, turn, bring, see, play, draw, call, hold, lay, bear, let, work, be), the second around particles (up, down, in, out, on, off, over, through, around/about, with, for, to, of, back, away, at, by, into, after, against, together, as). Separate units cover the syntax of phrasal verbs, the language of movement and road vocabulary, and antonym and synonym clusters. The course insists that a particle carries a stable meaning of its own: once you grasp the logic of up/down/out/off, you start inferring what unfamiliar combinations mean instead of memorising them as a list. The syllabus (scope and order of topics) follows Dave Nicholls, «Visual Phrasal Verbs» (2019); all explanations, examples and exercises were written anew for this course.
Languages · advanced · 18 units · ~45 h · material in Русский · author: Andrey Kuralekh
Business writing in English for software engineers in Big 4 consulting. The course is not about the format of a letter but about pragmatics: why a Russian-speaking professional is heard as blunter than they are, and how that is fixed. Its axis is room for refusal: an English business message leaves the reader a way to object, decline or explain, and that room is created by the text rather than assumed. Six classes of softening, a 22-item RU→EN interference register, the softening ceiling (where directness is mandatory), the grammar of blameless causation. Genres: client email, code review, chat and tracker, escalation, refusal and change request, status and RAG, incident communication. Every example comes from an engineer’s working day on a project. Entry level B1–B2, model answers are given at two levels.
Languages · intermediate · 20 units · ~29.5 h · material in Русский · author: Andrey Kuralekh
English Conditionals (Extended)no practice tracking
An extended course on English conditionals for B1–C1, written for students and professionals in IT. It goes beyond the school four — zero / first / second / third — and builds on the Celce-Murcia and Larsen-Freeman classification (factual, future-predictive and imaginative conditions), so you learn to choose a structure by meaning — fact, habit, implication, inference about the past, prediction, command, advice, hypothesis, the impossible — rather than plugging in «type two». Separate branches cover mixed conditionals, modals in the result clause, connectors other than if (unless, otherwise, provided that, as long as, only if, supposing, even if, whether or not) and the formal register with inversion (Should you need…, Had we known…). Every example and exercise comes from a developer’s working context: documentation and specifications, estimates, SLAs and contracts, code review, incident analysis, ADRs and RFCs, on-call and runbooks. The course ends with a practicum: a postmortem, a stakeholder email and a pull request comment, all written with conditionals.
Languages · intermediate · 16 units · ~13.5 h · material in Русский · author: Andrey Kuralekh
A hands-on course on using large language models across the test process: prompting for test analysis and design, evaluating what the model gives back, containing its risks, and rolling it out in an organisation that handles client data. Built around a professional-services engagement, where confidentiality and documented review are not optional. Assumes working knowledge of test design, test levels and defect management.
Testing and QA · intermediate · 21 units · ~15.6 h · material in English · author: Andrey Kuralekh