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.
AD FundamentalsForests, domains, OUs, Kerberos vs NTLM, DC deployment, FSMO roles, replication, users, groups, GPO, and AD-integrated DNS.
AD AdvancedFine-grained password policies, gMSAs, two-tier PKI with AD CS, LDAPS, ADFS & SAML federation, tiered admin model, and security auditing.
PowerShell — Zero to AutomationObject pipeline, variables, flow control, functions, PSRemoting, modules from PSGallery, and real-world AD + fleet automation scripts.