Home / Learning

Learning

Hands-on training sessions: build something end to end, step by step, with exercises and a knowledge check. 10 sessions.

Azure

Azure / Learning

Learning: Azure networking for beginners - VNets, subnets, peering, NSGs, private endpoints and private DNS, built and tested with the Azure CLI

A hands-on learning session. Build two VNets with VMs that have no public IPs, prove they can't talk, peer them, control traffic with NSG rules and read the effective rules, then reach a storage account over a private endpoint, see private DNS working (and failing), and switch off public access. Exercises and a knowledge check included.

11 min readBeginner

OCI

OCI / Learning

Learning: OCI foundations for beginners - compartments, IAM policies, a VCN, a compute instance, block storage and Object Storage with the OCI CLI

A hands-on learning session. Set up the OCI CLI, create a compartment and an IAM policy, build a VCN with an internet gateway and a public subnet, launch a Linux instance and SSH to it, attach and mount a block volume, store a file in Object Storage and share it with a pre-authenticated request, then clean everything up. Exercises and a knowledge check included.

11 min readBeginner

Databricks on Azure

Databases

MySQL / Learning

Learning: MySQL InnoDB Cluster for beginners (part 1) - build a 3-node cluster on one machine, connect through MySQL Router and watch a failover

A hands-on learning session. Learn what InnoDB Cluster, Group Replication, MySQL Shell and MySQL Router each do, then build a three-member sandbox cluster on your own laptop or a single VM, connect an application through Router, kill the primary and watch the cluster elect a new one, do a planned switchover and clean up. Exercises and a knowledge check included.

12 min readBeginner

MySQL / Learning

Learning: MySQL InnoDB Cluster advanced (part 2) - production build, security, monitoring, failure recovery, backups, rolling upgrades and ClusterSet DR

A hands-on learning session for people who have built a lab cluster. Design and build a three-node InnoDB Cluster across availability zones, harden it with TLS and allow-lists, deploy MySQL Router properly, monitor Group Replication, recover from expelled members, lost quorum and complete outages, take backups, do rolling upgrades, and add a second region with InnoDB ClusterSet. Exercises and a knowledge check included.

15 min readAdvanced

Oracle / Learning

Learning: Oracle RMAN backup and recovery for beginners - ARCHIVELOG mode, your first backups, a lost datafile and a full PDB recovery

A hands-on learning session on a free Oracle Database container. Switch to ARCHIVELOG mode, set up a fast recovery area, configure RMAN, take and check backups, delete a datafile on purpose, restore and recover the pluggable database without losing committed data, then validate and tidy up backups. Exercises and a knowledge check included.

9 min readBeginner

SQL Server / Learning

Learning: Azure SQL Database advanced - private networking, security, failover groups, performance tuning and CI/CD

A hands-on learning session for people who already run Azure SQL Database. Lock the server down with a private endpoint and Entra-only access, connect an app with a managed identity, turn on auditing, Defender and customer-managed TDE keys, build a geo-replicated failover group and test failover, tune with Query Store, automatic tuning and DMVs, compare Hyperscale and elastic pools, protect data with ledger and long-term retention, and deploy schema changes with dacpacs from a pipeline. Exercises and a knowledge check included.

16 min readAdvanced