Course catalog
Found: 5 courses · 15 in the catalog
An empty spot on a card says nothing: the “recommended” seal stands where moderation put it, and the subject area is there when it has been assigned.
Tagged professional-services · Remove the tag
Version 1.0.0, 29 September 2026
level: advanced
A course for senior developers at Big 4 and other professional-services firms who already use GitHub Copilot — or are about to be told to — and want to use it as an engineer rather than as a faster autocomplete. Copilot in 2026 is an agent platform: agent mode and a Plan agent in Visual Studio 2026 and VS Code, specialised agents for debugging, profiling, testing and .NET modernisation, custom agents and skills your team keeps in the repository, MCP servers, cloud agents that return pull requests, and Copilot CLI in the terminal. The course teaches the skills that separate a senior from a passenger: engineering the context, splitting a task into a plan the agent can execute, reviewing an AI diff as critically as a colleague's, encoding team rules once so they work in every IDE, and knowing exactly what leaves the client's perimeter — and what it costs in AI Credits. Every capability is taught the same way: the pain that makes you reach for it, the capability itself, and its cost — including the uncomfortable ones, such as content exclusion not applying in agent mode, or a green test suite that an agent wrote to match its own bug. The mandatory track follows the official GH-300 (GitHub Copilot) exam outline, so the course doubles as certification preparation; optional units go deeper into Copilot CLI automation, hooks, model and cost engineering, and measuring real productivity. Labs use one sample repository — Aldervane Advisory LLP's ENGAGE platform — that opens in Visual Studio 2026, VS Code and the CLI alike; it is a public GitHub template (github.com/AndreyKuralekh/engage), so each learner starts from their own copy. Every lab also has a read-and-answer path for learners without a Copilot Business or Enterprise seat.
25 units · ~29.5 h without the optional units, ~34.5 h with them · material in English · author: Andrey Kuralekh
Version 1.0.0, 28 September 2026
level: beginner
A preparation course for Microsoft exam AI-901 (Microsoft Azure AI Fundamentals), written for software engineers in Big 4 and other professional-services firms who already write SQL, C# and Python and now need a working grasp of AI on Azure — and the certificate that proves it. AI-901 replaced AI-900 in 2026 and changed its character: more than half of the exam is about building with Microsoft Foundry — deploying models, writing prompts, building agents, and calling text, speech, vision and Content Understanding capabilities from lightweight Python apps. The course follows the official skills outline (April 2026 revision) domain by domain, with the same weights: AI concepts and capabilities (40–45%) and implementing AI solutions with Foundry (55–60%). Every topic is taught the same way: the problem that makes you reach for the capability, the capability itself, and what it costs — in tokens, quotas, latency, data residency and risk. Hands-on labs walk through the Foundry portal and the Python SDK step by step; if your corporate subscription blocks Foundry, each lab has a read-the-code path so you can still practise every exam objective. The running case is Aldervane Advisory LLP, a fictional professional-services firm building an internal Service Desk agent, extracting data from invoices and timesheets, and transcribing client meetings — where confidentiality of client data is never optional. Practice uses the question formats of the real exam: single and multiple choice, matching, Yes/No statement sets and code completion. Visual sketchnotes summarise each concept on one colourful page. Optional units cover the same apps in C#, quotas and cost, evaluation and tracing, and client-data governance.
24 units · ~27.8 h without the optional units, ~33.8 h with them · material in English · author: Andrey Kuralekh · recipes: 1
Version 1.1.0, 28 September 2026
level: intermediate
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 · 21 units · ~18.4 h · material in English · author: Andrey Kuralekh
Version 1.1.0, 27 September 2026
level: intermediate
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 · 24 units · ~19.4 h without the optional units, ~24.1 h with them · material in English · author: Andrey Kuralekh
Version 1.0.1, 4 October 2026
level: intermediate
A preparation course for Microsoft exam PL-300 (Microsoft Power BI Data Analyst), written for senior developers in Big 4 and other professional-services firms who already think in SQL and code — and keep getting surprised by DAX. The course follows the official skills outline (April 2026 revision) with its four domains and weights: prepare the data (25–30%), model the data (25–30%), visualize and analyze the data (25–30%), and manage and secure Power BI (15–20%). It covers what the 2026 updates added: Direct Lake, calculation groups, visual calculations, DAX query view and Copilot in Power BI. The spine of the course is the shift from SQL thinking to DAX thinking: filter context, row context, CALCULATE and context transition, taught with small models you can compute in your head before you check them in Power BI Desktop. Every topic follows the same order: the pain, the solution, and what it costs — memory, refresh time, query latency, licences or security risk. Labs run in Power BI Desktop (free) on a synthetic Aldervane Advisory LLP dataset — timesheets, invoices with three role-playing dates, month-end WIP balances and a nested JSON export — published on GitHub. Service features (workspaces, apps, RLS, refresh) are shown step by step, with a free route to a sandbox tenant and a read-the-screenshots path for learners whose corporate tenant blocks publishing. Practice uses the formats of the real exam: single and multiple choice, matching, Yes/No statement sets, "what does this measure return in this cell" and DAX completion. Isotype-style pictures summarise one idea each. Optional units cover PBIP/TMDL and Git, a SQL-to-DAX phrasebook, client-confidentiality patterns and the bridge to Microsoft Fabric.
28 units · ~51 h without the optional units, ~59 h with them · material in English · author: Andrey Kuralekh