SQL — Basic to AdvancedSELECT through recursive CTEs, window functions, subqueries, data modification, and CASE WHEN.
Hyper-V — Installation & ProductionHardware requirements, enabling Hyper-V, virtual switches, VM provisioning, checkpoints, and security hardening.
Datacenter FundamentalsUptime tiers, hot/cold aisles, spine-leaf topology, SAN vs NAS vs object storage.
HCI & Storage Spaces DirectHow HCI works, S2D architecture, Azure Stack HCI, resiliency settings, and deployment steps.
Networking FoundationsOSI model, IPv4 addressing, private ranges, binary and subnet mask concepts.
Subnetting (with live calculator)CIDR notation, subnet math, splitting networks — plus an interactive in-browser calculator.
VLANs & Inter-VLAN RoutingAccess vs trunk ports, 802.1Q tagging, SVIs on Layer 3 switches, and native VLAN security.
Routing, DNS & DHCPStatic routes, OSPF, BGP overview, DNS record types, DORA process, and rogue DHCP protection.
Firewalls & DMZ ArchitectureStateful vs NGFW, DMZ design, default-deny rules, and least-privilege firewall policy.